Excel 2013 Expert

Participants will learn how to use the expert features of Excel 2013. This course is designed to provide an in-depth understanding of Excel 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will get a chance to experience some of the new features that are offered in Excel 2013.

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive – and better information leads to better decision making!

Completing this course will confer 2 CPD Credits towards internationally recognised Continuous Professional Development Requirements within organisations operating this kind of staff development methodology.

Course Outline

Module One: Getting Started

Module Two: Working with Permissions and Options

• Marking a 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 a Document
• Sharing a 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
• About the Excel Calculation Process & Setting Calculation Options
• Enabling or Disabling Automatic Workbook Calculations
• Using the IFERROR Function to Evaluate Formulas
• Module Four: Review Questions

Module Five: Working with Array Formulas

• About Array Formulas
• Creating One-Dimensional and Two-Dimensional Constants
• Creating a Simple or Advanced Array
• Module Five: Review Questions

Module Six: 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 Six: Review Questions

Module Seven: 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 Seven: Review Questions

Module Eight: Applying Advanced Chart Features

• About Trend Lines
• Add a Trend Line
• Using Secondary Axes
• Using Chart Templates
• Module Eight: Review Questions

Module Nine: Working with PivotTables and Pivot Charts

• 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 Nine: Review Questions

Module Ten: Working with Power View

• About Power View
• Creating a Power View Sheet
• Connecting to Different Data Modules in One Workbook
• Modifying the Data Model without Leaving the Power View Sheet
• Using Drill Down, Drill Up, and Cross Drill
• Module Ten: Review Questions

Module Eleven: Working with Multiple Tables in Data Analysis

• Using Multiple Tables in Your Data Analysis
• Connection to Additional Data Sources
• Creating Relationships between Tables
• Using a Timeline to Show Data for Different Time Periods
• Module Eleven: Review Questions