You don’t have to write any new assignments or figure out how to grade it. 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 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.
Simon Sez IT has been helping students master Excel for more than ten years. With a simple to follow approach and instructors that explain everything thoroughly, you can rest assured you are in safe hands. This course was recorded using Excel 2019 but is suitable for Excel 2013, 2016, and 365 users. 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.
Rate This Course & Get Better Recommendations!
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. Understand how dates work in Excel using the TODAY, YEAR, MONTH, DAY and DATE functions.
Gifted students can go as quickly as they like and will have advanced lessons to keep them challenge. Slower students can go at their own pace as well, with a teacher more free to spend time with them as needed. The solution videos included are another way of making the lessons simpler for slower students who need more scaffolding.
3 lessons
Buying a used laptop or desktop can be a smart investment for those who don’t need next-generation hardware to get a day’s work done. But outfitting that machine with the proper software can defray the benefits, especially when it comes to crucial Microsoft tools like Word and Excel. Get MS Office Pro 2019 for less than $40, along with online training for the suite.
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. 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. From Excel to photo editing, experience quality courses that ensure easy learning.
6 lessons
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. 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.
- Cindy’s passion for empowering learners shines through every lesson she teaches.
- 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.
- If you’ve used Excel for a while, you know there are hundreds of functions at your disposal.
- Learn to use VLOOKUP to find an exact match and return it or the corresponding value from another column.
- Her no-nonsense teaching approach to unraveling complex topics captivates learners, making her classes engaging and riveting.
We’re going to spend the last three lessons of this course going over exactly how and why you’d use them. We’ll start today 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, we’ll ease into creating various functions using some from the Text category. Microsoft Excel 2019 Lessons Normally, you’ll use your Excel workbooks as a place to enter formulas and get answers. 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.