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, .....)

  • 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)

  • Dashboard (New Feature)

  • And Much More.....

Training Includes:

  • Courseware With 96 Practical Exercises

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

Training Duration: 36 Sessions + 7 Grace Sessions (Mon-Fri 1 Hour)

Instalment Fees: INR 2,700 + INR 2,700 = INR 5,400

Lump Sum Fees: INR 5,200

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

For Better Job Opportunity,

bottom of page