Microsoft Excel 2013 Advanced Training Course

Microsoft Excel 2013 Advanced Training Course

pdtraining

Event outline

Course Overview

If you use Excel 2013 everyday, then having advanced skills in the program will make you more valuable and give you the confidence required to take on more advanced tasks and projects.

The pdtraining Microsoft Excel 2013 Advanced Training Course provides you with comprehensive training in the advanced features of Excel 2013, including creating and running Macros, Flash Fill, formulas and functions, data management, customisation, auditing, grouping and transporting data and solving errors.

Learning Outcomes

  • Insert SmartArt
  • Insert equations, shapes, pictures, text boxes
  • Create sparklines
  • Insert PivotTables and PivotCharts
  • Use slicers
  • Create timelines
  • Share your workbook on SkyDrive
  • Change Ribbon display options
  • Customise the Quick Access toolbar
  • Create Custom Ribbon tabs
  • Reset interface changes
  • Use cell styles
  • Format data as a table
  • Add a background
  • Print and email a workbook

Course Outline

Lesson 1
Getting Started

  • Housekeeping Items
  • Workshop Objectives
  • The Parking Lot
  • Action Plan

Lesson 2
SmartArt and Objects

  • Inserting SmartArt
  • Editing the Diagram
  • Adding Pictures
  • Adding Text Boxes
  • Drawing Shapes
  • About the Contextual Tabs
  • Lesson Two: Review Questions

Lesson 3
Auditing

  • Tracing Precedent cells
  • Tracing the Dependents of a Cell
  • Displaying Formulas Within the Sheet
  • Adding, Displaying, Editing ,and Removing Comments
  • Lesson Three: Review Questions

Lesson 4
Creating Charts

  • Using Recommended Charts
  • Inserting a Chart
  • Overview of the Chart Tools Tabs
  • Understanding the Parts of a Chart
  • Resizing and Moving the Chart
  • Lesson Four: Review Questions

Lesson 5
Working with Charts

  • Using Chart Elements
  • Using Chart Styles and Colours
  • Changing the Chart Style
  • Using Chart Filters
  • Working with Data Labels
  • Lesson Five: Review Questions

Lesson 6
Creating Pivot Tables and Pivot Charts

  • Inserting a PivotTable using Excel Recommendations
  • Choosing Fields and Grouping Data
  • Overview of the Pivot Table Tools Tabs
  • Changing the Data Displayed and Refreshing the PivotTable
  • Creating a Pivot Chart from a Pivot Table or Data
  • Some Real-life Examples
  • Lesson Six: Review Questions

Lesson 7
Macros

  • Displaying the Developer Tab
  • Recording and Running Macros
  • Changing the Security Level
  • Customising and Changing the Quick Access Toolbar
  • Lesson Seven: Review Questions

Lesson 8
Solving Formula Errors

  • Using Named Ranges
  • Understanding Formula Errors
  • Using the Trace Errors Commands
  • Using Error Checking
  • Evaluating Formulas
  • Lesson Eight: Review Questions

Lesson 9
Using What If Analysis

  • Using Goal Seek
  • Using the Scenario manager
  • Using a One Input Data Table
  • Using a Two Input Data Table
  • Lesson Nine: Review Questions

Lesson 10
Managing Your Data

  • Transposing Data from Rows to Columns
  • Using the Text to Columns Feature
  • Checking for Duplicates
  • Creating Data Validation Rules
  • Consolidating Data
  • Lesson Ten: Review Questions

Lesson 11
Grouping and Outlining Data

  • Grouping Data
  • Adding Subtotals
  • Outlining Data
  • Viewing Grouped and Outlined Data
  • Lesson Eleven: Review Questions

Lesson 12
Wrapping Up

  • Words from the Wise
  • Review of Parking Lot
  • Lessons Learned
  • Completion of Action Plans and Evaluations

Dates & registration

There are no dates listed for this event.

Provider information

pd training is an Australian-owned, international training and professional development and services organisation, with approximately 400 specialist trainers across Australia, delivering thousands of courses each year in our 16 areas of specialty.