Microsoft Excel Training from GCFGlobal

Excel 2016 Basics

1.  Getting Started with Excel: Learn your way around the Excel 2016 environment.
2. Understanding OneDrive: Learn all about working with your Microsoft account and OneDrive.
3. Creating and Opening Workbooks: Learn how to create and open Excel workbooks.
4. Saving and Sharing Workbooks: Learn how to save and share Excel workbooks.

Working with Cells and Sheets

5. Cell Basics: 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.
6.  Modifying Columns, Rows, and Cells: Learn how to modify rows, columns, and cells in Excel.
7.  Formatting Cells: Learn all about formatting text in Excel.
8.  Understanding Number Formats: Learn all about formatting numbers in Excel.
9.  Working with Multiple Worksheets: Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets.
10.  Using Find & Replace: Learn how to use Excel's Find and Replace features to search for specific data.
11.  Checking Spelling: Learn how to use Excel's spell check feature.
12.  Page Layout and Printing: Learn how to use Excel commands that let you control the way your content will appear on a printed page.

Formulas and Functions

13.  Intro to Formulas: Learn how to use cell references to create a simple formula in Excel.
14.  Creating More Complex Formulas: Learn how to create a complex formula in Excel.
15.  Relative and Absolute Cell References: Learn all about absolute and relative cell references and how they're used in Excel.
16.  Functions: Learn the different parts of a function and how to create arguments to calculate values and cell references.

Working with Data

17.  Basic Tips for Working with Data: Learn these basic tips for working with data to help you organize it and find what you need.
18.  Freezing Panes and View Options: Learn how to freeze panes and split your worksheet so you're only seeing certain parts of your worksheet.
19.  Sorting Data: Learn how to sort data to better view and organize the contents of your spreadsheet.
20.  Filtering Data: Learn how to filter the data in your worksheet to display only the information you need.
21.  Groups and Subtotals: Learn how to organize data in groups, summarize different groups using the Subtotal command, and create an outline for your worksheet.
22.  Tables: Learn how to use styles to format tables in Excel.
23.  Charts: Learn how to insert and modify Excel charts to visualize comparisons in your data.
24.  Conditional Formatting: Learn how to apply, modify, and delete conditional formatting rules in Excel.

Doing More with Excel

25.  Track Changes and Comments: Learn how to use Excel's track changes and comments features when proofreading workbooks.
26.  Inspecting and Protecting Workbooks: Learn how to inspect and protect your Excel workbook.
27.  Intro to PivotTables: Learn how to use PivotTables in Excel for stronger data analysis.
28.  Doing More with PivotTables: Learn how to do more with PivotTables in Excel to better summarize data.
29.  What-if Analysis: Learn how to use what-if analysis to answer different types of questions.

Extras

30.  Buying Office 2016: If you're considering purchasing Office 2016, learn about some important changes you should know about.
31.  New Features in Office 2016: Discover some of the new features in Office 2016.
32.  What are Reference Styles?: Learn all about using reference styles in Excel.
33.  More Resources: These free resources can help you better work with and manipulate data in Excel.