Course Prerequisites
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
-
Requirements
- Basic understanding of data management concepts and constructs such as relational database tables
- Know how different pieces of data logically relate to one another.
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