Courses Courses Arts and Design Arts and Design Animation Graphic Arts Photography Web Design Business Business Accounting Administrative Communication Finance Marketing and Sales Operations Project Management Small Business Soft Skills Career Online High School Career Online High School Online High School Diploma Computer Applications Computer Applications Autodesk Microsoft QuickBooks Windows Computer Science Computer Science Programming Construction and Trades Construction and Trades Construction Environmental and Energy Trades Health and Fitness Health and Fitness Alternative Medicine Dental Fitness Medical Veterinary Wellness Hospitality Hospitality Hospitality Service Information Technology Information Technology Cloud Computing Networking Other Security Language Language Languages Legal Legal Legal Studies Math and Science Math and Science Mathematics and Science Teacher Professional Development Teacher Professional Development Child Development Classroom Technology Math and Science Reading and Writing Test Prep Test Prep Exam Prep Writing Writing Writing and Editing Skill Map Resources Resources About ed2go Externship Programs Financial Assistance Find a School Blog MyCAA

CONTACT US

(855) 520-6806

See all results for ""

See All Courses

ed2go Computer Applications Microsoft Intermediate Microsoft Excel 2019/Office 365
Return to Microsoft
intermediate-microsoft-excel-2019-office-365

Intermediate Microsoft Excel 2019/Office 365

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 to how 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.

6 Weeks / 24 Course Hrs
Currently Enrolling

Offered in Partnership with your Preferred School

Maricopa Corporate College

Why this school? It's been chosen based on your location or if you've visited this school's website. Change School

Learning Method

Instructor-led

Confirm your Start Date in Cart

Starting December 11 | January 15
Self-Paced

No instructor. Study on your own schedule

Intermediate Microsoft Excel 2019/Office 365

Details + Objectives

Course Code: nx9

What You Will Learn
  • Charting, PivotTables, Slicers, Sparklines, and other advance features of Microsoft Excel 2019
  • How to manipulate data
  • Intermediate level Excel functions
How the course is taught
  • Instructor-led or self-paced online course
  • 6 -12 weeks to complete
  • 24 course hours
How you will benefit
  • Become a more productive member of your organization
  • Build an indispensable skill set
  • Learn to fully harness the power of Microsoft Excel 2019

Outline

Expand All
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, today, 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

There are so many great charting features and enhancements in Excel 2019, there's no way you could study all of them in a single lesson. So, today, 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 today's 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, today, 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!

View All Sections

Instructors & Support

Chad Wambolt

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.

Requirements

Requirements

Requirements:

Hardware Requirements:

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

Software Requirements:

  • PC: Windows 10 or later operating systems.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • Microsoft Excel, a subscription to Office 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
  • 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:

A basic understanding of Microsoft Excel use's and functions or completion of Introduction to Microsoft Excel is required.

Fundamentals

Introduction to Microsoft Excel 2019/Office 365

with Chad Wambolt

If you work with data of any kind, knowing how a spreadsheet is key to effectively managing and organizing information. This course will introduce you to Microsoft Excel 2019 and teach you how to use this powerful software.

Course Code: IX9

  • 24 Course Hrs
Instructional Materials

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

FAQs

Expand All
When can I get started?

Instructor-Led: A new session of each course begins each month. Please refer to the session start dates for scheduling. 

Self-Paced: You can start this course at any time your schedule permits.

How does it work?

Instructor-Led: Once a session starts, two lessons will be released each week, for the 6 week duration of your course. You will have access to all previously released lessons until the course ends.

Self-Paced: You have three-month access to the course. After enrolling, you can learn and complete the course at your own pace, within the allotted access period.

 

How long do I have to complete each lesson?

Instructor-Led: The interactive discussion area for each lesson automatically closes 2 weeks after each lesson is released, so you’re encouraged to complete each lesson within two weeks of its release.

Self-Paced: There is no time limit to complete each lesson, other than completing all lessons before your three-month access.

What if I need an extension?

Instructor-Led: The Final Exam will be released on the same day as the last lesson. Once the Final Exam has been released, you will have 2 weeks plus 10 days to complete the Final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.

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

What can I do with microsoft excel?

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.

How is microsoft excel used in the workplace?

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.

What kinds of jobs use excel?

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
Are professionals who know how to use excel in demand?

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.

What types of businesses use microsoft excel?

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.

How is microsoft excel changing from older versions?

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.

What other types of Microsoft programs are used in business?

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.

Browse All