Introduction to Microsoft Excel 2019

No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. In this lesson, you'll learn how to build a table in Excel as well as how to subtotal, sort, and filter.

In this lesson, you'll explore the exciting world of charts. You'll build your first graph and learn how easy it is to adjust the chart type, labels, titles, colors, and other aspects of your chart.

In this lesson, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating.

Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In this lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers.

You'll continue your exploration of Excel functions with an in-depth look at Excel's handy financial functions. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.

In this lesson, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke.

You'll be intrigued by the final lesson, in which you'll learn how to use Excel to aid you in decision making. You'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

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.