Free Course Image Advanced Excel

Free online courseAdvanced Excel

Duration of the online course: 3 hours and 29 minutes

4.43

StarStarStarStarHalf star

(14)

Boost your Excel skills fast with a free online course in Hindi—master formulas, lookups, Pivot Tables, filters, and macros to work smarter.

In this free course, learn about

  • Use absolute vs relative cell references to copy formulas correctly
  • Create and use Named Ranges for clearer, reusable formulas
  • Build logical tests with OR, AND, IF-OR, IF-AND, and Nested IF
  • Calculate loan EMI and interest with PMT, IPMT, and PPMT
  • Find values with LOOKUP, VLOOKUP/HLOOKUP (exact & approximate match)
  • Use MATCH, INDEX, and INDEX+MATCH for flexible lookups
  • Handle and remove #N/A errors in lookup formulas
  • Summarize data using Pivot Tables and Advanced Filter
  • Apply AutoFill and counting functions: COUNT, COUNTA, COUNTBLANK
  • Use conditional counts/sums/averages: COUNTIF(S), SUMIF(S), AVERAGEIF
  • Create running totals and use SUMPRODUCT for advanced calculations
  • Highlight patterns with Conditional Formatting (cell/row coloring rules)
  • Restrict inputs with Data Lists and Data Validation rules
  • Work with date/time and key functions: EDATE, FV, SLN depreciation, Goal Seek, Macros

Course Description

Build the kind of Excel confidence that translates directly into better productivity and stronger job opportunities. This free online course in Hindi is designed for learners who already know the basics and now want to work faster, cleaner, and more accurately with real-world spreadsheets. You will move beyond simple tables into professional techniques used in offices, operations, accounts, analytics, and administration—so you can manage data, make decisions, and present results without getting stuck.

Instead of memorizing steps, you will develop a practical way of thinking in Excel: how cells reference each other, how to design formulas that scale, and how to prevent common mistakes that waste time. You will learn to combine logic functions to handle conditions, automate decisions, and create flexible sheets that respond when inputs change. The course also strengthens your ability to search and connect data across columns and sheets, helping you retrieve the right values reliably when working with large datasets.

You will gain hands-on ability to summarize and analyze information using tools that are essential in everyday reporting. From organizing and filtering data to validating entries and highlighting key results with conditional formatting, you will be able to keep your spreadsheets tidy, readable, and dependable. Financial and date-related calculations are also covered in a practical way, helping you estimate installments, interest components, future values, and time-based metrics used in routine business work.

As you progress, you will learn techniques that speed up repetitive tasks and improve accuracy, including autofill patterns, ranking, and smarter ways to count, sum, and average based on criteria. You will also practice handling errors gracefully so your reports remain stable even when source data changes. By the end, you will be better equipped to build structured worksheets, troubleshoot formula issues, and turn raw data into usable insights. If you want a clear next step after intermediate Excel and prefer learning in Hindi, this course offers a focused path to advanced skills you can apply immediately.

