Microsoft
Excel
Provide Basic/Advanced
Understanding of Excel, make user familiar to create formula and give platform
to make good analysis and introduce Powerful tools of advance excel so that
user can make advance analysis with the help of those tools. Introduction to
Excel, Basic Understanding Menu and Toolbar, Introduction to different category
of functions like Basics, Mathematical and Statistical, Date and Time, Logical,
Lookup and References, Text and Information.
Mathematical Functions:- Sum,
Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea,
Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup,
Rounddown, Round, Sumproduct
Text Functions & Data
Validation:-
Statistical Function & Other
Functions:-
Logical Functions:- And,
Or, If, Iferror, Not, Nested If
Lookup & Reference
Functions:-
Pivot Table and Charts, Import and
Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print
Display
Data Collection Method With Data
Quality, Collaboration & Security Like Share Your Workbook On Share Drive
With Quality
Analysis Single/Multidimensional
Analysis, Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data
Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data
Table, Two-Variable Data Table
Advanced Excel training course involves
"Hands-on experience", we believe in practice what you preach and
therefore each candidate is encouraged to practically conduct each topic that
is discussed for better understanding of real-world scenar Advanced Excel. This
practice of comprehensive training allows candidate to gain all the concepts
and skills effectively and to later efficiently apply on their field of work.
GVT
Academy
Get in Touch:
Email: gvtacademy@gmail.com
Call: +91 9718394718