Advanced Excel
This two day workshop is designed for business users who are familiar with Excel and would like to learn advanced tables, graphs and data functions.
The workshop will benefit users from Sales, Marketing, Human Resources, finance and other functions of the business.
Workshop Outcomes:
The workshop will benefit users from Sales, Marketing, Human Resources, finance and other functions of the business.
Workshop Outcomes:
- Formatting Tables
- Sorting & Filtering Tables
- Aggregating Tables
- Aggregation of Sumif, Averageif, Countif Formulas
- Using Date Formulas
- Logical Formulas (Vlookup, Hlookup, If
- Text Formulas
- Finance Formulas
- Auditing Formulas
- Connecting to External Data
- Using Excel as a Database
- Creating Graphs in Excel