Protection and Sharing

·         Protecting and Current Sheet
·        Allowing Edits to Ranges
·         Protecting the Workbook Structure
·         Restricting Permissions
·         Permission Levels
·         Additional Permission Options
·         Requiring passwords to open a workbook

Maintain Shared Workbooks

·         Sharing Workbooks
·         Disabled Features While Sharing
·         How to merge Workbooks
·         Tracking Changes
·         Viewing and Reviewing Tracked Changes

Audit Formulas

·         Formula Tracing
·         Locating Invalid Data and Formulas
·         Correcting Errors in Formulas

Manipulate Formula Options

·         Setting interactive calculation options
·         Automatic Workbook Calculation

Data Summary Tasks

·         Using an array formula
·         Restrictions using an array
·         Array functions and formulas
·         Array Constants
·         Using Array constants
·         Using the SUMIF & SUMIFS functions

Functions in Formulas

·         Error Messages
·         Avoiding Errors in Functions
·         Using Various Functions

Advanced Chart Features

·         Trend Lines
·         Applying Trend lines
·         Formatting Trend lines
·         Applying Dual Axes
·         Chart Templates
·         Applying Sparkline’s

Data Analysis

·         Using Automated Analysis Tools
·         Descriptive Statistics
·         Histograms
·         Rank And Percentile
·         Random Number Generation
·         Sampling Data
·         Performing a What-if Analysis
·         Data Tables
·         Creating a one Variable Data Table
·         Creating a two Variable Data Table
·         Scenario manager
·         Managing and Merging Scenarios
·         Goal Seek
·         Configuring Goal Seek
·         Solver
·         Using Solver

Pivot Table

·         Creating a Pivot Table
·         Manipulating Pivot Table Data
·         Pivot Table Design
·         Using the Slicer on Pivot Table Data

Pivot Charts

·         Creating and Manipulating Pivot Charts
·         Pivot Chart Options
·         Layout and Format

External Data

·         Connecting to External Data
·         Connecting to Microsoft Access
·         Connecting to a Website
·         Connecting to a Text File
·         Connecting to an MS SQL Database
·         Using Existing Connections
·         Editing External Workbook Links

Macros and Forms

·         Macros
·         Recording a Macro
·         Running a Macro
·         When a Workbook is Opened
·         When a button is Clicked
·         Recording and Action Macro
·         Modifying a Macro
·         Forms
·         Available Form Controls