- Pre-Requisite:
Basic Excel with functions knowledge. - Objective:
Participants can learn how to create advanced workbooks and worksheets and create custom formulas, apply built-in Excel functions and manipulate data to extract desired outputs. - Take Away:
After completing this course, you will be able to apply custom formulas and present data to make informed business decisions.
MS Excel Advanced

Course Details:
1
Lesson 1: Creating Advanced Formulas
- Apply Range Names
- Use Statistical functions like SUMIF, COUNTIF, SUMIFS, COUNTIFS, LARGE, SMALL
- Use Text functions like CONCATENATE, UPPER, LOWER, PROPER, FIND, REPLACE, RIGHT, LEFT, MID, TRIM
- Use Financial Functions like PMT, PV, FV
- Use date functions like NOW, TODAY, YEAR, MONTH, DAY, DATE, NETWORKDAYS, WORKDAYS, DATEDIF
2
Lesson 2: Analyzing Data with Logical and Lookup Functions
- Use Logical and Lookup Functions like IF, AND, OR, NOT, NESTED IF
- VLOOKUP, HLOOKUP, INDEX, MATCH
- How to use multiple VLOOKUP
3
Lesson 3: Organizing Worksheet Data with Tables
- Create and Modify Tables
- Sort and Filter Data
- Advanced Filter
- Use Summary and Database Functions to Calculate Data
4
Lesson 4: Visualizing Data with Charts
- Create Charts
- Modify and Format Charts
- Create a Trendline
5
Lesson 5: Analyzing Data with PivotTables, Slicers, and Pivot Charts
- Create a PivotTable
- Filter Data Using Slicers
- Analyze Data Using Pivot Charts
- Dashboards
6
Lesson 6: Enhancing Workbooks
- Customize Workbooks
- Manage Themes
- Create and Use Templates
- Protect Files and range of data
7
Lesson 7: Automating Worksheet Functionality
- Create and Edit a Macro
- Apply Conditional Formatting
- Add Data Validation Criteria
8
Lesson 8: Analyzing Data
- Create Sparklines
- Perform a What-If Analysis using Goal Seek, Scenarios, Data Table
9
Lesson 9: Working with Multiple Workbooks
- Create a Workspace
- Consolidate Data
- Link Cells in Different Workbooks
- Merge Workbooks
10
Lesson 10: Exporting Excel Data
- Export Excel Data
- Import a Delimited Text File
Onetime payment at the time of admission
Be the first to add a review.
Please, login to leave a review