Microsoft Excel 2019 Step by Step

I have always used Excel at work, but because I learned to use it on my own, I had never been able to make use of all the possibilities that the software offers. Join our community of 30 million+ learners, upskill with CPD UK accredited courses, explore career development tools and psychometrics – all for free. Microsoft Excel remains the go-to spreadsheet software for millions of people around the world. If you’ve been meaning to learn Excel for years but haven’t quite got around to it, or if you use Excel every day but feel lost when you log in, then this course is for you. Learn to work with the Format Cells dialog to apply text rotation and borders, and to center data across multiple cells. Simply click it and you will be taken to a page where you can give a quick rating and leave a short comment for the product.

Lessons are all inclusive, self-directed and include step by step videos–perfect for teaching live, blended, or strictly online. Introducing Cindy McGuckin, the illustrious IT trainer with over two decades of expertise, poised to lead you on a transformative learning journey. Cindy’s passion for empowering Microsoft Excel 2019 Lessons learners shines through every lesson she teaches. With mastery in Microsoft Office and QuickBooks, Cindy’s online courses have garnered hundreds of 5-star reviews. Her no-nonsense teaching approach to unraveling complex topics captivates learners, making her classes engaging and riveting.

Ready to watch the complete course?

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.

• Simon Sez IT has been helping students master Excel for more than ten years.
• We gather data from the best available sources, including vendor and retailer listings as well as other relevant and independent reviews sites.
• And peruse our gift guide, which includes a full range of ideas for birthdays, anniversaries and more.
• Pivot tables and pivot charts are covered in detail, as well as advanced graphs, including funnel, waterfall, sunburst, box & whisker, and maps.

ZDNET’s recommendations are based on many hours of testing, research, and comparison shopping. We gather data from the best available sources, including vendor and retailer listings as well as other relevant and independent reviews sites. And we pore over customer reviews to find out what matters to real people who already own and use the products and services we’re assessing.

COURSE: Microsoft Excel 2019 Certification Training

Lesson 6 – This lesson covers sparklines, pareto charts, and subtotals, and also provides an overall review of the most common features on the MOS test. They will learn some of the file features as well like customizing quick access bar and ribbons, show formulas, etc, and review graphing. There’s nothing more exciting than learning how to master a useful and eye-catching feature in Excel.

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

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.

Appending tables is the process of stacking them vertically to create long tables that can be used to feed business intelligence solutions and PivotTables. Learn to record basic Excel macros to automate your actions (instead of doing them manually). Learn to use VLOOKUP to find an exact match and return it or the corresponding value from another column. Learn to use VLOOKUP to find an approximate match and return it or the corresponding value from another column. Learn to work with the EOMONTH and EDATE functions that easily shift dates from one month or year to another. Learn to use SUMIF and COUNTIF to add cells only when certain conditions are met.

In This Free Course, You Will Learn How To

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.

In this lesson, you’ll learn how to use Solver to solve a complex problem based on the criteria and constraints we provide it. If you liked the Goal Seek lesson, then this Solver lesson is going to knock your socks off. Enrolling in Simon Sez IT’s Microsoft Project for beginner course really helped me become proficient with Microsoft Project and project management. 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.