Excel 2016 Tutorial

Description

Microsoft Excel 2016 is the spreadsheet application in the MS Office 2016 suite. Get help organizing and calculating data in this Excel 2016 tutorial.

Excel 2016 Basics 1 Getting Started with Excel 2 Understanding OneDrive 3 Creating and Opening Workbooks 4 Saving and Sharing Workbooks Working with Cells and Sheets 5 Cell Basics 6 Modifying Columns, Rows, and Cells 7 Formatting Cells 8 Understanding Number Formats 9 Working with Multiple Worksheets 10 Using Find & Replace 11 Checking Spelling 12 Page Layout and Printing Formulas and Functions 13 Intro to Formulas 14 Creating More Complex Formulas 15 Relative and Absolute Cell References 16 Functions Working with Data 17 Basic Tips for Working with Data 18 Freezing Panes and View Options 19 Sorting Data 20 Filtering Data 21 Groups and Subtotals 22 Tables 23 Charts 24 Conditional Formatting Doing More with Excel 25 Track Changes and Comments 26 Inspecting and Protecting Workbooks 27 Intro to PivotTables 28 Doing More with PivotTables 29 What-if Analysis



More Ways to Learn Microsoft Excel

Excel 2016 Bible

7th - College | Book, ebook/Kindle

The complete guide to Excel 2016, from Mr. Spreadsheet himself. Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel...

$30

Excel 2016 Essential Training

7th - College | Online class

Start mastering Excel, the world’s most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple...

$25 monthly

Excel Tutorials

College | Online resource

Excel is the most powerful tool to manage and analyze various types of Data. This tutorial covers in-depth lessons on how to use various Excel formulas, Tables and Charts for managing small to...

1
Free

The 5-Day Excel Challenge

7th - College | Online class

Take this fun and fast 5-day Excel challenge to test and build your Excel skills. The challenges are based on the questions that Excel expert Dennis Taylor encounters most often, and they grow...

$25 monthly

Analyzing and Visualizing Data with Excel

7th - College | Online class

Microsoft Excel is one of the most widely used solutions for analyzing and visualizing data. Beginning with Excel 2010, new tools were introduced to enable the analysis of more data, resulting in...

Free
Offers paid add-ons

Improve Your Microsoft Excel Skills

College | Online class

Improve Your Microsoft Excel Skills Increase the number skills you have and improve your spreadsheet expertise by expanding your use of the versatile features in Microsoft Excel. Learn how to work...

$20 monthly
Offers paid add-ons

PRDV004: Spreadsheets

College | Online class

This course will provide you with a comprehensive introduction to spreadsheets. The course is designed for first-time users with very little or no exposure to the subject. For this course, you will...

Free

Mastering Data Analysis in Excel

College | Online class

In business, data and algorithms create economic value when they reduce uncertainty about financially important outcomes. This course teaches the concepts and mathematical methods behind the most...

Free

MrExcel.com

High School - College | Online resource

A resource collection and online community dedicated to Excel since 1998, the MrExcel.com community answers 30,000 Excel-related questions per year on their message boards, and offers seminars and...

Free

Excel for Finance

College | Online class

THROUGH THIS ONLINE COURSE, YOU’LL… Benefit from expert advice, in simple language, from an accomplished financial analyst Discover which Excel functions financial experts use daily (and which ones...

$50

See all resources for Microsoft Excel