Vocabulary

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

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

Chapter 3: Charting Data

• • Lesson 21: Building Basic Charts

  • Lesson 22: Showing Percentages with a Pie Chart (No vocabulary)

  • Lesson 23: Enhancing a Pie Chart

  • Lesson 24: Adding Special Elements to a Chart or Sheet and Updating a Chart

  • Lesson 25: Completing Chart Formatting and Lesson 26: Comparing and Analyzing Data

  • Lesson 27: Chart Printing and Publishing

  • Lesson 28: Using Charts in Other Files

  • Lesson 29: Making Special Purpose Charts

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 Data Models

  • Lesson 38: Working with Excel Online

Slide Presentation

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

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

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 Formatting

  • Lesson 26: Comparing and Analyzing Data

  • Lesson 27: Chart Printing and Publishing

  • Lesson 28: Using Charts in Other Files

  • Lesson 29: Making Special Purpose Charts

Chapter 4: Advanced Functions PivotCharts and PivotTables

• • Lesson 30: Working with Hyperlinks

  • Lesson 31: 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 Data Models

  • Lesson 38: Working with Excel Online

ILLUSTRAted:

Slide Presentation

Getting Started with Excel 2013

Working with Formulas and Functions

Formatting a Worksheet

Working with Charts

Analyzing Data Using Formulas

Managing Workbook Data

Managing Data Using Tables

Analyzing Table Data

Automating Worksheet Tasks

Enhancing Charts

Using What-If Analysis

Analyzing Data with PivotTables

Exchanging Data with Other Programs

Sharing Excel Files and Incorporating Web Information

Customizing Excel and Advanced Worksheet Management

Programming with Excel

videos

(Video library courtesy of Lynda.com)

01 Getting Started With Excel 2013

• • What is Excel Used For?

  • Using the menu system

  • The Quick Access Toolbar

  • The Structure of a Worksheet or Workbook

  • Using the Formula Bar

  • Using the Status Bar

  • Navigation and Mouse Pointers

  • Shortcut Menus and the Mini Toolbar

  • Using the Built-In Help

  • Creating New Files

02 Entering Data

• • Exploring Data Entry and Editing Techniques

  • Entering Data with AutoFill

  • Working with Dates and Times

  • Using Undo and Redo

  • Adding Comments

  • Using Save or Save As

03 Creating Formulas and Functions

• • Creating Simple Formulas Totals and Averages

  • Copying a Formula for Adjacent Cells

  • Calculating Year-To-Date Profits

  • Creating a Percentage-Increase Formula

  • Working with Relative Absolute and Mixed References

  • Using SUM and AVERAGE

  • Using Other Common Functions

04 Formatting

• • Exploring Font Styles and Effects

  • Adjusting Row Heights and Column Widths

  • Working with Alignment and Wrap Text

  • Designing Borders

  • Exploring Numeric and Special Formatting

  • Formatting Numbers and Dates

  • Conditional Formatting

  • Creating and Using Tables

  • Inserting Shapes Arrows and Other Visual Features

05 Adjusting Worksheet Layout and Data

• • Inserting and Deleting Rows and Columns

  • Hiding and Unhiding Rows and Columns

  • Moving Copying and Inserting Data

  • Finding and Replacing Data

06 Printing

• • Exploring the Page Layout Tab and View

  • Previewing Page Breaks

  • Working with page Setup and Printing Controls

07 Introduction to Charting

• • Creating Charts

  • Exploring Chart Types

  • Formatting Charts

  • Working with Axes Labels Gridlines and Other Chart Elements

  • Creating In-Cell charts with Sparklines

08 Adjusting Worksheet Views

• • Freezing and Unfreezing Panes

  • Splitting Screens Horizontally and Vertically

  • Showing Necessary Information with the Outllining Feature

09 Multiple Worksheets and Workbooks

• • Displaying Multiple Worksheets and Workbooks

  • Renaming, Inserting, and Deleting Sheets

  • Moving Copying and Grouping Sheets

  • Using Formulas to Link Worksheets and Workbooks

  • Locating and Maintaining Links

10 IF, VLOOKUP, and Power Functions

• • Using IF Functions and Relational Operators

  • Getting Approximate Table Data with the VLOOKUP Function

  • Getting Exact Table Data with the VLOOKUP Function

  • Using the COUNTIF Family of Functions

11 Security and Sharing

• • Unlocking Cells and Protecting Sheets

  • Protecting Workbooks

  • Assigning Passwords to Workbooks

  • Sharing Workbooks

  • Tracking Changes

12 Database Features

• • Sorting Data

  • Inserting Subtotals in a Sorted List

  • Using Filters

  • Splitting Data Into Multiple Columns

  • Removing Duplicate Records

13 PivotTables

• • Creating PivotTables

  • Manipulating PivotTable Data

  • Grouping By Data and Time

  • Grouping By Other Factors

  • Using Slicers to Clarify and Manipulate Fields

  • Using PivotCharts

14 Data Analysis Tools

• • Using Goal Seek

  • Using Solver

  • Using Scenario Manager

  • Using Data Tables

15 Introduction to Macros

• • Definition and Examples

  • Creating a Simple Macro

  • Running a Macro

Video Exercise Files