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