Certificate In Excel 2010 Expert Online Course

Module One: Getting Started

• Course Objectives

Module Two: Working with Permissions and Options

• Marking Workbook as Final
• Encrypting with a Password and Restricting Permissions
• Protecting the Current Sheet or the Workbook Structure
• Adding a Digital Signature
• Setting Excel Options
• Managing Versions
• Saving a Workbook as an Excel Template

Module Three: Sharing Workbooks

• Inspecting Document
• Sharing a Workbook
• Editing a Shared Workbook
• Tracking Changes
• Merging Copies of a Shared Workbook

Module Four: Performing Advanced Formula and Function Tasks

• Using the Watch Window
• About the Excel Calculation Process
• Setting Calculation Options
• Enabling or Disabling Automatic Workbook Calculations
• Using the IFERROR Function to Evaluate Formulas

Module Five: Working with Array Formulas

• About Array Formulas
• Creating One-Dimensional and Two-Dimensional Constants
• Creating a Simple Array
• Creating an Advanced Array

Module Six: Working with Functions

• Working with Math and Trigonometry Functions
• Using a SUMIF Function
• Working with Date and Time Functions
• Working with Financial Functions
• Working with Text Functions
• Working with Cube Functions
• Working with Statistical Functions

Module Seven: Working with Macros

• Assigning a Macro to a Command Button
• Running a Macro by Clicking an Area of a Graphic Object
• Configuring a Macro to Run Automatically Upon Opening the Workbook
• Changing a Macro

Module Eight: Working with Forms

• About Excel Forms, Form Controls, and Active X Controls
• Using a Data Form
• Using a List Box Control
• Using a Combo Box Control
• Using a Spin Button Control
• Using a Scroll Bar Control

Module Nine: Applying Advanced Chart Features

• About Trend Lines
• Add a Trend Line
• Using Secondary Axes
• Using Chart Templates

Module Ten: Working with PivotTables and PivotCharts

• Working with PivotTable Tools
• Working with PivotChart Tools
• About Slicers
• Creating a Slicer in an Existing PivotTable
• Creating a Standalone Slicer
• Formatting a Slicer
• Sharing Slicers with Another PivotTable
• Disconnect or Delete a Slicer

Module Eleven: Using the Automated Analysis Tools Add-In

• Loading the Analysis ToolPak
• About the Analysis ToolPak Options (I)
• About the Analysis ToolPak Options (II)
• About the Analysis ToolPak Options (II)

Module Twelve: Wrapping Up