Training Details
Course Overview
Master Excel’s most powerful features for complex data analysis and business intelligence. This advanced program covers database functions, sophisticated lookup techniques, and cutting-edge Excel features. Perfect for professionals who need to handle large datasets, perform complex analysis, and create sophisticated business models.
Training Details
Who Should Attend
- Senior analysts and data professionals
- Finance managers requiring complex modeling capabilities
- Business intelligence specialists
- Advanced Excel users seeking to master the latest features
Prerequisites
Completion of Excel Intermediate training or demonstrated proficiency with advanced formulas, pivot tables, and data management.
Training Details
Duration & Format
1 Full Day (8 Hours) – Intensive hands-on workshop
Module 1: Advanced Formulas
- Using Database Functions DSUM etc.
- Calculating Working days and Due Date using Dates Functions
- Using Offset, Index and Match Function to look for values
- Using 3D Functions SUMPRODUCT based on multiple criteria
- Using Array functions like Filter, Sort, SORTBY, Unique etc.
- Consolidate Data using VSTACK Function (Latest)
Module 2: Auditing Worksheets
- Tracing Precedents
- Tracing Dependents
- Showing Formulas
Module 3: Data Tools
- Converting Text to Columns
- Controlling Calculation Options
- Data Validation
- Consolidating Data
Module 4: What-If Analyses
- Goal Seek
- Data Tables
- Use the Scenario Manager
Module 5: Using Pivot Tables
- Creating Pivot Tables
- Inserting Slicers
- Working with Pivot Tables
- Inserting Pivot Charts
- More Pivot Table Functionality
Module 6: Microsoft Excel New Features
- Using Slicers to Filter Data
- Flash Fill
- Creating a PivotTable Timeline
Schedule a Meeting
Contact With Us
BizConsult International Head Office IH-161, Falcon Complex, New Malir Karachi, Pakistan