Prepare students for Microsoft® Excel 2013!
Learning Microsoft Excel 2013 features a student-friendly, step-by-step format with clear, full-screen shots to engage students and help them work independently.
Table of Contents:
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
