We conduct 2.5 Months (Only Friday/Only Saturday) Certification in Advanced Excel MIS Reports and Data Analysis which is very meticulously developed Advanced Excel course helps you to develop advanced skills in excel,reporting,data analysis and grow in your career.
Auidance : Advanced Excel Course is designed for international students specifically from United Arab Emirates,Middle East Countries,Singapore,Indonesia,Asian countries.
Call us on +91 9881196664 or mail to email@example.com
International Price : $130
Duration: 2 Months (only Friday/Only Saturday)
Delivery Method : Live online classes
We will be Providing:
1) Live Online lectures for 2 hours each session.
3) Excel files of the course content.
4) Recording of Live Session
5) Life time access for recorded course from our Website and Mobile App.
1) Basics of Excel,Formatting,Database
Excel Operators , Logical &Text formulas.,Formula error checking.Excel Sheet Formatting,Date and time functions,Database functions like DSUM,DAVERAGE,DCOUNT,DGET.
2) Relative,Absolute & Mixed Referencing:
Creating Absolute/Mixed References. Problems with Absolute/Relative Cell Referencing
3) Look up Functions:
VLOOKUP() – a practical perspective.VLOOKUP() w. TRUE and FALSE – When & Why? VLOOKUP() with MATCH()2-D lookup,HLOOK UP,INDEX() and 2 MATCH(),XLOOK UP
4) Pivot Tables, Pivot Charts & Power Pivot:
Creating, Formatting Simple PivotTables.Page Field in a PivotTable.Formatting a PivotTable.Creating/
Modifying a Pivot Chart.
5) Complex & Logical Formulas : IF(), Nested IFs, AND(),OR() Combo Logics; IFERROR().
6) MIS Reporting & Dashboard Techniques :
Automatic row-wise Subtotal,Gridlines,Data Validation (list),Cell-Range Naming,Grouping.Build
Business reports like Sales,Inventory,Salary report,dashboards etc.
7) Advanced Charting & Conditional Formatting :
Creating Multiple Chart Type, Primary, Secondary Chart ,Trend line Charting, Scatterplot, Conditional Formatting
8) Protection, Validation, Consolidation & Import of Data::
Protecting sheets / workbooks / Files. Importing, Consolidate, Data from Text Files/ Web.
9) Macros Application:
Developer tab; Record & Run a Macro,Understanding & Editing VBA Code of Macros.
10) Data Cleaning:
Learn Data Cleaning Techniques.
11) Data Analysis: What if Analysis,Forecast
Faculty has 10+ years experience in Advanced excel training,MIS reporting,Data Analysis and Finance.
Certified Microsoft Excel Expert
She has 10+ years experience as trainer for MS Excel (Basic, Advanced & Macros with VBA), MS Office and MS Access
Sample Certificate :