Excel Level 3
CTU-EXCEL10L3-C

 Email this information to yourself or a friend

 Remind me of this course at a later date




Official Program Description

Excel Level 3


jump to schedules and register button

Updating data in an Excel worksheet is fast and easy. All you need to do is insert the new data and configure the sheet so that calculations are updated whenever the data changes. Storing your data in Excel also enables you to run reports on the data, perform calculations, print your work to share with others, and much more. In this course, you will use Microsoft® Office Excel® to create spreadsheets and workbooks that you can use to store, manipulate, and share your data. You will learn about auditing tools, how to perform what-if analysis, and extreme charting.  Level 3 is full of time-saving efficiency tools that will streamline your work in Excel.

Who Should Attend

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

Prerequisites

To ensure your success, you will need to have a comfort level with the basic skills of Excel like entering data, working with data, using functions, and working with formulas.

Attend and You Will Learn

Automating Worksheet Functionality

  • Updating workbook properties
  • Creating and editing a macro
  • Applying conditional formatting
  • Adding data validation criteria

Auditing Worksheets

  • Tracing Cells
  • Troubleshooting Invalid data and formula errors
  • Watching and evaluating formulas
  • Creating a Data List Outline

Analyzing and Presenting Data

  • Creating sparklines
  • Creating scenarios
  • Performing a what-if analysis
  • Performing a statistical analysis with the analysis toolpak
  • Create interactive data with power view

Working with Multiple Workbooks

  • Consolidating data
  • Linking cells in different workbooks
  • Merging Workbooks

Importing and Exporting Data

  • Exporting Excel data
  • Importing a delimited text file
  • Integrating Excel Data with the Web
  • Creating a Web query



Sections

  Excel Level 3
CTU-EXCEL10L3-C - 031
   
 
  2016 - TTS - Sep - Dec 2015   Status:  Available
 
In-Class:   Tue 9:00AM - 4:30PM
20 Oct 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Gov't & Non-Profit Registration Fee non-credit    $199.00
Registration Fee non-credit    $249.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus
 
  Excel Level 3
CTU-EXCEL10L3-C - 032
   
 
  2016 - TTS - Sep - Dec 2015   Status:  Available
 
In-Class:   Mon 9:00AM - 4:30PM
14 Dec 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Gov't & Non-Profit Registration Fee non-credit    $199.00
Registration Fee non-credit    $249.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus