Excel 2010 Expert

Your participants will learn how to use the more in-depth features of Excel 2010. This workshop is designed to for the advanced users of Excel 2010. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information – and better information leads to better decision making!

Course Outline

Module One: Getting Started
• Housekeeping Items
• The Parking Lot
• Workshop Objectives
• Pre-Assignment
• Action Plans and Evaluations

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 Two: Review Questions

Module Three: Sharing Workbooks
• Inspecting Document
• Sharing Workbook
• Editing a Shared Workbook
• Tracking Changes
• Merging Copies of a Shared Workbook
• Module Three: Review Questions


Module Four: Performing Advanced Formula and Function Tasks
• Using the Watch Window
• Setting Calculation Options
• Enabling or Disabling Automatic Workbook Calculations
• Using the IFERROR Function to Evaluation Formulas
• Module Four: Review Questions

Module Five: Working with Array Formulas
• About Array Formulas
• About Array Constants
• Using One and Two-Dimensional Constants
• Examples of Basic Array Formulas
• Examples of Advanced Array Formulas
• Array Formulas that Calculates a Single Result
• Array Formulas that Calculates Multiple Results
• Module Five: Review Questions

Module Six: Functions
• Working With Statistical Functions
• Working With Date and Time Functions
• Working With Financial Functions
• Working With Text Functions
• Working With Cube Functions
• Using a SUMIF Function
• Module Six: Review Questions

Module Seven: Macros
• Assigning Macros to a Command Button on the Ribbon
• Run a Macro Through a Graphic Object
• Configure a Macro to Run Automatically
• Changing a Macro
• Module Seven: Review Questions

Module Eight: Forms
• Inserting Form Controls
• Setting Form Properties
• Module Eight: Review Questions

Module Nine: Applying Advanced Chart Features
• Using Trend Lines
• Using Dual Axes
• Using Chart Templates
• Module Nine: Review Questions


Module Ten: Working with PivotTables and PivotCharts
• Using the Slicer to Filter and Segment PivotTable Data
• Working with PivotTables Tools
• Working with PivotCharts Tools
• Using the Slicer to Choose Data Sets
• Module Ten: Review Questions

Module Eleven: Using 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 (III)
• Module Eleven: Review Questions

Module Twelve: Wrapping Up
• Words from the Wise
• Review of Parking Lot
• Lessons Learned
• Completion of Action Plans and Evaluations

Previous

Next