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 Schedule: Monday To Friday (1 Hour Per Session)​

Training Duration: Total 44 Sessions (Approx. 2 Months)​

🎯 Why Choose Advanced Excel at Brain-Point?​​
  • ​First 2 Trial Sessions: Absolutely Free.
  • Personal Attention: Students Receive Personal Guidance At Their Own Learning Pace.
  • 26+ Years Of Trust: Brain-Point Has Been Serving Students Since 2000.
  • MOS Expertise: Advanced Excel Training Under The Personal Supervision Of A MOS - Certified Excel                                       Professional With Corporate Training Experience.
bottom of page