Excel 2013

Office Basics

• 1

  Buying Office 2013

  

  • Introduction

  • Office 2013 purchasing options

  • Office for other devices

• 2

  Working with Your Microsoft Account and OneDrive

  

  • Working with your Microsoft Account and OneDrive

  • Storing files in the cloud with OneDrive

  • Sharing and collaborating with OneDrive

• 3

  Understanding Office 365

  

  • All about Office 365

  • Managing your Office 365 subscription

Excel Basics

• 4

  Getting Started with Excel

  

  • Introduction

  • Working with the Excel environment

  • The Quick Access Toolbar

  • Backstage view

  • Worksheet views

  • Challenge!

  

  • Getting to Know Excel

    Learn your way around Excel 2013, a spreadsheet program in the Microsoft Office suite.

    04:1817,295 views
• 5

  Creating and Opening Workbooks

  

  • Introduction

  • Using templates

  • Compatibility mode

  • Challenge!

  

  • Creating and Opening Workbooks

    Find out how to create and open workbooks in Excel 2013.

    02:137,991 views
• 6

  Saving and Sharing Workbooks

  

  • Introduction

  • AutoRecover

  • Exporting workbooks

  • Sharing workbooks

  • Challenge!

  

  • Saving and Sharing Workbooks

    Simple ways to save, share, and export workbooks in Excel 2013.

    03:524,944 views
• 7

  Cell Basics

  

  • Introduction

  • Cell content

  • Find and Replace

  • Challenge!

  

  • Cell Basics

    Tips for working with cells and entering data in Excel 2013.

    06:067,440 views
• 8

  Modifying Columns, Rows, and Cells

  

  • Introduction

  • Inserting, deleting, moving, and hiding rows and columns

  • Wrapping text and merging cells

  • Challenge!

  

  • Modifying Columns, Cells, and Rows

    How to modify columns, rows, and cells, including wrapping text and merging.

    04:326,625 views
• 9

  Formatting Cells

  

  • Introduction

  • Text alignment

  • Cell borders and fill colors

  • Cell styles

  • Formatting text and numbers

  • Challenge!

  

  • Formatting Cells

    Learn how to format cells to make your workbooks more visually appealing.

    04:107,745 views
• 10

  Worksheet Basics

  

  • Introduction

  • Grouping and ungrouping worksheets

  • Challenge!

  

  • Worksheet Basics

    Find out how to create additional worksheets, and group them for easy editing.

    03:534,400 views
• 11

  Page Layout

  

  • Introduction

  • Challenge!

  

  • Page Layout

    A quick look at page layout and formatting options in Word 2013.

    02:3812,014 views
• 12

  Printing Workbooks

  

  • Introduction

  • Choosing a print area

  • Fitting and scaling content

  • Challenge!

  

  • Printing Workbooks

    Easy ways to print workbooks in Excel 2013.

    03:474,023 views

Formulas and Functions

• 13

  Simple Formulas

  

  • Introduction

  • Challenge!

  

  • Simple Formulas

    Learn how to create simple formulas in Excel.

    03:1311,401 views
• 14

  Complex Formulas

  

  • Introduction

  • Challenge!

  

  • Complex Formulas

    Learn to use the order of operations to create complex formulas.

    05:106,152 views
• 15

  Relative and Absolute Cell References

  

  • Introduction

  • Absolute references

  • Using cell references with multiple worksheets

  • Challenge!

  

  • Cell References

    Explore absolute and relative cell references, and the way they can affect formulas.

    05:267,595 views
• 16

  Functions

  

  • Introduction

  • Creating a function

  • The Function Library

  • The Insert Function command

  • Challenge!

  

  • Functions

    An introduction to functions, including AUTOSUM, the Function Library, and more.

    05:177,680 views

Working with Data

• 17

  Freezing Panes and View Options

  

  • Introduction

  • Other view options

  • Challenge!

  

  • Freezing Panes and View Options

    Explore options that can make your data easier to read, including the Freeze Panes feature.

    04:282,867 views
• 18

  Sorting Data

  

  • Introduction

  • Custom sorting

  • Sorting levels

  • Challenge!

  

  • Sorting Data

    Organize your data by sorting it alphabetically, numerically, or by other criteria.

    05:504,089 views
• 19

  Filtering Data

  

  • Introduction

  • Advanced filtering

  • Challenge!

  

  • Filtering Data

    How to narrow down your data by adding one or more filters.

    04:372,615 views
• 20

  Groups and Subtotals

  

  • Introduction

  • Creating subtotals

  • Challenge!

  

  • Groups and Subtotals

    Learn how to create subtotals and group columns or rows for easy viewing.

    03:527,106 views
• 21

  Tables

  

  • Introduction

  • Modifying tables

  • Challenge!

  

  • Tables

    Find out how to insert and customize tables to organize your information.

    04:598,779 views
• 22

  Charts

  

  • Introduction

  • Chart layout and style

  • Other chart options

  • Challenge!

  

  • Charts

    Learn how to visualize your data using Excel's wide selection of charts.

    04:503,314 views
• 23

  Sparklines

  

  • Introduction

  • Modifying sparklines

  • Changing the display range

  • Challenge!

  

  • Sparklines

    More ways to visualize your data using miniature charts that appear inside cells.

    04:542,435 views

Doing More with Excel

• 24

  Track Changes and Comments

  

  • Introduction

  • Reviewing changes

  • Comments

  • Challenge!

  

  • Track Changes and Comments

    Get to know Excel's reviewing features, including Track Changes and Comments.

    05:322,631 views
• 25

  Finalizing and Protecting Workbooks

  

  • Introduction

  • Document Inspector

  • Protecting your workbook

  • Challenge!

  

  • Finalizing and Protecting Workbooks

    Ways to prep and protect workbooks before sharing them with other people.

    03:561,654 views
• 26

  Conditional Formatting

  

  • Introduction

  • Conditional formatting presets

  • Challenge!

  

  • Conditional Formatting

    Learn how to add automatic formatting (such as color-coding) based on the cell's value.

    03:543,367 views
• 27

  PivotTables

  

  • Introduction

  • Pivoting data

  • Filters

  • PivotCharts

  • Challenge!

  

  • PivotTables (Part 1)

    Ways to summarize your data by creating and customizing a PivotTable.

    04:362,645 views

  • PivotTables (Part 2)

    Make your PivotTables even more powerful by adding Filters, Slicers, and PivotCharts.

    03:291,972 views
• 28

  What-If Analysis

  

  • Introduction

  • Other types of what-If analysis

  • Challenge!

  

  • What-If Analysis

    Learn to experiment and answer questions with your data, even when it's incomplete.

    03:295,154 views

Extras

• Excel 2013: Customizing the Ribbon

• Excel 2013: Enabling Touch Mode

• What are Reference Styles?

• More Resources

• Quiz

Learn More

• Excel Formulas

• Excel 2010

• Google Sheets

• OneDrive and Office Online