top of page

Advanced Excel

Course Curriculum:

Formulas And Functions:

  • Math And Trig Functions (sum, sumproduct, int, round, power, fact, mod, sqrt, .....)

  • Statistical Functions (average, countif, counta, correl, frequency, large, small, .....)

  • Text Functions (len, right, left, concatenate, trim, upper, lower, proper, exact, .....)

  • Date And Time Functions (today, now, year, day, hour, minute, datedif, .....)

  • Financial Functions (pmt, fv, pv, cumipmt, cumprinc, sln, .....)

  • Logical Functions (and, or, if, .....)

  • Lookup And Reference Functions (vlookup, hlookup, xlookup.....)

  • And Much More.....

Features And Options:

  • Conditional Formatting

  • Cell Formats

  • Sort And Filter

  • Absolute Reference And Pivot Table

  • Charts And 3D Maps

  • Sparkline's And Links

  • Slicer And Timeline

  • Text To Columns And Flash Fill

  • Data Validation, Data Table And Goal Seek                         

  • Protection And Printing

  • Macros (VBA Not Included)

  • Add-Ins, Forecasting, Dashboard

  • Problem Solving Using ChatGPT

  • And Much More.....

Training Includes:

  • Brain-Point Workbook With 92 Practical Exercises

  • Brain-Point's Practical Exam & Certificate

Training Duration: 44 Sessions (2 Months)

Lump Sum Fees:  â‚¹â€‹6,500 /-​

🎯 Why Choose Advanced Excel?

​

✅ First 2 Trial Sessions - Absolutely Free.

✅ 100% Practical Learning - An Industry Focused Syllabus.

✅ Boost Your Resume – Gain Skills that Employers Demand Across All Industries.

bottom of page