Diploma In Computer Application
Diploma In Computer Application
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,