Advanced Excel Workshop

Advanced Excel Workshop Content:

- List The Basic Definitions.
- Define How to Use cells and create password or mark as final.
- Select the Speared sheet design and documentation.
-Discuss The Basic formulas and function.
- Classify The Relative and absolute reference.
- Discover How to use to quick access, Insert,
Delete Cells, Flash Fill and Text to Column.
- Discover The Serial concept explanation.
- Discover How to print. ( print titles , print area , orientation)
- Discover How to Create table and design.
- Discover the Conditional formatting.
- Discover How to Protect Sheet, Work Book and How to Freeze row or column.
- Use Sort, Filter, Find and replace, Wrap text or merge, Data validation, Simple if, Remove. duplicate and Nested if.
- Schedule The Functions.
- Discriminate the Sum if, sum ifs , count if, count ifs.
- Create pivot table.
- Formulate of  Format number and Format charts.
- Explain Using slicer and Types of charts.
- Develop a simple Dashboard.

Who Should Attend? 
- All HR levels
Duration & Sessions:
• Total practical hours = 20 hrs.
• Total sessions = 4 Sessions