Excel

Intermediate - - Advanced

Full Day
In this course you will learn how to create a basic worksheet, perform calculations, modify a worksheet and print workbook contents.

• Explore the user Interface and the Ribbon
• Navigate and Select in Excel
• Obtain Help
• Enter Data and Save a Workbook
• Customize the Quick Access Toolbar

Performing Calculations

• Create Basic Formulas
• Calculate with Functions
• Copy Formulas and Functions

Modifying a Worksheet

• Manipulate Data
• Insert and Delete Cells, Columns, and Rows
• Search for Data in a Worksheet
• Spell Check a Worksheet

Formatting a Worksheet

• Modify Fonts
• Add Borders and Color to Cells
• Change Column Width and Row Height
• Apply Number Formats
• Position Cell Contents
• Apply Cell Styles

Printing Workbook Contents

• Print Workbook Contents Using Default Print Options
• Set Print Options
• Set Page Breaks

Managing Large Workbooks

• Format Worksheet Tabs
• Manage Worksheets in a Workbook
• Manage the View of Large Worksheets

Beginning - - Advanced

Full Day
In this course you will learn how to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web.

Calculating Data with Advanced Formulas

• Manage Cell and Range Names
• Calculate Data Across Worksheets
• Use Specialized Functions
• Analyze Data with Logical and Lookup Functions

Organizing Worksheet and Table Data

• Create and Modify Tables
• Format Tables
• Sort or Filter Worksheet or Table Data
• Calculate Data in a Table or Worksheet

Presenting Data Using Charts

• Create a Chart
• Modify Charts
• Format Charts

Analyzing Data Using PivotTables and PivotCharts

• Create a PivotTable Report
• Analyze Data Using Pivot Charts

Inserting Graphic Objects

• Insert and Modify Pictures and ClipArt
• Draw and Modify Shapes
• Illustrate Workflow Using SmartArt Graphics
• Layer and Group Graphic Objects

Customizing and Enhancing Workbooks and the Excel Environment

• Customize the Excel Environment
• Customize Workbooks
• Manage Themes
• Create and use Templates

Top

Beginning - - Intermediate

Full Day
In this course you will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Streamlining Workflow

• Create a Macro
• Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria
• Update a Workbook's Properties
• Modify Excel's Default Settings

Collaborating with Others

• Protect Files
• Share a Workbook
• Set Revision Tracking
• Review Tracked Revisions
• Merge Workbooks
• Administer Digital Signatures
• Restrict Document Access

Auditing Worksheets

• Trace Cells
• Troubleshoot Errors in Formulas
• Troubleshoot Invalid Data and Formulas
• Watch and Evaluate Formulas
• Create a Data List Outline

Analyzing Data

• Create a Trendline
• Create Scenarios
• Perform What-If-Analysis
• Perform Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks

• Create a Workspace
• Consolidate Data
• Link Cells in Different Workbooks
• Edit Links

Importing and Exporting Data

• Export Excel Data
• Import a Delimited Text File

Using Excel with the Web

• Publish a Worksheet to the Web
• Import Data from the Web
• Create a Web Query

Top