Become an advanced pivot table master!
This course covers one of the most used functions in Microsoft Excel. We look at how we can use pivot tables to analyze and summarize data in different ways to gain insight using a real world retail dataset. This course starts off at a very basic level and dives deep into all the capabilities of using a pivot table on a Mac computer. All the lessons are applicable to a windows machine as well.
In each easy to follow video, you will uncover new concepts, techniques, and other powerful features of excel. You will be able to follow along each step of the way, and at the end of each module, you will use another superstore data set to analyze customer payment data.
In this course, we will cover the following:
Hi, my name is Shafiq Marediya! I am the founder of Learn Analytics, where I teach students to become professional data scientist and data analyst. Professionally, I have worked with data in industries like retail, healthcare, non-profit, finance, and technology. Over my years of studying data, I have covered topics like big data, data warehousing, data analysis with SQL, Excel, Python, and R, and visualizations with Tableau.
Many of the topics I cover in my courses are topics I learned on my own, without formal education. My courses are designed for beginners that have no prior knowledge on the topic. I clearly communicate each topic in a way that anyone can pick it up and start learning today by using the step-by-step approach I used when I was in your shoes. I am passionate about data and want to share my enthusiasm and knowledge with you!
I hope you enjoy my courses!