Using the Common Features of Microsoft Office 2013
Lesson 1 - Microsoft Office 2013 Basics
Lesson 2 - Saving, Printing, and Closing Microsoft Office Files
Lesson 3 - Working with Existing Files
Lesson 4 - Using Command Options
Lesson 5 - Managing Program Windows
Lesson 6 - Using Microsoft Office Help
Lesson 7 - Managing Information Technology
End-of-Chapter Activities 73
Chapter 1
Getting Started with Microsoft Excel 2013
Lesson 1 - Touring Excel
Lesson 2 - Worksheet and Workbook Basics
Lesson 3 - Adding Worksheet Contents
Lesson 4 - Worksheet Formatting
Lesson 5 - More on Cell Entries and Formatting
Lesson 6 - Working with Ranges
Lesson 7 - Creating Formulas
Lesson 8 - Copying and Pasting
Lesson 9 - Techniques for Moving Data
Lesson 10 - Sheet, Display, and Print Operations
End-of-Chapter Activities
Chapter 2
Working with Formulas and Functions
Lesson 11 - Getting Started with Functions
Lesson 12 - Using Excel Tables
Lesson 13 - Working with the NOW Function and Named Ranges
Lesson 14 - Working with IF Functions
Lesson 15 - Working with Text Functions
Lesson 16 - Using Frozen Labels and Panes
Lesson 17 - Using Conditional Formatting and Find and Replace
Lesson 18 - Rotating Entries and Resolving Errors
Lesson 19 - Managing Worksheets and Performing Multi-Worksheet Operations
Lesson 20 - Modifying Print Options
End-of-Chapter Activities
Chapter 3
Charting Data
Lesson 21 - Building Basic Charts
Lesson 22 - Showing Percentages with a Pie Chart
Lesson 23 - Enhancing a Pie Chart
Lesson 24 - Adding Special Elements to a Chart or Sheet and Updating a Chart
Lesson 25 - Completing Chart Format ting
Lesson 26 - Comparing and Analyzing Data
Lesson 27 - Char t Printing and Publishing
Lesson 28 - Using Charts in Other Files
Lesson 29 - Making Special Purpose Charts
End-of-Chapter Activities
Excel Chapter 4
Advanced Functions, PivotCharts, and PivotTables
Lesson 30 - Working with Hyperlinks
Lesson 31 - Using Advanced Sort
Lesson 32 - Using Advanced Filtering
Lesson 33 - Using Advanced Functions to Predict Trends
Lesson 34 - Using Advanced Functions for Data Analysis
Lesson 35 - Using LOOKUP Functions
Lesson 36 - Working with PivotTables and PivotCharts
Lesson 37 - Working with the Excel Data Model
Lesson 38 - Working with PowerPivot and Power View
End-of-Chapter Activities
Excel Chapter 5
Advanced Formatting and Workbook Features
Lesson 39 - Working with File Formats
Lesson 40 - Working with Graphics and Saving a Worksheet As a Web Page
Lesson 41 - Working with Web Data
Lesson 42 - Linking and Embedding Data
Lesson 43 - Working with Workbooks
Lesson 44 - Working with Comments and Modifying Page Setup
Lesson 45 - Using Copy and Paste Special
Lesson 46 - Moving and Linking Data Between Workbooks
Lesson 47 - Working with 3-D Formulas
Lesson 48 - Working with Data Validation and Macros
End-of-Chapter Activities
Excel Chapter 6
Managing Large Workbooks
Lesson 49 - Customizing the Excel Interface and Converting Text
Lesson 50 - Formatting Cells
Lesson 51 - Hiding and Formatting Workbook Elements
Lesson 52 - Customizing Styles and Themes
Lesson 53 - Customizing Data Entry
Lesson 54 - Formatting and Replacing Data Using Functions
Lesson 55 - Working with Subtotals
End-of-Chapter Activities
Chapter 7
Creating Charts, Shapes, and Templates
Lesson 56 - Formatting Chart Elements
Lesson 57 - Format ting the Value Axis
Lesson 58 - Creating Stacked Area Charts
Lesson 59 - Working with Sparklines and Trendlines
Lesson 60 - Drawing and Positioning Shapes
Lesson 61 - Formatting Shapes
Lesson 62 - Enhancing Shapes with Text and Effects
Lesson 63 - Working with Templates
End-of-Chapter Activities
Chapter 8
Creating Macros and Using Data Analysis Tools
Lesson 64 - Recording a Macro
Lesson 65 - Using Functions
Lesson 66 - Working with Absolute References and Using Financial Functions
Lesson 67 - Creating and Interpreting Financial Statements
Lesson 68 - Creating Scenarios and Naming Ranges
Lesson 69 - Finding and Fixing Errors in Formulas
End-of-Chapter Activities
Chapter 9
Importing and Analyzing Database Data
Lesson 70 - Importing Data into Excel
Lesson 71 - Working with Excel Tables
Lesson 72 - Using Advanced Filters, Slicers, and Database Functions
Lesson 73 - Using Flash Fill and Data Consolidation
Lesson 74 - Linking Workbooks
Lesson 75 - Using PivotTables
Lesson 76 - Using PivotCharts
Lesson 77 - Using PowerPivot and Power View
End-of-Chapter Activities
Chapter 10
Collaborating with Others and Preparing a Final Workbook for Distribution
Lesson 78 - Tracking Changes
Lesson 79 - Ensuring Data Integrity
Lesson 80 - Protecting Data
Lesson 81 - Securing a Workbook
Lesson 82 - Finalizing a Workbook
Lesson 83 - Sharing a Workbook
End-of-Chapter Activities
