Course Description

A Certified Microsoft Trainer conducts this Microsoft Excel Basic to Intermediate training course. It is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting, including styles.

Pre-requisites

-Participants must have basic computer skills.

-Participants use their laptops to apply lessons and work on exercises.

Hardware/Software Requirements

-Microsoft Excel 2016 / 2019 version

-Mac laptop/ Mac book version is not allowed

What you’ll learn

By the end of the course you’ll be writing robust, elegant formulas and functions from scratch, allowing you to:

-Manipulate dates, times, text, and logical functions

-Go rogue and design your own formula-based Excel formatting rules

-Create Dynamic Dashboards and reports using Excel Chart tools

-Analyze and consolidate your data using Excel reporting tools

Course Outline

TRACK 1: EXCEL DATA REFERENCE

a. Introduction to Excel Spreadsheet Intermediate Level

b. Defining Names in Excel

TRACK 2: APPLYING EXCEL FUNCTIONS

a. Functions within Excel

b. Text Related Functions

c. Understanding Date and Time Function

d. Logical Functions

e. Database Functions

TRACK 3: EXCEL FORMATTING TOOLS

a. The Format Cells Dialogue Box

b. Conditional Formatting

c. Formula Based formatting

TRACK 4: DATA VISUALIZATION

a. Principles of Data Visualization

b. Creating Basic Charts and Dashboards

c. Application of Different Chart Types in Microsoft Excel

TRACK 5: REPORT CONSOLIDATION IN MS EXCEL

a. Using Basic Sort and Filter Methods

b. Application of Basic Subtotal

c. Consolidate Feature of Microsoft Excel

TRACK 6: WHAT IF ANALYSIS METHODS

a. The use of Goal Seek

b. Creating Scenario Manager

c. Applying Data Tables

Who Should Attend?

This course is intended for novice information workers who want to learn intermediate-level Excel skills.

For more information, you may contact us through:

(632) 7957-7937, 7577-9211

(0917) 6372471, (0912) 2231826

info@businessmaker-academy.com

www.businessmaker-academy.com