MS Excel Intermediate Level Training

COURSE DETAILS

Basic Microsoft Excel will teach you how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. Some topics may appear to be basic skill sets but are discussed in more detail, exploring at a higher-level different option that can be chosen or applied for that skill set. 

PREREQUISITES

Basic Computer Courses

TARGET AUDIENCE

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

COURSE OUTLINE

MODULE 1: EXCEL CELL REFERENCES
Use Fill Series to Automate Data Series in Excel – Basic
Relative Cell References – Basic
Absolute Cell References – Basic   
Formula Syntax – Basic 
Using Excel Operators – Basic

MODULE 2: PERFORMING EXCEL NUMBER FUNCTIONS
Using Basic Number Functions (SUM, COUNT, AVERAGE)  – Basic
Using Statistics Functions (MAX, MIN, LARGE, SMALL, RANK) – Basic
Using Criteria Based Formulas (COUNTIF, SUMIF, AVERAGEIF) – Intermediate

MODULE 3: EDITING TEXT RELATED DATA
Concatenate Function – Basic
Format Case (UPPER, LOWER and PROPER) – Basic
Flash Fill – Intermediate
Using LEFT, RIGHT, MID Function – Intermediate
Text to Columns – Intermediate
Removing Duplicates – Intermediate

MODULE 4: DATE AND TIME RELATED FUNCTIONS
Using TODAY and NOW Function – Basic
Calculate Difference on Date Using Date Difference – Intermediate
Using NetworkDays to Calculate Number of Working Days – Intermediate
Using WorkDays to Calculate Due Date – Intermediate

MODULE 5: ENHANCING EXCEL REPORT APPERANCE
Using Format Cells – Basic
Applying Conditional Formatting – Basic
Using Auto Style Table Format – Basic

MODULE 6: DATA VISUALIZATION
Chart Principles – Basic 
Basic Chart Components – Basic 
Creating Bar Charts – Basic
Creating Line Charts – Basic
Creating Pie Chart- Basic
Creating Combo Charts – Intermediate
Creating Heat Maps – Intermediate
Printing Charts – Intermediate

MODULE 7: MANAGING LARGE WORKBOOKS
Sort and Filter – Basic 
Grouping and Ungrouping – Basic
Using Subtotal Function – Intermediate
What IF Analysis – Intermediate

For FULL COURSE OUTLINE, please contact us. Please contact us for the schedules and for booking a private class

Inquire Now