top of page

Advanced Excel (AE)

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, nper, rate, 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

  • Pivot Table

  • Charts And 3D Maps

  • Sparklines And Links

  • Slicer And Timeline

  • Text To Columns And Flash Fill

  • Data Validation And Data Table

  • Scenario Manager And Goal Seek

  • Subtotal And Invoice

  • Using Excel With The Web

  • Protection And Printing

  • Basics Of Macros (VBA Not Included)

  • Add-Ins, Forecasting, Dashboard

  • Chat GPT

  • And Much More.....

Training Includes:

  • Workbook With 100 Practical Exercises

  • Brain-Point's (Practical Exam & 'AE' Certificate)

Training Duration: 39 + 7 Extra Sessions (Mon To Fri 1 Hour)

Note: After Completion Of This Course Student Can Opt For "Microsoft's International Certificate Exam"

For Better Job Opportunity.

bottom of page