Excel 2013 Advance

  • Training Time: 1 Day, 9:00 am to 5:00 pm
  • Inclusion: Participants Manual and Certificate of Completion

Participants will learn how to use the advanced features of Excel 2013. This workshop is designed to get into the more advanced features 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!

Learning Points
  • Use SmartArt and other objects in worksheets
  • Trace precedent cells and dependent cells, as well as use other auditing tools
  • Create and work with charts
  • Create Pivot Tables and Pivot Charts
  • Record and run macros
  • Solve formula errors
  • Use What If Analysis tools
  • Use tools to manage rows, columns, duplicates, and validation
  • Group and outline data
Course Outline

Excel 2013 Advanced – Lesson 1
Getting Started

  • Workshop Objectives
  • Pre-Assignment

Excel 2013 Advanced – Lesson 2
SmartArt and Objects

  • Inserting SmartArt
  • Editing the Diagram & Adding Pictures
  • Adding Textboxes & Drawing Shapes
  • About the Contextual Tabs

Excel 2013 Advanced – Lesson 3
Auditing

  • Tracing Precedent Cells
  • Tracing the Dependents of a Cell
  • Displaying Formulas Within the Sheet
  • Adding, Displaying, Editing, Removing Contents

 

Excel 2013 Advanced – Lesson 4
Creating Charts

  • Using Recommended Charts
  • Inserting a Chart
  • Overview of the Chart Tools Tabs
  • Understanding Chart Elements
  • Resizing and Moving the Chart

Excel 2013 Advanced – Lesson 5
Working with Charts

  • Using Chart Elements
  • Using Chart Styles and Colors
  • Using Chart Filters
  • Working with Data Labels

Excel 2013 Advanced – Lesson 6
Creating Pivot Tables & PivotCharts

  • Inserting Pivot Table w/ Excel Recommendations
  • Choosing Fields and Grouping Data
  • Overview of the Pivot Table Tools Tabs
  • Creating a Pivot Chart from a Pivot Table or Data

Excel 2013 Advanced – Lesson 7
Macros

  • Displaying the Developer Tab
  • Recording and Running Macros
  • Changing the Security Level
  • Customizing & Changing Quick Access Toolbar

Excel 2013 Advanced  – Lesson 8
Solving Formula Errors

  • Using Named Ranges
  • Understanding Formula Errors
  • Using Error Checking
  • Using the Trace Errors Commands

Excel 2013 Advanced – Lesson 9
What if Analysis

  • Using Goal Seek
  • Using the Scenario Manager
  • Using a One Input Data Table

Excel 2013 Advanced – Lesson 10
Managing your Data

  • Transposing Data from Rows to Columns
  • Using the Text to Columns Feature
  • Checking for Duplicates & Consolidating Data

Excel 2013 Advanced – Lesson 11
Grouping and Outlining Data

  • Grouping Data
  • Adding Subtotals
  • Outlining Data

Excel 2013 Advanced – Lesson 12
Wrapping it up

  • Words from the Wise