Advance Excel Training

Advance Excel is one of the most asked-for skills in offices, banks, accounts departments and MIS roles. This course at Aptech Fatehabad takes you beyond basic Excel to professional data handling: powerful formulas and lookups, cleaning and analysing large data, Pivot Tables, What-If analysis and interactive dashboards. You also learn to protect workbooks and automate repetitive work with macros. Every topic is practised on real office-style data, so you are ready to use Excel confidently at work.

Advance Excel Training Course Content

Excel Essentials Refresher

•     Relative, absolute and mixed cell references
•     Named ranges
•     Custom number formats
•     Data entry shortcuts and Flash Fill

Formulas and Functions

•     Logical functions: IF, IFS, AND, OR, IFERROR
•     Text functions: LEFT, RIGHT, MID, TRIM, TEXTJOIN
•     Date and time functions
•     COUNTIFS, SUMIFS and AVERAGEIFS
•     Financial functions: PMT, NPV, IRR

Lookup and Reference

•     VLOOKUP and HLOOKUP
•     INDEX and MATCH
•     XLOOKUP
•     Dynamic arrays: FILTER, SORT, UNIQUE
•     INDIRECT and OFFSET

Data Management

•     Excel Tables
•     Sorting and Advanced Filter
•     Data validation and drop-down lists
•     Conditional formatting
•     Remove Duplicates and Text to Columns
•     Importing and exporting data
•     Introduction to Power Query

Data Analysis

•     Pivot Tables and Pivot Charts
•     Slicers and timelines
•     What-If analysis: Goal Seek, Scenario Manager, Data Tables
•     Subtotals, grouping and outlining

Charts and Dashboards

•     Choosing the right chart; combo charts
•     Sparklines
•     Building an interactive dashboard

Protection and Automation

•     Worksheet and workbook protection
•     Sharing, comments and track changes
•     Recording macros
•     Introduction to VBA