ESTIMATED AVERAGE TIME:

14hrs

​

PART 3 COURSE OUTLINED:

This course is intended to help all users get up to speed on the different aspects of Excel, including its advanced features. You will cover how to automate worksheet functionality, audit worksheets, analyze data, work with multiple workbooks, export Excel data, import and export XML data, and create Excel forms.

​

  FREE DOWNLOAD LESSON 1 

​

Lesson 1: Automating Worksheet Functionality

Average time 2hrs: 56mins

In this lesson, students will learn how to update workbook properties, create and edit a macro, apply conditional formatting, and add data validation criteria to a workbook.
 

Lesson 2: Auditing Worksheets

Average time 2hrs

This lesson covers how to trace cells, troubleshoot invalid data and formula errors, watch and evaluate formulas, as well as how to create a data list outline.
 

Lesson 3: Analyzing Data

Average time 3hrs: 18mins

Next, students will learn how to create Sparklines, create scenarios, perform what-if analysis, and perform statistical analysis with the Analysis ToolPak.
 

Lesson 4: Working with Multiple Workbooks

Average time 1hrs: 25mins

Students will learn how to create a workspace, consolidate data, link cells in different workbooks, and how to merge workbooks.
 

Lesson 5: Exporting Excel Data

Average time 2hrs: 20mins

This lesson covers how to export Excel data, import a delimited text file, integrate Excel data with the Web, and how to create a Web query.
 

Lesson 6: Importing and Exporting XML Data

Average time 1hrs: 20mins

In this lesson, students will learn how to import and export XML data.
 

Lesson 7: Creating Excel Forms

Average time 40mins

The final lesson covers how to create Excel forms.