About This Course
This course is designed for those with basic knowledge of Excel who wish to progress to the most complicated functions and features in Excel.
Learning Objectives
-
Prerequisites
-
Target Audience
Learners who want to create a report and perform calculation by using the Excel functions and features
Training Outline
- Working with Cell Reference
- Working with Conditional Logic
- Working with Lookup Tables
- Manipulating Information
- Working with Conditional Formatting
- Consolidating Data
- Managing List
- Working with Database
- Working with Charts
- Using Sparklines to Show Data Trends
- Working with PivotTable & PivotChart
- Using Protection in Excel
- Introduction to Excel Macro