Conditional formatting (Advanced)

• Examples
• Exercises

Data validation

• Examples
• Exercises
• Create dependent drop-down list

Text to Column

• Examples
• Exercises

Logical functions

• IF function

Statistical functions

• SUMIFS function
• AVERAGEIFS function
• COUNTIFS function

Text functions

• TRIM function
• LEFT function
• RIGHT function
• MID function

Advanced search and reference functions

• VLOOKUP function
• XLOOKUP function

Advanced charts

• Create a chart at a glance
• Create a stacked vertical bar
• Working with pie charts
• Mixed charts
• Create progress charts toward the goal
• Save charts as templates
• Freezing schemes
• Sparklines

Tables

• Examples
• Exercises
• Change table name
• Add columns and rows
• Filter the data
• Create formula
• Use total row
• Remove duplicate row

Pivot tables and charts

• Examples
• exercises
• Rename the pivot table
• Pivot tables operations
• Combine pivot tables
• Calculated fields and items
• Using Slicer
• Update the data
• Pivot charts

Dashboard

• What is dashboard
• Create dashboard
• Format dashboard

Data analysis using What-if analysis?

• Analyze data with targeting
• Analyze data using scenarios
• Analyze data with Solver

• Analyze Data Using Advanced Functions in Excel
• Working with Data
• Creating and Working with PivotTables and Pivot charts
• Creating Dashboard
• Using data Analysis Tools

This training course will be carried out through the use of best practices and the right combination of engaging and purposeful tools such as:

• Practical, relevant case studies
• Group activities and workshops
• Related role plays
• Experiential learning
• Brain storming
• Stimulating mental activities
• Engaging team competitions
• Suitable training Videos

Individuals who need to use Pivot Tables and Pivot chars and more advanced functions to analysis a data in Excel.