Microsoft Excel Intermediate
Elevate your Excel capabilities with advanced formulas, data management, and visualization techniques. This intensive one-day program bridges the gap between basic Excel knowledge and professional data analysis skills. You’ll master complex functions, work with large datasets, and create dynamic reports that drive business decisions.
Who Should Attend
This course is designed for professionals who have basic Excel experience and want to advance their skills:
- Finance and accounting professionals handling complex calculations
- Business analysts working with large datasets
- Team leaders requiring advanced reporting capabilities
- Anyone seeking to automate repetitive Excel tasks
Prerequisites
Participants should have completed Excel Basic training or demonstrate equivalent knowledge of fundamental Excel operations, basic formulas, and worksheet management.
Duration & Format
1 Full Day (8 Hours) – Available as on-site corporate training or open workshops
Module 1: Advanced Formulas
- Using Named Ranges in Formulas
- Naming a Single Cell
- Naming a Range of Cells
- Using the IF Function
- Using AND/OR Functions
- Using the SUMIF, AVERAGEIF, and COUNTIF Functions
- Using the LOOKUP Function
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Using the CONCATENATE Function
- Using the TRANSPOSE Function
- Using the PROPER, UPPER, and LOWER Functions
- The UPPER Function
- The LOWER function
- The TRIM Function
- Using the LEFT, RIGHT, and MID Functions
- The FIND & LEN Function
- Using Date Functions NOW and TODAY Functions
- Utilize the Watch Window
Module 2: Working with Lists
- Removing Duplicates from a List
- Sorting Data in a List
- Filtering Data in a List
- Adding Subtotals to a List
- Grouping and Ungrouping Data in a List
Module 3: Visualizing Your Data
- Creating a Custom Chart Template
- Inserting Charts
- Sparklines
Module 4: Working with Tables
- Format Data as a Table
- Move between Tables and Ranges
- Modify Tables
- Define Titles
Module 5: Basic Formatting
- Applying Conditional Formatting (Top/Bottom)
- Duplicate / Unique Formatting
- Above / Below Average Formatting
- Custom Formatting
Schedule a Meeting
Contact With Us
BizConsult International Head Office IH-161, Falcon Complex, New Malir Karachi, Pakistan