At the end of this course, the participants should be able to
• Master the conditional coordination skill
• Master the data validation skill, data filtering, and matrix formulas
• Deal professionally with database, search and reference functions
• Design Professional charts
• Take advantage of the capabilities of pivot tables and charts
• Create interactive worksheets and analyze data in a what-if style

Conditional formatting (advanced formula-based)
• Examples
• Exercises
Verify data using equations
• Examples
• Exercises
Advanced data filtering
• Examples
• Formula-based advanced filtering
Matrix formulas
• Multicellular matrix formulas
• Advantages of using a single matrix formula instead of single formulas
• Single-cell matrix formulas
• Fixed matrices
• Create an array of values in a specific range
• Examples of using single-cell arrays
• Sum the three (major) minimum values in a range
• Cancellation of staged formulas
• Matrix functions
Database functions
• DGET function
• Use the DGET function to perform a two-column search
Advanced search and reference functions
• XLOOKUP function
• MATCH function
• INDEX function
• INDIRECT function
• OFSET function
• CHOOSE 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
• Dealing with lost data
Pivot tables and charts
• Examples
• Exercises
• Pivot tables operations
• Combine pivot tables
• Calculated fields and items
• Using Slicer
• Pivot charts
Automate processes with macros
• Steps to create a micro
• How to put a button for the micro in the taskbar
• Use relative cell references when recording a micro
• Examples
Use form control buttons to create interactive worksheets
• Add a worksheet control
• Examples
• Exercises
Data analysis using What-if analysis?
• Analyze data with targeting
• Analyze data using spreadsheets
• Using a spreadsheet with two variables
• Analyze data using scenarios
• Analyze data with Solver

• Analyze Data Using Advanced Functions in Excel
• Working with Data
• Creating and Working with PivotTables
• Working with Macros
• Data Analysis Tools

This training course will be held in a computer lab where every participant will have his own computer to be able to learn and implement the different skills, where the trainer will perform the skill and the participants will follow by performing the same skill in their computers.

Individuals who need to use Pivot Tables and more advanced functions in Microsoft® Office Excel.