Pre-Requisite:
Delegates should have attended or familiar with Excel Introduction Course
Course Outline:
Performing Calculations
- Create Worksheet Formulas
- Insert Functions
- Reuse Formulas
Basic Formulas
- Create Formula
- Basic Steps for Creating Formulas
- Auto Sum
- Borders and Shading
- Manual Formula
Creating Advanced Formulas
- Use Range Names in Formulas
- Use Specialized Functions
- Use Array Formulas
Analysing Data with Functions and Conditional Formatting
- Analyse Data by Using Text and Logical Functions
- Apply Advanced Conditional Formatting
Organizing and Analysing Datasets and Tables
- Create and Modify Tables
- Sort Data
- Filter Data
- Use SUBTOTAL and Database Functions
Visualizing Data with Basic Charts
- Creating Charts using the Chart Wizards
- Editing and Formatting Charts
- Printing Charts
- Using the Drawing Toolbar
Analysing Data with PivotTables, Slicers, and PivotCharts
- Create a PivotTable
- Analyse PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Slicers