Motivational Speaking, Business Coaching, Corporate Training, Cyber Security, Web Design, Consulting

Excel Level 2 Outline

 

Lesson 1 -  Using Large Worksheets

Increasing the Magnification

Decreasing the Magnification

Changing the Magnification of a Range

Switching to Full Screen View

Splitting the Window

Removing Split Windows

Freezing the Panes

Unfreezing the Panes

 

Lesson 2 -  Working with Multiple Worksheets

Using Multiple Worksheets

Navigating between Worksheets

Selecting Worksheets

Renaming Worksheets

Selecting Multiple Worksheets

Coloring Worksheet Tabs

Inserting Worksheets

Deleting Worksheets

Printing Selected Worksheets

 

Lesson 3 -  Managing Worksheets

Copying Worksheets

Moving Worksheets

Using Grouped Worksheets

Moving Data between Worksheets

Copying Data between Worksheets

Creating 3-D Formulas

Using 3-D Ranges in Functions

 

Lesson 4 -  Using Range Names

Working with Range Names

Jumping to a Named Range

Assigning Names

Using Range Names in Formulas

Creating Range Names from Headings

Applying Range Names

Deleting Range Names

Using Range Names in 3-D Formulas

Creating 3-D Range Names

Using 3-D Range Names in Formulas

 

Lesson 5 -  Using Other Functions

Using Function Arguments

Using Financial Functions

Using Logical Functions

Using Date Functions

Formatting Dates

Revising Formulas

 

Lesson 6 -  Managing Data

Sorting Lists

Sorting in Ascending/Descending Order

Finding Data

Replacing Data

Finding and Replacing Cell Formats

 

Lesson 7 -  Using AutoFilter

Enabling AutoFilter

Using AutoFilter to Filter a List

Clearing AutoFilter Criteria

Creating a Custom AutoFilter

Disabling AutoFilter

​

Lesson 8 -  Working with Tables

Using Tables

Creating a Table from Existing Data

Changing the Table Name

Changing the Table Style

Changing Table Style Options

Creating a Total Row

Adding Table Rows and Columns

Inserting/Deleting Table Rows/Columns

Creating a Calculated Column

Selecting Parts of a Table

Moving a Table

Sorting Data by Multiple Levels

Using Text Filters

Using Number Filters

Using Data Validation

Validating Data using a List

Creating a Custom Error Message

Removing Data Validation

 

Lesson 9 -  Managing Files

Changing Workbook Properties

Selecting File Views

Sorting Excel Files

Using the Document Recovery Pane

Inspecting a Document

Marking a Document as Final

Saving to a PDF Format

Using the Compatibility Checker

Converting a File to 2007 Format

Saving as a Binary Format

 

Lesson 10 -  Using HTML Files

 

Previewing a Web Page

Creating a Hyperlink

Editing a Hyperlink

Saving a Worksheet as a Web Page

Using Publishing Options

Opening an HTML File

 

Lesson 11 -  Working with Comments

Creating Comments

Viewing a Comment

Reviewing Comments

Printing Comments

Responding to Discussion Comments