Details

Many businesses rely on spreadsheets to manage budgets, schedules, and tracking. Microsoft Excel is considered the industry standard for spreadsheets. If you use Excel regularly and want to learn more advanced functions in this powerful software, this course is for you.

You will learn how to harness the power of Excel's data analysis tools and AutoFilter commands and how to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other intermediate functions to your professional skill set. In addition, you will learn to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems.

Enrollment Options:

Instructor-Led
6 Weeks Access Course Code: nx9
Start Dates* Mar 13 | Apr 17 | May 15 | Jun 19
*Choose start date in cart

$129.99

USD
Self-Paced
3 Months Access Course Code: T9441
No Instructor, Start Anytime

$129.99

USD

Enroll before 28th February and get high quality lamination on your hardcopy certificate absolutely free! Use your certificate to your advantage by showing your certified credentials to prospective employers and recruiters.

Syllabus

Excel Charts and Graphs

In this first lesson, you'll discover why Excel is such a powerful and user-friendly charting tool. To you, a workbook's numbers might tell an interesting story. But to others, that story might not be quite so obvious—they might just see plain old numbers. So, in this lesson, you'll find out how to choose the right chart for telling your story and then how to create, format, and edit your chart to help others clearly visualize that story.

More Excel Charts

With so many great charting features and enhancements in Excel 2019, there's no way you could study them all in a single lesson. So, in this lesson, you'll continue exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they aren't well-known, these options can add tremendous value to your worksheets in the right situations. The lesson will walk you through a few of them step-by-step so that you can see the value for yourself.

AutoFilter and Sorting

Working with data in Excel can be quite easy—and sometimes even fun—when you know about the extra tools that are available once you have your data arranged in a table format. One of these great tools is the Auto Filter command. In this lesson, you'll learn how to use Auto Filter to limit your table information to just the records you want. Not only does Auto Filter allow for finding exact matches, but it can also filter and sort based on cell shading or font color. How great is that?

Goal Seeking

Normally, you'll use your Excel workbooks as a place to enter formulas and get answers. But what if the formula isn't returning the answer you want? If you know what you want, but you just don't know what formula will get you there, then Excel's Goal Seek is exactly what you need. This tool will help you avoid the trial-and-error approach that most Excel users go through to get to the right answer. You'll go through multiple examples, exploring several ways to apply this great feature.

Pivot Tables

You'll learn how to use one of the best features of Excel: the PivotTable. If you've heard about PivotTables before, then you'll know what to expect. There's no greater what-if analysis tool to summarize, reorganize, and report data. When you practice creating a PivotTable, you'll discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective. This is a lesson you won't want to miss!

Advanced PivotTables

Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. So, in this lesson, you'll take PivotTables to the next level by taking a tour through some of Excel's more advanced techniques. You'll learn how quick and easy it is to group your data to give your PivotTable even more power. Then, you'll find out how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart. Last, you'll become an expert in using the Excel PivotTable filtering tool called Slicer.

Solver

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'll learn how to use Solver to solve a complex problem based on the criteria and constraints you provide it. If you liked the Goal Seek lesson, then this Solver lesson is going to knock your socks off.

Sparklines

There's nothing more exciting than learning how to master a useful and eye-catching feature in Excel. In this lesson, you'll explore in detail how to create all three types of Sparklines, as well as formatting options for each. By the end of the lesson, you'll have the skills to create dashboard-like mini charts sure to make you the envy of your office. If you enjoy creating charts, you'll really enjoy this lesson.

Macros

This topic is a student favorite. In this lesson, you'll find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Tired of doing the same formatting on the same report month after month? Here's your chance to see how to record a macro that performs that time-consuming task in seconds with just one swift click of a button! How will you spend all the extra time that this lesson will save you?

Introduction to Functions

If you've used Excel for a while, you know there are hundreds of functions at your disposal. You'll spend the last three lessons of this course going over exactly how and why you'd use them. The lesson will begin by going through a quick overview of all the categories of functions and the different methods you can use to create them. Then, later in the lesson, you'll ease into creating various functions using some from the Text category.

Math/Trig Functions

In addition to learning how to create macros, most students want to learn as much as they can about Excel functions. In this lesson, you'll dig a little deeper into using some of the slightly more complex functions in the Math & Trig category. Specifically, you'll look at two popular choices, the SUMIF and COUNTIF functions, and discuss how to use one of the more complex functions, SUMIFS. If one of your objectives in taking this course is to learn more about functions, you're in for a treat!

VLOOKUP, INDEX, and MATCH Functions

Since functions are such an important and integral part of using Excel, you'll spend the final lesson going over a few more of them. You'll learn how to use the extremely popular VLOOKUP function. If you're already accustomed to using VLOOKUP, don't feel short-changed, because this lesson will add to the complexity. You'll also use the INDEX and MATCH functions to do something just short of amazing. This is another lesson you won't want to miss!

Requirements

Hardware Requirements:

  • This course can be taken on either a PC or Mac.

Software Requirements:

  • PC: Windows 8 or newer.
  • Mac: OS X Snow Leopard 10.6 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.

Other:

  • Email capabilities and access to a personal email account.

Prerequisites

There are no prerequisites to take this course.

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

Earning a Microsoft Excel 2019 certification could be the best decision you ever made for your career!


According to ZipRecruiter, the average annual pay for a Microsoft Excel specialist is $49,303. Having a Microsoft Excel certificate greatly enhances your chances to get a highly paid job, as most industries and businesses depend on Excel. You can work with MNC’s or Government bodies as Excel skills are hugely valuable and are required in a vast range of industries and occupations.

Building spreadsheets that consolidate data and make sense of numbers will improve your ability to adapt and analyze, making you more likely to get hired in better paying positions, or if you already have a job, put you in line for promotions. You will have everything you need to successfully advance your career and you will do it all online in lessons led by an expert instructor who will provide one-on-one interaction by answering questions and providing feedback on your performance. Join the ranks of hundreds of individuals who have successfully completed the ExpertRating Microsoft Excel 2019 Certification.

About ExpertRating

ExpertRating is an ISO 9001:2015 certified company offering online certification and training services to individuals and companies globally. Over 25 million people have benefited from ExpertRating Online Certifications and assessments. ExpertRating is the winner of the Google SME Hero's award for showing outstanding use of technology in delivering trusted services to thousands of people on a daily basis. Our affordable certifications are an excellent way of demonstrating your knowledge and skills to prospective employers as well as vastly boosting your chances of moving ahead in your business or career.

Company Timeline

Since 2001

Decades of excellence

800+ Skill Tests

World’s largest test inventory

2500+ Companies

Thousands depend on use

25 Million People Tested

10 tests every minute

35 Countries Serviced

Over 1500 clients in the US

86% Reorder Rate

Satisfied clients

We deliver over 3 million online certification tests and online courses annually.

Awards

ExpertRating is a winner of the Google SME Heroes award. This award has been instituted by Google to honor IT companies that have excelled in their domain and have leveraged the internet to grow and expand their businesses in innovative ways.


ExpertRating is an ISO 9001:2015 certified company, which reflects that our courses and tests conform to the highest international quality standards. Our training material is prepared by thorough professionals with years of experience, and goes through several rounds of analysis by expert teams to help develop well-balanced, comprehensive and meaningful content.


Your fee includes worldwide airmail delivery of the hard copy Microsoft Excel 2019 certificate and can be used to prove your certified status and does not mention the word "online". Also receive an online transcript that mentions your score and which you can use to prove your certified credentials on the internet at any time. Plus you get the in-depth Microsoft 2019 Courseware including practice exercises and examples.