At the end of this course, the participants should be able to:

• Master the conditional formatting skill
• Master the data validation skill and data filtering
• Deal professionally with logical, Statistical and search and functions
• Use references options
• Design charts
• Take advantage of the tables
• Use Macro
• Protect data

Conditional formatting (advanced formula-based)

• Examples
• Exercises

Data Validation

• Examples
• Exercises

Advanced data sorting and filtering

• Examples
• Advanced filtering

Reference types in the formula

• Create Range
• Relative reference
• Mixed reference
• Absolute reference
• 3D references

Logical functions

• IF function
• IFS function
• IFERROR function
• AND function
• OR function

Lookup functions

• VLOOKUP function
• XLOOKUP function

 Charts

• Create a chart at a glance
• Create a stacked vertical bar
• Working with pie charts
• Sparklines

Tables

• Examples
• Exercises
• Rename table name
• Format table
• Create formula in a new column
• Remove duplicate row

Automate processes with macros

• Steps to create a micro
• How to put a button for the micro in the taskbar
• Examples

Use form control buttons to create interactive worksheets

• Add a worksheet control
• Examples
• Exercises

Protect data

• Protect sheet

• Protect workbook

• Use advanced functions (logical and lookup)
• Use advanced filtering, sorting, and conditional formatting
• Work with data validation tools
• Use cell references in a formulas
• Create tables and charts
• Work with macros
• Protect data

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 advanced functions in Microsoft Excel, use automated tools (Macro) and protect data