Microsoft Excel Training > Microsoft Excel 2016 Intermediate

Microsoft Excel 2016 Intermediate

4.6

Course Objectives

Create simple to complex formulas and functions like:
1. Database Function
2. COUNTIF Function
3. COUNTIFS Function
4. AVERAGEIF Function
5. AVERAGEIFS Function
6. SUMIF Function
7. SUMIFS Function
8. IF Function
9. AND Function
10. VLOOKUP Function
Validate data in a Worksheet
Filter data using Auto & Advanced Filter
Create Chart
Clean Duplicate Records
Apply Conditional Formatting-

Target Audience

REQUIRED PREREQUISITES:

Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

Have attended Microsoft Excel – Foundation Level; OR

Able to switch between task applications
Able to create a spreadsheet with simple formatting
Able to create a basic chart
Able to print a spreadsheet with headers and footers added
Able to apply Freeze Pane command
Able to create basic formulas – Addition, Subtraction, Multiplication and Division
Able to use basic functions – AutoSum, Count, Max, Min and Average functions.

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.

Course Modules

Module 1 – Performing Calculations
Topic A: Reuse Formulas
Module 2 – Creating Advanced Formulas
Topic A: Apply Range Names
Topic B: Use Specialized Functions
Module 3 – Organizing Worksheet Data with Tables
Topic A: Create and Modify Tables
Topic B: Sort and Filter Data
Topic C: Use Subtotal and Database Functions to Calculate Data
Topic D: Validating your Data
Module 4 – Working with Statistical, Mathematical, Logical and Lookup Functions
Topic A: Statistical Functions
Topic B: Mathematical Function
Topic C: Use Logical Functions
Topic D: Use Lookup Functions
Module 5 – Visualizing Data with Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Sparkline
Module 6 – Showing Data as Graphic Lesson
Topic A: Conditional Formatting
Module 7 – Finalize Workbook
Topic A: Worksheet and Workbook Protection
Topic B: Managing Multiple Windows