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
-
