Microsoft Excel 2013 – Advanced

Microsoft Excel 2013 – Advanced





This Course is Endorsed By

Excel 2013 Advanced Workshop

In this course, you will learn how to use the advanced features of Excel 2013. The course lessons are designed to teach you how to do the more advanced features contained in Excel 2013 with step by step instructions. Throughout this course, you will be presented with practical demonstrations and gain a deeper understanding 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!    

Workshop Objectives:

  • 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:

Module One: Getting Started
  • Course Objectives
Module Two: SmartArt and Objects
  • Inserting SmartArt
  • Editing the Diagram
  • Adding Pictures
  • Adding Textboxes
  • Drawing Shapes
  • About the Contextual Tabs
  • Module Two: Review Questions
Module Three: Auditing
  • Tracing Precedent Cells
  • Tracing the Dependents of a Cell
  • Displaying Formulas Within the Sheet
  • Adding, Displaying, Editing, and Removing Comments
  • Module Three: Review Questions
Module Four: Creating Charts
  • Using Recommended Charts
  • Inserting a Chart
  • Overview of the Chart Tools Tabs
  • Understanding Chart Elements
  • Resizing and Moving the Chart
  • Module Four: Review Questions
Module Five: Working with Charts
  • Using Chart Elements
  • Using Chart Styles and Colors
  • Using Chart Filters
  • Working with Data Labels
  • Module Five: Review Questions
Module Six: 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
  • Module Six: Review Questions
Module Seven: Macros
  • Displaying the Developer Tab
  • Recording and Running Macros
  • Changing the Security Level
  • Customizing and Changing the Quick Access Toolbar
  • Module Seven: Review Questions
Module Eight: Solving Formula Errors
  • Using Named Ranges
  • Understanding Formula Errors
  • Using Error Checking
  • Using the Trace Errors Commands
  • Evaluating Formulas
  • Module Eight: Review Questions
Module Nine: Using What If Analysis
  • Using Goal Seek
  • Using the Scenario Manager
  • Using a One Input Data Table
  • Using a Two Input Data Table
  • Module Nine: Review Questions
Module Ten: Managing Your Data
  • Transposing Data from Rows to Columns
  • Using the Text to Columns Feature
  • Checking for Duplicates
  • Creating Data Validation Rules
  • Consolidating Data
  • Module Ten: Review Questions
Module Eleven: Grouping and Outlining Data
  • Grouping Data
  • Adding Subtotals
  • Outlining Data
  • Viewing Grouped and Outlined Data
  • Module Eleven: Review Questions
 Module Twelve: Wrapping Up


There are no reviews yet.

Be the first to review “Microsoft Excel 2013 – Advanced”

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.