Excel 2013

Office Basics

• 1

  Buying Office 2013 arrow_forward_ios ✓ If you're thinking about buying Office 2013, there are a few things you should consider before your purchase.
• 2

  Working with Your Microsoft Account and OneDrive arrow_forward_ios ✓ Learn all about working with your Microsoft account and OneDrive.
• 3

  Understanding Office 365 arrow_forward_ios ✓ Learn what you need to know about Office 365, a subscription-based version of Office 2013.

Excel Basics

• 4

  Getting Started with Excel arrow_forward_ios ✓ Learn your way around the Excel 2013 environment.
• 5

  Creating and Opening Workbooks arrow_forward_ios ✓ Learn how to create and open Excel workbooks.
• 6

  Saving and Sharing Workbooks arrow_forward_ios ✓ Learn how to save and share Excel workbooks.
• 7

  Cell Basics arrow_forward_ios ✓ Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use the cut, copy, and paste functions.
• 8

  Modifying Columns, Rows, and Cells arrow_forward_ios ✓ Learn how to modify rows, columns, and cells in Excel.
• 9

  Formatting Cells arrow_forward_ios ✓ Learn all about formatting text in Excel.
• 10

  Worksheet Basics arrow_forward_ios ✓ Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets and freeze rows and columns.
• 11

  Page Layout arrow_forward_ios ✓ Learn how to use Excel commands that let you control the way your content will appear on a printed page.
• 12

  Printing Workbooks arrow_forward_ios ✓ Learn how to preview your spreadsheet, modify margins, change page orientation, and print.

Formulas and Functions

• 13

  Simple Formulas arrow_forward_ios ✓ Learn how to create a simple formula in Excel.
• 14

  Complex Formulas arrow_forward_ios ✓ Learn how to create a complex formula in Excel.
• 15

  Relative and Absolute Cell References arrow_forward_ios ✓ Learn all about absolute and relative cell references and how they're used in Excel.
• 16

  Functions arrow_forward_ios ✓ Learn the different parts of a function and how to create arguments to calculate values and cell references.

Working with Data

• 17

  Freezing Panes and View Options arrow_forward_ios ✓ Learn how to freeze panes and split your worksheet so you're only seeing certain parts of it.
• 18

  Sorting Data arrow_forward_ios ✓ Learn how to sort data to better view and organize the contents of your spreadsheet.
• 19

  Filtering Data arrow_forward_ios ✓ Learn how to filter the data in your worksheet to display only the information you need.
• 20

  Groups and Subtotals arrow_forward_ios ✓ Learn how to organize data into groups, summarize different groups using the Subtotal command, and create an outline for your worksheet.
• 21

  Tables arrow_forward_ios ✓ Learn how to use styles to format tables in Excel.
• 22

  Charts arrow_forward_ios ✓ Learn how to insert and modify Excel charts to visualize comparisons in your data.
• 23

  Sparklines arrow_forward_ios ✓ Learn how to insert sparklines and change their type and appearance.

Doing More with Excel

• 24

  Track Changes and Comments arrow_forward_ios ✓ Learn how to use Excel's track changes and comments features when proofreading workbooks.
• 25

  Finalizing and Protecting Workbooks arrow_forward_ios ✓ Learn how to finalize and protect your Excel workbook.
• 26

  Conditional Formatting arrow_forward_ios ✓ Learn how to apply, modify, and delete conditional formatting rules in Excel.
• 27

  PivotTables arrow_forward_ios ✓ Learn how to use PivotTables in Excel for stronger data analysis.
• 28

  What-If Analysis arrow_forward_ios ✓ Learn how to use what-if analysis to answer different types of questions.

Extras

• 29

  Excel 2013: Customizing the Ribbon arrow_forward_ios ✓ Learn how to customize the Ribbon in Excel 2013.
• 30

  Excel 2013: Enabling Touch Mode arrow_forward_ios ✓ Learn all about enabling Touch Mode in Excel 2013.
• 31

  What are Reference Styles? arrow_forward_ios ✓ Learn all about using reference styles in Excel.
• 32

  4 Free Alternatives to Microsoft Office arrow_forward_ios ✓ Learn more about free alternatives to using Microsoft Office, including Google Docs, Office Online, OpenOffice, and LibreOffice.
• 33

  More Resources arrow_forward_ios ✓ These free resources can help you better work with and manipulate data in Excel.

Quiz

• 34

  Excel Quiz arrow_forward_ios ✓ Test your knowledge of Excel by taking our quiz.