Intermediate Microsoft Excel 2016

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 a 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.

Instructor-Moderated: Students enrolled in a six-week online class benefit from a one-time, 10-day extension for each course. No further extensions can be provided beyond these 10 days.​

Self-Guided: Because this course is self-guided, no extensions will be granted after the start of your enrollment.

Microsoft Excel is software that allows you to organize data and create spreadsheets. You can also use the program to perform calculations using formulas, create charts and graphs to present information, and forecast future events based on past trends. Microsoft Excel provides a tool that can be used to quickly and accurately present data in a professional way - adding value by helping others understand pertinent information. You can use it in your workplace, but also at home as a personal tool to keep track of finances, estimate loan payments, and other things.

Microsoft is more than just an important spreadsheet tool for organizing data into columns and rows. There are many reasons that businesses worldwide trust this software, but there are a few you might not know about. It allows professionals to display data easily and visually using charts and graphs to add emphasis in reports and marketing material. It helps users find trends in their data to help demonstrate key points and even provides future predictions based upon past trends. Microsoft Excel can be used as a single storage tool bringing data together from various files and documents. And, Microsoft Excel can be accessed online giving business professionals the ability to review files from multiple devices wherever they are located.

There are many professions that require the skill of effectively using Microsoft Excel including:

• Financial Analysts
• Sales Manager
• Accountants
• Auditors
• Administrative Assistants
• Product Development Professionals
• Lead Generators
• Market Analyst
• Cost Estimator
• Educators
• Project Managers
• And more

Yes, professionals who understand how to effectively use Microsoft Excel to its full potential are in high demand. You'll even find hundreds, if not thousands, of remote Excel jobs which allow you to work from the comfort of your home with your newfound knowledge of this powerful software. You may even be rewarded with higher pay once you obtain knowledge of some of Microsoft Excel's lesser known, but powerful tools.

Microsoft Excel is used by businesses worldwide in virtually every industry. It is used for a variety of business tasks including tracking data in spreadsheets, work scheduling, basic accounting, tracking sales, calculating ROI, storing customer data, and more. You'll find Excel used in Education, Technology, Manufacturing, Retail, Government, and almost every other industry you can imagine. It is used in small businesses and large corporations as well as every size organization in between.

Microsoft is now offering Microsoft Excel in an on-demand cloud service. This allows for closer collaboration among colleagues and supports the move toward more remote work and increased mobility. Additionally, it gives professionals with an expert knowledge of the software the ability to work like freelance software developers if they choose-developing pivot tables, programming macros, and more.

The Microsoft Office Suite is used by 1.2 billion organizations worldwide in virtually every industry. The Microsoft Office Suite has a software product designed to help every type of business run more efficiently and professionally. Programs in addition to Microsoft Excel include Word, Outlook, Access, and PowerPoint.