Intermediate Microsoft Excel 2016 (Self-Paced Tutorial)

$199.99

Take your Microsoft Excel 2016 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions.

secure

Course Details

In this hands-on course, you will learn how to create informative, eye-catching charts and graphs, and harness the power of Excel’s data analysis tools and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire.

Objectives

Lesson 1

Learn to create the right chart for the right job.

Lesson 2

Get to know some of the more obscure chart types.

Lesson 3

Learn to use AutoFilter commands and color sorting.

Lesson 4

Discover why Goal Seek eliminates formula guesswork.

Lesson 5

Find out how to use the Excel PivotTable to create a quick, easy-to-read summary of data in an otherwise unwieldy spreadsheet.

Lesson 6

Become proficient at using the PivotTable to filter, group, and chart data.

Lesson 7

Find out how Excel’s Solver tool can help you determine the optimal conditions for meeting a target.

Lesson 8

Use the Sparklines tool to draw attention to trends in your data.

Lesson 9

Understand how macros can help you work more efficiently by automating tasks you find time-consuming or repetitive.

Lesson 10

Learn how to use Excel’s text functions to trim, concatenate, or convert text from one form to another.

Lesson 11

Use Excel’s SUMIF, SUMIFS and COUNTIF functions to sum or count values that meet a desired condition.

Lesson 12

Discover how Excel’s VLOOKUP function can help you extract the values you need from a table, and learn about the INDEX and MATCH functions.

Requirements

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.

Prerequisites

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 Information

Course Hours: 24.00

How It Works

1

Take the online course at your convenience.

2

Fully complete the course to access your certificate.

Student Reviews

There are no contributions yet.

×
  • Your personal data will be used to support your experience throughout this website, to manage access to your account, and for other purposes described in our privacy policy.

Continue as a Guest

Don't have an account? Sign Up