Certificate In Excel 2013 Expert Online Course

Module One: Getting Started

• Course Objectives

Module Two: Working with Permissions and Options

• Marking a Workbook as Final
• Encrypting with a Password
• 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 a 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 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

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 Eight: Applying Advanced Chart Features

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

Module Nine: Working With Slicers and Timelines

• About Slicers and Timelines
• Creating a Slicer in an Existing Table
• Formatting a Slicer
• Using a Timeline

Module Ten: Working With Multiple Tables, Relationships and External Data

• Connecting to a New External Data Source
• Creating a PivotTable Using an External Data Connection
• Working with PivotTables Based on Multiple Tables

Module Eleven: Working With PowerView

• About Power View
• Creating a Power View Sheet
• Add a Table to the Data Model
• Adding a Map to a Power View Report

Module Twelve: Wrapping Up