Introduction to Microsoft Excel 2016 (Online Course)

If you work with numbers, you need to master Microsoft Excel 2016! This hands-on course will teach you dozens of shortcuts and tricks for setting up fully-formatted worksheets quickly and efficiently. You will also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.

In addition, you will get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. You will also learn Excel 2016 features, including Quick Analysis, Flash Fill, and new charting capabilities.

This is not a tutorial, but an in-depth class developed by experienced Microsoft Excel instructor. By the time you’re done, you will be using this vital Office 2016 application like a pro.

Lesson 1

Understand Excel terminology, become comfortable with Excel navigation, and be able to distinguish between constant values and formulas in Excel.

Lesson 2

Gain experience with the process of creating worksheets.

Lesson 3

Explore some of Excel’s formatting, analysis, and data-entry tools to save time and increase efficiency.

Lesson 4

Understand the difference between relative, absolute, mixed, and circular references in Excel formulas.

Lesson 5

Learn to create formulas that refer to cells on other tabs in a three-dimensional worksheet.

Lesson 6

Discover how to create an Excel table in order to sort, subtotal, and filter information.

Lesson 7

Understand how to create visual representations of data with Excel Charts.

Lesson 8

Implement custom formatting options for your Excel charts.

Lesson 9

Calculate averages, standard deviations, and other statistical measures with Excel’s Function Wizard.

Lesson 10

Be able to use financial functions to calculate the future value of an investment, the monthly payment on a loan, and perform loan amortization.

Lesson 11

Learn to create your own shortcuts for redundant or time-consuming tasks with Excel macros.

Lesson 12

Use logical functions to add simple decision-making capabilities to your worksheets.

Hardware Requirements:

• This course must be taken on a PC. It is not suitable for Mac users.

Software Requirements:

• Windows 8 or newer.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Office Home and Student 2016 or Microsoft Office 365 (not included in enrollment).
• Note that the “Starter Version” and “Web App” versions of Microsoft Excel will not work with the full version of Excel taught in this course.
• Adobe Acrobat Reader. Click here to download the Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:

• Email capabilities and access to a personal email account.

There are no prerequisites to take this course.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Course Hours: 24.00