Microsoft Excel Level 2

Course Length

1 Day

Target Student

This course is for those who know the basics of Excel, who want to know how to access all the functions available in Excel and use the Tables feature to make it easier to work with a spreadsheet. Students will also learn how to use styles to make it quick and easy to apply a consistent format throughout a spreadsheet, and to use Conditional Formatting to allow you to easily see when numbers or words fall into patterns. It's also for those who want to use the power of PivotTables to easily analyze and summarize data, use the Comments, Text to Columns and Subtotals feature, and create and edit charts.

Prerequisites

It's recommended that participants have taken Excel Level 1 or have equivalent knowledge.

Delivery Model

Hands-on, instructor led, group-paced, classroom learning. The pace of class is based on the participants' previous computer experience and class expectations. Questions are welcome and encouraged!

Course Outline

Mastering Functions
Formulas with Multiple Operators
Absolute Cell References
Defining Names
Using and Managing Defined Names
Inserting and Editing a Function
Date & Time Functions
Text Functions
SUMIF & COUNTIF Function
Using Logical Functions (IF)
Using Lookup Functions (VLOOKUP)
Working with Tables
Create a Table
Formatting the Table
Add and Remove Data
Sort a Table
Use the Total Row
Filtering a Table
Remove Duplicate Rows of Data
Converting to a Range
Advanced Formatting
Apply and Remove Cell Styles
Use Themes
Create & Modify Cell Styles
Conditional Formatting
Managing Conditional Formatting Rules
PivotTables
Create a PivotTable
Specify PivotTable Data
Change a PivotTable’s Calculation & Number Format
Filter & Sort a PivotTable
PivotTable Layout
Change Date Grouping
Update a PivotTable
Format a PivotTable
Creating a PivotChart
Other Topics
Add Comments to Cells
Using Text to Columns
Using Subtotals
Create and use a Template
Create & Work with Charts
Choosing the Right Chart
Select the Source Data
Insert a Chart
Change Chart Type
Edit, Add, & Remove Chart Data
Changing Chart Data
Changing Chart Layout and Style
Work with Chart Labels
Changing the Scale
Emphasizing Data
Sparklines
Customize the Quick Access Toolbar
Use Help

Also Includes

  • Detailed class/reference book
  • Certificate of completion.