AIMS
To be able to use some basic and intermediate 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
- Know ways to remove duplicate data (de-duping)
- 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
- 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
- De-Duping
- HLOOKUP and VLOOKUP
- SUMIF, AVERAGIF, COUNTIF and related functions
- Combining and Trimming Data
Presenting Data
- Pivot Tables
- Charts and Graphs
- Integrating with other Office products
Reviews
There are no reviews yet.