VLOOKUP, SUMIF and data operations
What You Will Learn
VLOOKUP and XLOOKUP
Most common VLOOKUP problems
SUMIF, COUNTIF and similar
Basic data operations
Requirements
-
There are no prerequisites for the course as the formulas are functionally independent.
-
I recorded the course in 2020 in Office 365, but the formulas have been working the same for years. You can easily follow the course in Excel 2007, 2010, 2013, 2016, 2019 and 365.
-
I recorded the course in 2020 and used many new formulas that allow me to work even faster. Moreover, the course will be constantly updated with what’s new in Excel.
-
You can easily follow the course in Excel 2007, 2010, 2013, 2016, 2019 and 365.
Description
Hi, my name is Bartosz and I’d like to invite you to the Excel refreshing course on formulas & data operations. As the founder of Excel BI Academy .com I’ve spent many years in the traditional Excel reporting, using formulas and pivot tables (that I describe in the separate course). I want my Academy students to be well prepared to discover Power Query, Power Pivot, Power BI and Excel dashboards. That is why I have consolidated my Excel knowledge into the courses.
This is the second part of the Excel formulas & data operations course. If you want to learn how to use VLOOKUP (and different challenges with using this function), COUNTIF, SUMIF, array formulas and many more, enroll and enjoy. I devoted many years dealing with common Excel challenges. And this course shows you many of my discoveries.
You can find there all the download files and many Do-It-Yourself exercises. At the end of this course, we also start the Excel operations topic, covering filtering and sorting. Because Excel 365 brings some new solutions, I always compare the new functions to the old ones to show you the advantages.
I hope that you will enjoy this course and we will meet at Excel BI Academy .com.
Enjoy!
Who this course is for:
- The course is aimed at both beginners and advanced users of Excel.
- The course starts with the basics, and then I discuss all the formulas in detail.
- There are no prerequisites for the course as the formulas are functionally independent.
- Intermediate and advanced people can start independent tasks right away