Microsoft Excel 2010 Training

Set Up a Workbook

• Creating Workbooks
• Modifying Workbook Content
• Modifying Worksheet Content

Customize the Excel 2010 Program Window

• Zooming In on a Worksheet
• Arranging Multiple Workbook Windows
• Adding Buttons to the Quick Access Toolbar
• Customizing the Ribbon
• Maximizing Usable Space in the Program Window

Work with Data and Excel Tables

• Entering and Revising Data
• Moving Data Within a Workbook
• Finding and Replacing Data
• Correcting and Expanding Upon Worksheet Data
• Defining Excel Tables

Apply Visual Effects

• Formatting Cells
• Applying Workbook Themes and Excel Table Styles
• Add Images to a Worksheet

Print Workbook Content

• Adding Headers and Footers to Printed Pages
• Preparing Worksheets for Printing
• Printing Worksheets
• Printing Parts of Worksheets
• Printing Charts

Perform Calculations on Data

• Naming Groups of Data
• Creating Formulas to Calculate Values
• Summarizing Data That Meets Specific Conditions
• Finding and Correcting Errors in Calculations

Create Styles and Format Data

• Defining Styles
• Making Numbers Easier to Read
• Changing the Appearance of Data Based on Its Value

Focus on Specific Data by Using Filters

• Defining Valid Sets of Values for Ranges of Cells
• Manipulating Worksheet Data
• Limiting Data that Appears on Your Screen

Reorder and Summarize Data

• Sorting Worksheet Data
• Organizing Data into Levels
• Looking Up Information in a Worksheet

Combine Data from Multiple Sources

• Using Workbooks as Templates for Other Workbooks
• Linking to Data in Other Worksheets and Workbooks
• Consolidating Multiple Sets of Data into a Single Workbook
• Grouping Multiple Sets of Data

Analyze Alternative Data Sets

• Defining an Alternative Data Set
• Defining Multiple Alternative Data Sets
• Varying Your Data to Get a Desired Result by Using Goal Seek
• Finding Optimal Solutions by Using Solver
• Analyzing Data by Using Descriptive Statistics

Create Dynamic Worksheets by Using PivotTables

• Analyzing Data Dynamically by Using PivotTables
• Filtering, Showing, and Hiding PivotTable Data
• Editing PivotTables
• Formatting PivotTables
• Creating PivotTables from External Data

Create Charts and Graphics

• Creating Charts
• Customizing the Appearance of Charts
• Finding Trends in Your Data
• Summarizing Your Data by Using Sparklines
• Creating Dynamic Charts by Using PivotCharts
• Creating Diagrams by Using SmartArt
• Creating Shapes and Mathematical Equations

Automate Repetitive Tasks by Using Macros

• Enabling and Examining Macros
• Creating and Modifying Macros
• Running Macros When a Button is Clicked
• Running Macros When a Workbook is Opened

Work with Other Microsoft Office Programs

• Including Office Documents in Workbooks
• Storing Workbooks as Parts of Other Office Documents
• Creating Hyperlinks
• Pasting Charts into Other Documents

Collaborate with Colleagues

• Sharing Workbooks
• Managing Comments
• Tracking and Managing Colleagues' Changes
• Protecting Workbooks and Worksheets
• Authenticating Workbooks
• Saving Workbooks for the Web