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

by Emergent Learning; Wempen, Faithe

• ISBN13: 9780133149104
• ISBN10: 0133149102
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2013-09-16
• Publisher: Pearson

Summary

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