Excel 2010 Advanced

Your participants will learn how to use the advanced features of Excel 2010. This workshop is designed to teach you an advanced understanding of Excel 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.
Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information – and better information leads to better decision making!

Course Outline

Module One: Getting Started
• Icebreaker
• Housekeeping Items
• The Parking Lot
• Workshop Objectives

Module Two: SmartArt and Objects
• Inserting SmartArt
• Adding Text to the Diagram
• Resizing and Moving the Diagram
• Resetting the Diagram
• Adding Pictures from Your Computer
• Adding Clip Art
• Adding Text Boxes
• Drawing Shapes
• About the Contextual Tabs

Module Three: Auditing
• Tracing Precedent Cells
• Tracing the Dependents of a Cell
• Displaying Formulas within the Sheet
• Adding, Displaying, Editing, and Removing Comments

Module Four: Creating Charts
• Inserting a Chart
• Overview of the Chart Tools Tab
• Understanding the Parts of a Chart
• Changing the Chart Style
• Resizing and Moving the Chart

Module Five: Creating Pivot Tables
• Inserting a PivotTable
• Choosing Fields and Grouping Data
• Overview of the Pivot Table Tools Tabs

Module Six: Working with PivotTables and Pivot Charts
• Changing the Data Displayed and Refreshing the PivotTable
• Applying a Style to Your Pivot Table
• Creating a Pivot Chart from a Pivot Table
• Creating a Pivot Chart from Data
• Some Real-life Examples

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

Module Eight: Solving Formula Errors
• Using Named Ranges
• Understanding Formula Errors
• Using the Trace Errors Commands
• Using Error Checking
• Evaluating Formulas

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 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 Eleven: Grouping and Outlining Data
• Grouping Data
• Adding Subtotals
• Outlining Data
• Viewing Grouped and Outlined Data


Module Twelve: Wrapping Up
• Words from the Wise
• Review of Parking Lot
• Lessons Learned
• Completion of Action Plans and Evaluations

Previous

Next