Intermediate Microsoft Excel 2016

Intermediate Microsoft Excel 2016

Harness the power of Excel and become a master user of this powerful program. This hands-on course will provide skills using charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2016 functions.
6 weeks / 24 Course Hrs
SHARE
  • Details
  • Syllabus
  • Requirements
  • Instructor
  • Reviews

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.

Enrollment Options:
Instructor-Led
6 weeks Access Course Code: nx6
Start Dates*Oct 16 | Nov 13 | Dec 11 | Jan 15
*Choose start date in cart
$129.00
Self-Paced
3 Months Access Course Code: T8499
No Instructor, Start Anytime
$129.00

Syllabus

In your first lesson, you will discover why Excel 2016 is such a powerful charting tool. To you, a workbook's numbers might tell an interesting story; to others, that story may not be obvious. You will learn how to choose the right chart for your story and then how to create, format, and edit your chart.

This lesson continues exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they may not be well-known, these options can add tremendous value to your worksheets in the right situations.

Working with data in Excel can be quite easy when you know about the tools that are available in a table format. One of these great tools is the Auto Filter command. This lesson will teach you how to use Auto Filter to limit your table information to just the records you want.

Learn how to use Solver to solve a complex problem based on the criteria and constraints that you provide it. You'll also explore in detail how to create all three types of Sparklines, as well as formatting options for each and gain the skills to create dashboard-like mini charts sure to make you the envy of your office.

Find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Then, receive a quick overview of all the categories of functions and the different methods you can use to create them.

Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. This lesson takes a tour through some of Excel's more advanced techniques, like the PivotTable filtering tool Slicer. You will also learn how a PivotTable can serve as your source for the PivotChart.

Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you will learn how to use Solver to solve a complex problem based on criteria and constraints.

There's nothing more exciting than learning how to master a new feature in Excel. This lesson focuses on creating three types of Sparklines, as well as formatting options for each. By the end of the lesson, you will have the skills to create dashboard-style mini charts.

In this lesson, you will find out how to use macros to turn repetitive and often time-consuming tasks into automated Excel functions. You will also learn how to record a macro that performs time-consuming task in seconds with the click of a button.

If you have used Excel for a while, you know there are hundreds of functions at your disposal. The last three lessons of this course will cover how and why you would use these functions. This lesson introduces creating various functions with the Text category.

Next to learning how to create macros, most students want to learn as much as they can about Excel functions. This lesson covers on more complex functions of the "Math & Trig" category, focusing on the SUMIF and COUNTIF functions in particular.

Since functions are such an integral part of using Excel, your final lesson will cover advanced features. In this lesson, you will learn how to use the VLOOKUP, INDEX, and MATCH functions.

Requirements

  • Adobe Flash Player. Click here to download the Flash Player.
  • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
  • Email capabilities and access to a personal email account.

Requirements:

Hardware Requirements: 

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

Software Requirements: 

  • Windows 7 or later.
  • 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 Flash Player. Click here to download the Flash Player.
  • 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.

Instructor

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

Reviews

This course was very challenging, the instructor was very encouraging and I feel I learned quite a bit. I am very happy that I enrolled in this Excel course. It will help me in the future when I start my own business.

Loved this course! It is indeed challenging and it takes practicing in Excel. Mr. Wambolt goes that extra mile, or should I say miles, to cover everything possible in his notes. His notes and quizzes are brilliant.

I enjoyed the class and being able to refer back to the course materials whenever I need to. I do learn better in a class environment, but my work schedule does not allow for it. Thanks, Chad! Well laid out and well written.

This course is organized very well and was easy to follow. Great job to the instructor. I did not need to interact with the instructor at any time.

Intermediate Microsoft Excel 2016 helped me to improve my existing Excel skills, as well as to develop new ones. I appreciated the pace of the class, as well as the assignments and quizzes which helped me gauge my compression of the subject matter. The instructor, Chad Wambolt, explained concepts in a clear and concise manner. I look forward to taking additional classes with this online instructor.