Course Info:
Course Introduction
In this course, students learn to create and format different types of charts, create name ranges and use them in formulas, and sort, filter, outline and consolidate data. They learn to work with multiple worksheets, link formulas, use functions to look up data, use IF statements, explore core concepts of PivotTables and PivotCharts, and examine various aspects of worksheet auditing and customization of Excel.
Students accomplish the learning objectives for each module through a series of hands-on activities, and there are frequent opportunities to practice, apply, and develop the skills covered in the course.
Course Prerequisite
Microsoft Excel Level 1.
Course Notes
The course consists of 10 graded, end-of-module quizzes and a final exam, which consists of practical and online test components.
The course includes a digital Student Reference Guide and Let Me Try workbook. Printed versions of these may be purchased separately.
Course Breakdown
Module 1: Using Charts
Creating Charts; Types of Charts; Editing Charts; Using Graphics to Enhance Charts; Linking Chart Titles; Creating Sparklines
Module 2: Working with Names
Creating Range Names; Managing Names; Using Names in Formulas
Module 3: Sorting and Filtering Data
Removing Duplicate Rows; Sorting Data; Filtering Data; Using Advanced Filters
Module 4: Outlining and Subtotaling Data
Creating an Outline; Adding Subtotals
Module 5: Working with Views
Arranging Files; New Window Feature; Custom Views
Module 6: Linking Files
Creating Formulas Between Files; Working with Links; Consolidating Data
Module 7: Advanced Formula Creation
Using IF Statements; Using Functions to Look Up Data; Working with Data Validation; Formula Auditing; Using the Watch Window
Module 8: Overview of PivotTables and PivotCharts
PivotTables; PivotCharts; Slicers
Module 9: Customizing Excel
Excel Options; Customizing the Ribbon; Modifying Workbook Properties
Module 10: Additional Excel Features
Text to Columns; Conditional Formatting; Hyperlinks; the Spell Checker and Translate Features; Quick Analysis Tool; the Document Inspector; Import Data from a Text/CSV File
Upon Completion
Students may continue with Microsoft Excel Level 3.
-
Program: Business Programs
-
Course Aim To further develop users’ skill level with Microsoft Excel, so that they may confidently use the software at a professional level.
-
Of Interest to Those interested in preparing and maintaining financial statements and other kinds of reports using an up-to-date office spreadsheet application.
Method of Delivery Integrated Learning System training facilitated by Academy of Learning Career College Learning Coaches.
Contact us for more information
And we'll get back to you within 48 hours.