Excel Business Workshop
WorkshopTickets Closed. To check more events click here
Description
Business Excel workshop
will train you From Basic to Advanced Excel.
Level 1 - Basic
▀▀▀▀▀▀▀▀
1- Make preface for all tools in Excel
2- Make a lot of tables
3- Make analysis data formatting
4- Use Data validation
5- Use Conditional format
6- Make Password
7- Make protection
8- Use Hyperlink
9- Find and filter
10- How to print
Level 2 - Advanced
▀▀▀▀▀▀▀▀▀▀
• Chapter 1:
- Creating Full Data Base.
• Chapter 2:
- Make Analysis for Data by
(custom Filter – Hyperlink – co-national
formatting – Data validation – text to columns- move or copy for Sheet).
• Chapter 3:
- Make Analysis by Pivot table
- Summarizing data using Pivot Tables
• Chapter 4:
- Use Formulas
(sum ifs – count ifs -sum if – count if – sum –count- H lookup – lookup – subtotals – substitute - V lookup – sum product -if –and - if and – if error – Abs –trim – proper –upper –lower –m round )
Questions or Comments