Saraswati Infotech · Course Details
Advanced Excel
Learn advanced formulas, functions, data validation, sorting, filtering, charts, Pivot Tables, dashboards and professional data analysis techniques using Microsoft Excel.
Course Overview
Learn advanced formulas, functions, data validation, sorting, filtering, charts, Pivot Tables, dashboards and professional data analysis techniques using Microsoft Excel.
Course Subjects
SIIT-EXL02-01
Advanced Excel Fundamentals & Data Management
SIIT-EXL02-02
Advanced Formulas, Functions & Dynamic Arrays
SIIT-EXL02-03
Lookup, Reference & Logical Functions
SIIT-EXL02-04
Data Analysis, What-If Analysis & Forecasting
SIIT-EXL02-05
Advanced Charts, Visualization & Interactive Dashboard
SIIT-EXL02-06
Pivot Tables, Pivot Charts, Slicers & Data Analysis
SIIT-EXL02-07
Power Query, Data Cleaning & Transformation
SIIT-EXL02-08
Power Pivot, Data Modeling & Advanced Reporting
SIIT-EXL02-09
Macros & VBA Programming for Excel Automation
SIIT-EXL02-10
Excel Automation, MIS Reporting & Final Practical Project