Course content

  • Video class: Advanced excel in hindi Lecture 1 Absolute & relative cell address 05m
  • Video class: Advanced excel in hindi Lecture 2 Define Name Formula 03m
  • Video class: Advanced excel in hindi Lecture 3 OR Function 06m
  • Video class: Advanced excel in hindi Lecture 4 AND Function 03m
  • Video class: Advanced excel in hindi Lecture 5 IF OR Function 04m
  • Video class: Advanced excel in hindi Lecture 6 IF AND Function 03m
  • Video class: Advanced excel in hindi Lecture 13 NESTED IF FUNCTION 05m
  • Video class: Advanced excel in hindi Lecture 7 PMT function loan emi calculation 08m
  • Video class: Advanced excel in hindi Lecture 8 IPMTloan interest calculation 02m
  • Video class: Advanced excel in hindi Lecture 9 PPMT Function 04m
  • Video class: Advanced excel in hindi Lecture 10 LOOKUP Function 04m
  • Video class: Advanced excel in hindi Lecture 11 VLOOKUP WITH EXACT MATCH 05m
  • Video class: Advanced excel in hindi Lecture 12 HLOOKUP WITH EXACT MATCH 01m
  • Video class: Advanced excel in hindi Lecture 14 VLOOKUP WITH APPROXIMATE MATCH 1 02m
  • Video class: Advanced excel in hindi Lecture 15 VLOOKUP WITH APPROXIMATA MATCH 2 04m
  • Video class: Advanced excel in hindi Lecture 18 MATCH Function 03m
  • Video class: Advanced excel in hindi Lecture 19 INDEX Function 04m
  • Video class: Advanced excel in hindi Lecture 20 INDEX & MATCH Function 06m
  • Video class: Advanced excel in hindi Lecture 21 REMOVE NA ERROR 03m
  • Video class: Advanced excel in hindi Lecture 16 PIVOT TABLE 12m
  • Video class: Advanced excel in hindi Lecture 17 ADVANCED FILTER 06m
  • Video class: Advanced excel in hindi Lecture 22 AUTOFILL 01m
  • Video class: Advanced excel in hindi Lecture 23 COUNT 02m
  • Video class: Advanced excel in hindi Lecture 24 COUNTA Function 01m
  • Video class: Advanced excel in hindi Lecture 25 COUNT BLANK Function 01m
  • Video class: Advanced excel in hindi Lecture 26 COUNTIF Function 03m
  • Video class: Advanced excel in hindi Lecture 27 COUNTIFS Function 05m
  • Video class: Advanced excel in hindi Lecture 28 SUMIF Function 04m
  • Video class: Advanced excel in hindi Lecture 29 SUMIFS Function 03m
  • Video class: Advanced excel in hindi Lecture 30 AVERAGE IF Function 03m
  • Video class: Advanced excel in hindi Lecture 31 SUM AS RUNNING TOTAL 03m
  • Video class: Advanced excel in hindi Lecture 32 SUM PRODUCT 01m
  • Video class: Advanced excel in hindi Lecture 33 CONDITIONAL FORMATTING 1 07m
  • Video class: Advanced excel in hindi Lecture 34 CONDITIONAL FORMATTING 2 05m
  • Video class: Advanced excel in hindi Lecture 35 CONDITIONAL FORMATTING COLOUR A CELL 03m
  • Video class: Advanced excel in hindi Lecture 36 CONDITIONAL FORMATTING COLOUR A ROW 03m
  • Video class: Advanced excel in hindi Lecture 37 DATA LIST 02m
  • Video class: Advanced excel in hindi Lecture 38 DATA VALIDATION 03m
  • Video class: Advanced excel in hindi Lecture 39 DATE & TIME 04m
  • Video class: Advanced excel in hindi Lecture 40 POWERFunction 03m
  • Video class: Advanced excel in hindi Lecture 41 PROPER Function 01m
  • Video class: Advanced excel in hindi Lecture 42 FACTORIAL Formula 01m
  • Video class: Advanced excel in hindi Lecture 43 EDATE Formula 01m
  • Video class: Advanced excel in hindi Lecture 44 STRAIGHT LINE DEPRECIATION 02m
  • Video class: Advanced excel in hindi Lecture 45 TRIM Function 01m
  • Video class: Advanced excel in hindi Lecture 46 FV Future value 02m
  • Video class: Advanced excel in hindi Lecture 47 RANK Function 03m
  • Video class: Advanced excel in hindi Lecture 48 CHOOSE Function 03m
  • Video class: Advanced excel in hindi Lecture 49 CHOOSE FORMULA WITH IF FUNCTION 05m
  • Video class: Advanced excel in hindi Lecture 50 GOAL SEEK 04m
  • Video class: Advanced excel in hindi Lecture 51 MACRO 10m

This free course includes:

3 hours and 29 minutes of online video course

Digital certificate of course completion (Free)

Exercises to train your knowledge

100% free, from content to certificate

Ready to get started?Download the app and get started today.

Install the app now

to access the course
Icon representing technology and business courses

Over 5,000 free courses

Programming, English, Digital Marketing and much more! Learn whatever you want, for free.

Calendar icon with target representing study planning

Study plan with AI

Our app's Artificial Intelligence can create a study schedule for the course you choose.

Professional icon representing career and business

From zero to professional success

Improve your resume with our free Certificate and then use our Artificial Intelligence to find your dream job.

You can also use the QR Code or the links below.

QR Code - Download Cursa - Online Courses

More free courses at Office Pack in Hindi

Download the App now to have access to + 5000 free courses, exercises, certificates and lots of content without paying anything!

  • 100% free online courses from start to finish

    Thousands of online courses in video, ebooks and audiobooks.

  • More than 60 thousand free exercises

    To test your knowledge during online courses

  • Valid free Digital Certificate with QR Code

    Generated directly from your cell phone's photo gallery and sent to your email

Cursa app on the ebook screen, the video course screen and the course exercises screen, plus the course completion certificate