AIMS
To be able to use some advanced features in Microsoft Excel
LEARNING OUTCOMES
By the end of this course you will:
- Understand the basic feature of Excel
- Know how to navigate through, add edit and delete Worksheets
- Know how to Filter data, Sort on multiple fields
- Understand how to use common Conditional Formatting tools
- Know how to add and edit rules relating to Conditional Formatting
- Understand how to use HLOOKUP and VLOOKUP Functions
- Be able to use SUMIF, AVERAGEIF, COUNTIF and related functions
- Know how to present data using Pivot Tables
- Be able to present data effectively using Charts and Graphs
- Know ways to remove duplicate data (de-duping)
- Be able to use functions to trim and combine data
- Be able to integrate Excel worksheets with other Office products
LESSONS AND TOPICS
Excel Basics
- What is Excel?
- Form and structure of worksheets
- Tools for autocompletion
Intermediate Features
- Filtering tools
- Sorting on multiple fields
- Conditional formatting
- Conditional Formatting rules
- Drop Down boxes
- CSV and other formats
- Delimiting Characters for Imported data
More Advanced Functions
- HLOOKUP and VLOOKUP
- SUMIF, AVERAGIF, COUNTIF and related functions
- De-Duping
- Combining and Trimming data
Presenting Data
- Pivot Tables
- Charts and Graphs
- Integrating with other Office products
Reviews
There are no reviews yet.