While it can be initially intimidating, once you learn exactly what it is capable of, Excel can make life just that much simpler, not only within the confines of your business, but in your home as well. Undoubtedly you know some of the basics already, and have come to appreciate just how much faster and more efficient Excel can make tasks like budgeting, sorting data, and creating charts. But if you really want to shine, you need to buff up your spreadsheet knowledge and unleash the power that it offers.
There are so many great charting features and enhancements in Excel 2019, there’s no way we could cover all of them in a single lesson. So, today, we’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. We’ll walk through a few of them step-by-step, so you’ll see the value for yourself.
4 lessons
Start this course today and you will gain a solid grounding in the basics of Excel 2019, and become more confident with spreadsheets. In this free Excel tutorial, learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets. Getting access to Microsoft Office productivity apps outside of work or school can get expensive. Buying a license outright will set you back over $400, and signing up for a Microsoft 365 subscription will cost you at least $7 a month.
Learn to work with formula auditing tools including tracing precedent and dependent cells and formula evaluation. Use to understand the anatomy of Excel functions, and what their components mean. It’s a technological world out there and if you’re not at the top of your digital skillset you may be glossed over come your Microsoft Excel 2019 Lessons next job interview or promotion. Microsoft will offer extended support for this version through Oct. 14, 2025, though there is always a risk that Microsoft could terminate the license at any time. That said, we’ve been running other versions of Office from StackSocial since early 2022 and it still works just fine.
Optimizing Data
Learn how to create an effective column chart by reducing ink and ‘noise’ that distract from the main messages. Learn about adding and working with Excel’s outlining tools to quickly hide irrelevant sections of your worksheet. Learn to create and modify basic PivotTables (for quickly summarizing and highlighting data). Learn to sort data in Excel by a single column or by multiple columns.
- Jump in wherever you need answers–brisk lessons and detailed screenshots show you exactly what to do, step by step.
- This has already helped me set up my project better and gives me the confidence that I’ll be able to keep tracking the project using the software.
- After buying, your license keys and download links will be emailed and ready to install.
- Each course is normally valued at $25, but you can now get all of them at a fraction of the price.
Neither ZDNET nor the author are compensated for these independent reviews. Indeed, we follow strict guidelines that ensure our editorial content is never influenced by advertisers. Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts?
Working with Data
With over 1,000,000 learners we have achieved an average rating of 4.5 out of 5 stars. To successfully complete this course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this course, you have the option to acquire an official Diploma, which is a great way to share your achievement with the world. When you want to graph 3 line series, but only want 2 in focus most of the time. Learn to create custom conditional formatting rules based on formulas. Learn to create top/bottom and highlight cell rules, as well as to apply icon sets and data bars.
Improving your Excel skills can help you to stand out better in the job market. Finally it teaches date functions and nested functions–combining more than one function into one. You will need to download the Excel 2019 for Beginners Course Exercise Files.zip file to your PC or Mac (the file are not compatible with a mobile device) and unzip the file. In this first lesson, you’ll discover why Excel is such a powerful and user-friendly charting tool.
8 lessons
“I enjoyed the course and it was presented in an orderly fashion with incremental information that gave an intuitive feel to the progression. Thank you.” Use to restrict users ability to enter invalid data in cells by providing them with a drop down list of valid options. How to create an effective line chart through careful manipulation of chart elements to enhance its story telling ability. How to create an effective bar chart by reducing ink and noise that distract from the story.
- The course exercise and instructor demo files consist of 2 .ZIP files.
- This course will teach you the software’s often-overlooked features and functions.
- You’ll learn how quick and easy it is to group your data to give your PivotTable even more power.