Learning Microsoft Excel 2013, Student Edition -- CTE/School

Learning Microsoft Excel 2013 features a student-friendly, step-by-step format with clear, full-screen shots to engage readers and help them work independently. This book is appropriate for Introductory Computing courses on Microsoft Office Applications or courses on Computer Concepts that include coverage of Excel 2013.This book is also suitable for individuals interested in learning to use Microsoft Excel 2013 effectively in their home life and career.

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