Discover the real world uses of Microsoft Excel and its impact upon business, academic, and personal applications. Move from inserting and manipulating data, to working with tables, charts, graphs, and calculations. Content of this course will also be applicable to the Microsoft Office Suite certification exam.
*Not compatible with Chromebook or Tablets
Microsoft Office Excel 2019, or an Office 365 Subscription
Syllabus:
Imagine a supercomputer. A huge, metallic box that can complete hundreds of thousands of calculations at any one time. Sounds pretty impressive right? What about a piece of software that could complete hundreds of calculations on data and update the results in real-time? Well, applications like that already exist, have for a long time actually. Odds are you’ve used some of them without knowing what they are really capable of even. One of the best pieces of software for recording, calculating, and working with data today is Microsoft Excel. It is an integral part of the business world, but it also has home applications too. Because it is so versatile and powerful, it’s helpful to understand exactly what it is and how it works. Whether you are running a major corporation with 1,000 or more employees or tracking how much money you have earned between your home allowance and your part-time wages, Excel can help you organize, manage, and budget so that you can make informed decisions when it comes to money.
What will you learn in this unit?
Unit 2: Customizing and Configuring
Now that you have a good understanding of the purpose and possibilities of Excel, it’s time to start using it. Being able to configure options and views is essential for making the most of Excel, as well as being able to sort and filter data effectively so that it’s possible to work with only relevant data. It’s also important to understand how to print effectively, as it can be a little more complicated than other Office products. And of course, you need to know how to save the end result for later. These fundamentals will add to the solid foundation that’s already been created and act as a springboard for getting the most out of Excel.
What will you learn in this unit?
Unit 3: A Range of Data
Excel can be deceptively simple—the real magic begins when you know how to handle Excel’s basic editing and formatting tools, as well as having a solid understanding of when to use them. The next step in the process is to think creatively: what can you do with the data you have, and how can you do it? That’s precisely what learning Excel is all about—realizing the possibilities by using certain tools.
What will you learn in this unit?
Unit 4: Creating and Managing Tables
Excel is all about tables, data, and, of course, numbers. While there are countless practical everyday uses for the software, there are just as many, if not more, highly specialized ones that use advanced functions. As a matter of fact, people are still finding new and better uses for Excel in handling their private and business needs—the software has evolved quite a bit since its conception.
What will you learn in this unit?
Unit 5: Fun with Formulas and Functions
So far, a lot of the essentials you’ve learned have been about entering, deleting, or presenting data. Now it’s finally time to do something with this data and to dive into one of the most versatile things Excel has to offer—functions and formulas. From simple addition to complex calculations using dozens of components and data points, the possibilities are near endless.
What will you learn in this unit?
Unit 6: Organization Essentials: Charts and Data
Data visualization is a key aspect of presenting any sort of data in a business environment. Printing out a worksheet is technically possible but won’t be easy to understand for people who may not be as familiar with Excel as you are. Think of the potential audience—who will be looking at your data, and what sort of tool can you use to help them? The simplest and often most effective answer is charts— they are a great visualization tool.
What will you learn in this unit?
Unit 7: Excel at Work
Being able to use Excel and being able to use Excel in the workplace are two very different things. While mastering Excel is an important first step, eventually you will have to adapt to being able to use Excel under pressure, in collaboration with others, and in less-than-ideal conditions such as with limited resources or time. The skills for this are ones you’ll acquire over time, but it’s always a good idea to get a head start now!
What will you learn in this unit?
Unit 8: Pulling It All Together
The basics of Excel are neither simple nor easy to learn, yet you’ve been doing a great job of it so far—all you need to do now is to put it all together to get comfortable switching at a moment’s notice between the tools you’ve learned and identifying the appropriate tools for different situations. Remind yourself of the different tools you’ve learned about, and of the many creative ways in which they can be used, and you’ll be on your way to Excel mastery in no time!
What will you learn in this unit?
