[Free] Formulas And Operations On Excel Data Part 2/3
The course is a great preparation for further deepening the knowledge on creating reports in Excel – Free Course
What you’ll 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’m the author of this course that can be found on udemy and on the Excel BI Academy .com platform. As the founder of Excel BI Academy .com Ive 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.
Your next steps can be taken with my POWER course: Power Query, Power Pivot, Data Viz & Power BI – 4in1 POWER at udemy or at my platform Excel BI Academy.
Best regards
Bartosz Czapiewski
Excel BI Academy
Author(s): Bartosz Czapiewski
FREE
0
