| |
| |
Common Features | |
| |
| |
| |
Using the Common Features of Microsoft Office 2010 | |
| |
| |
| |
PowerPoint File | |
| |
| |
| |
Use Windows Explorer to Locate Files and Folders | |
| |
| |
| |
Using Windows Explorer to Locate Files and Folders | |
| |
| |
| |
Locate and Start a Microsoft Office 2010 Program | |
| |
| |
| |
Locating and Starting a Microsoft Office 2010 Program | |
| |
| |
| |
Enter and Edit Text in an Office 2010 Program | |
| |
| |
| |
Entering and Editing Text in an Office 2010 Program | |
| |
| |
| |
Perform Commands from a Dialog Box | |
| |
| |
| |
Performing Commands from a Dialog Box | |
| |
| |
| |
Create a Folder, Save a File, and Close a Program | |
| |
| |
| |
Creating a Folder, Saving a File, and Closing a Program | |
| |
| |
| |
Add Document Properties and Print a File | |
| |
| |
| |
Adding Document Properties and Printing a File | |
| |
| |
| |
Word File | |
| |
| |
| |
Open an Existing File and Save it with a New Name | |
| |
| |
| |
Opening an Existing File and Saving it with a New Name | |
| |
| |
| |
Explore Options for an Application | |
| |
| |
| |
Viewing Application Options | |
| |
| |
| |
Perform Commands from the Ribbon | |
| |
| |
| |
Performing Commands from the Ribbon | |
| |
| |
| |
Minimizing and Using the Keyboard to Control the Ribbon | |
| |
| |
| |
Apply Formatting in Office Programs | |
| |
| |
| |
Formatting and Viewing Pages | |
| |
| |
| |
Formatting Text | |
| |
| |
| |
Using the Office Clipboard to Cut, Copy, and Paste | |
| |
| |
| |
Viewing Print Preview and Printing a Word Document | |
| |
| |
| |
Use the Microsoft Office 2010 Help System | |
| |
| |
| |
Using the Microsoft Office 2010 Help System in Excel | |
| |
| |
| |
Compress Files | |
| |
| |
| |
Compressing Files | |
| |
| |
Excel | |
| |
| |
| |
Creating a Worksheet and Charting Data | |
| |
| |
| |
Sales Report with Embedded Column Chart and Sparklines | |
| |
| |
| |
Create, Save, and Navigate an Excel Workbook | |
| |
| |
| |
Starting Excel and Naming and Saving a Workbook | |
| |
| |
| |
Navigating a Worksheet and a Workbook | |
| |
| |
| |
Enter Data in a Worksheet | |
| |
| |
| |
Entering Text and Using AutoComplete | |
| |
| |
| |
Using Auto Fill and Keyboard Shortcuts | |
| |
| |
| |
Aligning Text and Adjusting the Size of Columns | |
| |
| |
| |
Entering Numbers | |
| |
| |
| |
Construct and Copy Formulas and Use the SUM Function | |
| |
| |
| |
Constructing a Formula and Using the SUM Function | |
| |
| |
| |
Copying a Formula by Using the Fill Handle | |
| |
| |
| |
Format Cells with Merge & Center and Cell Styles | |
| |
| |
| |
Using Merge & Center and Applying Cell Styles | |
| |
| |
| |
Formatting Financial Numbers | |
| |
| |
| |
Chart Data to Create a Column Chart and Insert Sparklines | |
| |
| |
| |
Charting Data in a Column Chart | |
| |
| |
| |
Creating and Formatting Sparklines | |
| |
| |
| |
Print, Display Formulas, and Close Excel | |
| |
| |
| |
Changing Views, Creating a Footer, and Using Print Preview | |
| |
| |
| |
Deleting Unused Sheets in a Workbook | |
| |
| |
| |
Printing a Worksheet | |
| |
| |
| |
Displaying, Printing, and Hiding Formulas | |
| |
| |
| |
Inventory Valuation | |
| |
| |
| |
Check Spelling in a Worksheet | |
| |
| |
| |
Checking Spelling in a Worksheet | |
| |
| |
| |
Enter Data by Range | |
| |
| |
| |
Entering Data by Range | |
| |
| |
| |
Construct Formulas for Mathematical Operations | |
| |
| |
| |
Using Arithmetic Operators | |
| |
| |
| |
Copying Formulas Containing Absolute Cell References | |
| |
| |
| |
Edit Values in a Worksheet | |
| |
| |
| |
Editing Values in a Worksheet | |
| |
| |
| |
Formatting Cells with the Percent Style | |
| |
| |
| |
Format a Worksheet | |
| |
| |
| |
Inserting and Deleting Rows and Columns | |
| |
| |
| |
Adjusting Column Widths and Wrapping Text | |
| |
| |
| |
Using Functions, Creating Tables, and Managing Large Workbooks | |
| |
| |
| |
Inventory Status Report | |
| |
| |
| |
Use the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions | |
| |
| |
| |
Using the SUM and AVERAGE Functions | |
| |
| |
| |
Using the MEDIAN Function | |
| |
| |
| |
Using the MIN and MAX Functions | |
| |
| |
| |
Move Data, Resolve Error Messages, and Rotate Text | |
| |
| |
| |
Moving Data and Resolving a # # # # # Error Message | |
| |
| |
| |
Rotating Text | |
| |
| |
| |
Use COUNTIF and IF Functions and Apply Conditional Formatting | |
| |
| |
| |
Using the COUNTIF Function | |
| |
| |
| |
Using the IF Function | |
| |
| |
| |
Applying Conditional Formatting by Using Highlight | |
| |
| |
Cells Rules and Data Bars | |
| |
| |
| |
Using Find and Replace | |
| |
| |
| |
Use Date & Time Functions and Freeze Panes | |
| |
| |
| |
Using the NOW Function to Display a System Date | |
| |
| |
| |
Freezing and Unfreezing Panes | |
| |
| |
| |
Create, Sort, and Filter an Excel Table | |
| |
| |
| |
Creating an Excel Table | |
| |
| |
| |
Sorting and Filtering an Excel Table | |
| |
| |
| |
Converting a Table to a Range of Data | |
| |
| |
| |
Format and Print a Large Worksheet | |
| |
| |
| |
Printing Titles and Scaling to Fit | |
| |
| |
| |
Weekly Sales Summary | |
| |
| |
| |
Navigate a Workbook and Rename Worksheets | |
| |
| |
| |
Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color of Worksheets | |
| |
| |
| |
Enter Dates, Clear Contents, and Clear Formats | |
| |
| |
| |
Entering and Formatting Dates | |
| |
| |
| |
Clearing Cell Contents and Formats | |
| |
| |
| |
Copy and Paste by Using the Paste Options Gallery | |
| |
| |
| |
Copying and Pasting by Using the Paste Options Gallery | |
| |
| |
| |
Edit and Format Multiple Worksheets at the Same Time | |
| |
| |
| |
Grouping Worksheets for Editing | |
| |
| |
| |
Formatting and Constructing Formulas on Grouped Worksheets | |
| |
| |
| |
Create a Summary Sheet with Column Sparklines | |
| |
| |
| |
Constructing Formulas that Refer to Cells in Another Worksheet | |
| |
| |
| |
Changing Values in a Detail Worksheet to Update a Summary Worksheet | |
| |
| |
| |
Inserting Sparklines | |
| |
| |
| |
Format and Print Multiple Worksheets in a Workbook | |
| |
| |
| |
Moving and Formatting Worksheets in a Workbook | |
| |
| |
| |
Printing All the Worksheets in a Workbook | |
| |
| |
| |
Analyzing Data with Pie Charts, Line Charts, and What-If | |
| |
| |
Analysis Tools | |
| |
| |
| |
Budget Pie Chart | |
| |
| |
| |
Chart Data with a Pie Chart | |
| |
| |
| |
Creating a Pie Chart and a Chart Sheet | |
| |
| |
| |
Format a Pie Chart | |
| |
| |
| |
Applying Percentages to Labels in a Pie Chart | |
| |
| |
| |
Formatting a Pie Chart with 3-D | |
| |
| |
| |
Rotating a Pie Chart | |
| |
| |
| |
Exploding and Coloring a Pie Slice | |
| |
| |
| |
Formatting the Chart Area | |
| |
| |
| |
Inserting a Text Box in a Chart | |
| |
| |
| |
Edit a Workbook and Update a Chart | |
| |
| |
| |
Editing a Workbook and Updating a Chart | |
| |
| |
| |
Inserting WordArt in a Worksheet | |
| |
| |
| |
Use Goal Seek to Perform What-If Analysis | |
| |
| |
| |
Using Goal Seek to Perform What-If Analysis | |
| |
| |
| |
Preparing and Printing a Workbook with a Chart Sheet | |
| |
| |
| |
Growth Projection with Line Chart | |
| |
| |
| |
Design a Worksheet for What-If Analysis | |
| |
| |
| |
Using Parentheses in a Formula to Calculate a Percentage Rate of Increase | |
| |
| |
| |
Using Format Painter and Formatting as You Type | |
| |
| |
| |
Calculating a Value After an Increase | |
| |
| |
| |
Answer What-If Questions by Changing Values in a Worksheet | |
| |
| |
| |
Answering What-If Questions and Using Paste Special | |
| |
| |
| |
Chart Data with a Line Chart | |
| |
| |
| |
Inserting Multiple Rows and Creating a Line Chart | |
| |
| |
| |
Formatting Axes in a Line Chart | |
| |
| |
| |
Formatting the Chart and Plot Areas | |
| |
| |
| |
Preparing and Printing Your Worksheet | |
| |
| |
| |
Excel Chapters 1-3 | |
| |
| |
| |
Use Financial and Lookup Functions, Define Names, and Validate Data | |
| |
| |
| |
Amortization Schedule | |
| |
| |
| |
Use Financial Functions | |
| |
| |
| |
Inserting the PMT Financial Function | |
| |
| |
| |
Use Goal Seek | |
| |
| |
| |
Using Goal Seek to Produce a Desired Result | |
| |
| |
| |
Using Goal Seek to Find an Increased Period | |
| |
| |
| |
Create a Data Table | |
| |
| |
| |
Designing a Two-Variable Data Table | |
| |
| |
| |
Using a Data Table to Calculate Options | |
| |
| |
| |
Quarterly Cost Report and Lookup Form | |
| |
| |
| |
Define Names | |
| |
| |
| |
Defining a Name | |
| |
| |
| |
Inserting New Data into a Named Range | |
| |
| |
| |
Changing A Defined Name | |
| |
| |
| |
Creating a Defined Name by Using Row and Column Titles | |
| |
| |
| |
Use Defined Names in a Formula | |
| |
| |
| |
Using Defined Names in a Formula | |
| |
| |
| |
Use Lookup Functions | |
| |
| |
| |
Defining a Range of Cells for a Lookup Function | |
| |
| |
| |
Inserting the VLOOKUP Function | |
| |
| |
| |
Validate Data | |
| |
| |
| |
Creating a Validation List | |
| |
| |
| |
Managing Large Workbooks and Using Advanced Sorting and Filtering | |
| |
| |
| |
Large Worksheet for a Class Schedule | |
| |
| |
| |
Navigate and Manage Large Worksheets | |
| |
| |
| |
Using the Go To Special Command | |
| |
| |
| |
Hiding Columns | |
| |
| |
| |
Using the Go To Command | |
| |
| |
| |
Arranging Multiple Workbooks and Splitting Worksheets | |
| |
| |
| |
Enhance Worksheets with Themes and Styles | |
| |
| |
| |
Changing and Customizing a Workbook Theme | |
| |
| |
| |
Creating and Applying a Custom Table Style | |
| |
| |
| |
Format a Worksheet to Share with Others | |
| |
| |
| |
Previewing and Modifying Page Breaks | |
| |
| |
| |
Repeating Column or Row Titles | |
| |
| |
| |
Inserting a Hyperlink in a Worksheet | |
| |
| |
| |
Modifying a Hyperlink | |
| |
| |
| |
Save Excel Data in Other File Formats | |
| |
| |
| |
Viewing and Saving a Workbook as a Web Page | |
| |
| |
| |
Saving Excel Data in CSV File Format | |
| |
| |
| |
Saving Excel Data as a PDF or XPS File | |
| |
| |
| |
Sorted, Filtered, and Outlined Database | |
| |
| |
| |
Use Advanced Sort Techniques | |
| |
| |
| |
Sorting on Multiple Columns | |
| |
| |
| |
Sorting by Using a Custom List | |
| |
| |
| |
Use Custom and Advanced Filters | |
| |
| |
| |
Filtering by Format and Value Using AutoFilter | |
| |
| |
| |
Filtering by Custom Criteria Using AutoFilter | |
| |
| |
| |
Inserting the Sheet Name and Page Numbers in a Footer | |
| |
| |
| |
Filtering by Using Advanced Criteria | |
| |
| |
| |
Extracting Filtered Rows | |
| |
| |
| |
Subtotal, Outline, and Group a List of Data | |
| |
| |
| |
Subtotaling, Outlining, and Grouping a List of Data | |
| |
| |
| |
Creating Charts, Diagrams, and Templates | |
| |
| |
| |
Attendance Charts and Diagrams | |
| |
| |
| |
Create and Format Sparklines and a 3-D Column Chart | |
| |
| |
| |
Creating and Formatting Sparklines | |
| |
| |
| |
Creating a 3-D Column Chart | |
| |
| |
| |
Changing the Display of Chart Data | |
| |
| |
| |
Editing and Formatting the Chart Title | |
| |
| |
| |
Adding, Formatting, and Aligning Axis Titles | |
| |
| |
| |
Editing Source Data | |
| |
| |
| |
Formatting the Chart Floor and Chart Walls | |
| |
| |
| |
Create and Format a Line Chart | |
| |
| |
| |
Creating a Line Chart | |
| |
| |
| |
Deleting a Legend and Changing a Chart Title | |
| |
| |
| |
Changing the Values on the Value Axis | |
| |
| |
| |
Formatting the Plot Area and the Data Series | |
| |
| |
| |
Inserting a Trendline | |
| |
| |
| |
Create and Modify a SmartArt Graphic | |
| |
| |
| |
Creating a Process SmartArt Graphic | |
| |
| |
| |
Modifying the Diagram Style | |
| |
| |
| |
Create and Modify an Organization Chart | |
| |
| |
| |
Creating and Modifying a SmartArt Organization Chart 3 | |
| |
| |
| |
Adding Effects to a SmartArt Graphic | |
| |
| |
| |
Preparing Worksheets Containing Charts and Diagrams for Printing | |
| |
| |
| |
Order Form Template | |
| |
| |
| |
Create an Excel Template | |
| |
| |
| |
Entering Template Text | |
| |
| |
| |
Formatting a Template | |
| |
| |
| |
Entering Template Formulas | |
| |
| |
| |
Inserting and Modifying an Image | |
| |
| |
| |
Inserting and Modifying a WordArt Image | |
| |
| |
| |
Saving a File as a Template | |
| |
| |
| |
Protect a Worksheet | |
| |
| |
| |
Protecting a Worksheet | |
| |
| |
| |
Create a Worksheet Based on a Template | |
| |
| |
| |
Creating a Worksheet Based on a Template | |
| |
| |
| |
Excel Chapters 4-6 | |
| |
| |
| |
Creating PivotTable and PivotChart Reports and Auditing Worksheets | |
| |
| |
| |
PivotTable and PivotChart | |
| |
| |
| |
Create a PivotTable Report | |
| |
| |
| |
Creating a PivotTable Report | |
| |
| |
| |
Adding Fields to a PivotTable Report | |
| |
| |
| |
Use Slicers and Search Filters | |
| |
| |
| |
Using a Slicer to Filter a PivotTable | |
| |
| |
| |
Clearing Filters and Filtering by Using the Search Box | |
| |
| |
| |
Modify a PivotTable Report | |
| |
| |
| |
Rearranging a PivotTable Report | |
| |
| |
| |
Displaying PivotTable Report Details in a New Worksheet | |
| |
| |
| |
Displaying PivotTable Data on Separate Pages | |
| |
| |
| |
Changing Calculations in a PivotTable Report | |
| |
| |
| |
Formatting a PivotTable Report | |
| |
| |
| |
Updating PivotTable Report Data | |
| |
| |
| |
Create a PivotChart Report | |
| |
| |
| |
Creating a PivotChart Report from a PivotTable Report | |
| |
| |
| |
Modifying a PivotChart Report | |
| |
| |
| |
Revenue Report for Formula Auditing | |
| |
| |
| |
Trace Precedents and Dependents to Audit Worksheet Formulas | |
| |
| |
| |
Using the Trace Precedents Command | |
| |
| |
| |
Using the Trace Dependents Command | |
| |
| |
| |
Using the Trace Dependents Command | |
| |
| |
| |
Using the Trace Error Command | |
| |
| |
| |
Use Error Checking to Audit Worksheet Formulas | |
| |
| |
| |
Using Error Checking | |
| |
| |
| |
Circling Invalid Data | |
| |
| |
| |
Use the Watch Window to Monitor Cell Values | |
| |
| |
| |
Using the Watch Window to Monitor Changes | |
| |
| |
| |
Using the Data Analysis, Solver, and Scenario Features | |
| |
| |
| |
Sales Analysis | |
| |
| |
| |
Calculate a Moving Average | |
| |
| |
| |
Creating a Custom Number Format | |
| |
| |
| |
Calculating a Moving Average | |
| |
| |
| |
Modifying the Moving Average Chart | |
| |
| |
| |
Calculating Growth Based on a Moving Average | |
| |
| |
| |
Project Income and Expenses | |
| |
| |
| |
Projecting Income and Expenses | |
| |
| |
| |
Determine a Break-Even Point | |
| |
| |
| |
Charting the Break-Even Point With a Line Chart | |
| |
| |
| |
Staffing Analysis | |
| |
| |
| |
Use Solver | |
| |
| |
| |
Installing Solver | |
| |
| |
| |
Understanding a Solver Worksheet | |
| |
| |
| |
Using Solver | |
| |
| |
| |
Evaluate Complex Formulas | |
| |
| |
| |
Evaluating Complex Formulas | |
| |
| |
| |
Create Scenarios | |
| |
| |
| |
Creating a Scenario Using the Scenario Manager | |
| |
| |
| |
Creating a Scenario Using Solver | |
| |
| |
| |
Creating a Scenario Summary | |
| |
| |
| |
Using Macros and Visual Basic for Applications | |
| |
| |
| |
Travel Expenses | |
| |
| |
| |
Record a Macro | |
| |
| |
| |
Adding the Developer Tab to the Ribbon | |
| |
| |
| |
Changing the Macro Security Settings in Excel | |
| |
| |
| |
Unprotecting a Workbook | |
| |
| |
| |
Recording a Macro | |
| |
| |
| |
Assign a Macro to a Button on the Quick Access Toolbar | |
| |
| |
| |
Adding a Button to the Quick Access Toolbar | |
| |
| |
| |
Testing the Macro Button | |
| |
| |
| |
Modify a Macro | |
| |
| |
| |
Changing the Visual Basic Code | |
| |
| |
| |
VBA Procedure | |
| |
| |
| |
Write a VBA Procedure to Use an ActiveX Control | |
| |
| |
| |
Inserting ActiveX Controls | |
| |
| |
| |
Changing the Properties of an ActiveX Control | |
| |
| |
| |
Writing a VBA Procedure for a Command Button | |
| |
| |
| |
Modifying a VBA Procedure | |
| |
| |
| |
Testing the VBA Procedure and the ActiveX Control | |
| |
| |
| |
Restore Initial Settings | |
| |
| |
| |
Removing the Quick Access Toolbar Button and the Macro | |
| |
| |
| |
Excel Chapters 7-9 | |
| |
| |
| |
External Data, Database Functions, and Side-by-Side | |
| |
| |
Tables | |
| |
| |
| |
Medical Center Information | |
| |
| |
| |
Get External Data into Excel | |
| |
| |
| |
Importing Information into Excel from an Access Database | |
| |
| |
| |
Importing Information into Excel from a Web Page | |
| |
| |
| |
Importing Information into Excel from a Text File | |
| |
| |
| |
Importing Information into Excel from an XML File | |
| |
| |
| |
Create a Query and Use the Query Wizard to Sort and Filter | |
| |
| |
| |
Creating a Query and Filtering and Sorting Data by Using the Query Wizard | |
| |
| |
| |
Converting a Range and Formatting Imported Data | |
| |
| |
| |
Use DAVERAGE and DSUM Database Functions | |
| |
| |
| |
Using the DAVERAGE Database Function | |
| |
| |
| |
Using the DSUM Database Function | |
| |
| |
| |
Use DCOUNT and DGET Database Functions | |
| |
| |
| |
Using DCOUNT | |
| |
| |
| |
Using DGET | |
| |
| |
| |
Office Equipment Inventory | |
| |
| |
| |
Insert a Second Table into a Worksheet | |
| |
| |
| |
Inserting a Second Table into a Worksheet | |
| |
| |
| |
Sorting Side-by-Side Tables | |
| |
| |
| |
Apply Conditional Formatting to Side-by-Side Tables | |
| |
| |
| |
Applying Icon Sets to Side-by-Side Tables | |
| |
| |
| |
Insert a Screenshot | |
| |
| |
| |
Inserting a Screen Shot | |
| |
| |
| |
Create Custom Headers and Footers | |
| |
| |
| |
Creating Custom Headers and Footers | |
| |
| |
| |
Collaborating with Others and Preparing a Workbook for Distribution | |
| |
| |
| |
Summer Schedule | |
| |
| |
| |
Create a Shared Workbook | |
| |
| |
| |
Locating and Modifying Workbook Properties | |
| |
| |
| |
Activating Track Changes to Create a Shared Workbook | |
| |
| |
| |
Track Changes Made to a Workbook | |
| |
| |
| |
Making a Copy of a Shared Workbook | |
| |
| |
| |
Making Changes to a Shared Workbook | |
| |
| |
| |
Making Changes to a Copy of the Shared Workbook | |
| |
| |
| |
Merge Workbooks and Accept Changes | |
| |
| |
| |
Merging Revisions | |
| |
| |
| |
Accepting or Rejecting Tracked Changes | |
| |
| |
| |
Removing the Shared Designation, Resetting the User Name, and Removing a Command from the Quick Access Toolbar | |
| |
| |
| |
Adding a Signature Line | |
| |
| |
| |
Distributed Workbook | |
| |
| |
| |
Prepare a Final Workbook for Distribution | |
| |
| |
| |
Ensuring Backward-Compatibility in a Workbook | |
| |
| |
| |
Inspecting a Document | |
| |
| |
| |
Encrypting a Workbook | |
| |
| |
| |
Marking a Workbook as Final | |
| |
| |
| |
Upload a Workbook to SkyDrive | |
| |
| |
| |
Uploading a Workbook to SkyDrive | |
| |
| |
| |
Excel Chapters 10-11 | |
| |
| |
Glossary | |
| |
| |
Index | |