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