- Set Up a Workbook
- Customize the Excel 2010 Program Window
- Work with Data and Excel Tables
- Apply Visual Effects
- Print Workbook Content
- Perform Calculations on Data
- Create Styles and Format Data
- Focus on Specific Data by Using Filters
- Reorder and Summarize Data
- Combine Data from Multiple Sources
- Analyze Alternative Data Sets
- Create Dynamic Worksheets by Using PivotTables
- Create Charts and Graphics
- Automate Repetitive Tasks by Using Macros
- Work with Other Microsoft Office Programs
- Collaborate with Colleagues
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