From the course: Excel: Managing and Analyzing Data
Managing and analyzing data in Excel - Microsoft Excel Tutorial
From the course: Excel: Managing and Analyzing Data
Managing and analyzing data in Excel
- [Oz] You've just gotten some data. Now what? That's what this course is about, the now what. The now what is to start using Excel like a pro. In this course, you'll see assessing data quality before you dive into analysis and start generating reports. You'll see ways to flatten the report so that the data is useful. You'll see how to use pivot tables, Power Query, and the new dynamic array functions and XLOOKUP to investigate and analyze your data. Split columns, merge, reshape, and compare data sets. I'm Oz du Soleil. I've been working with Excel and data for over 20 years. I'm excited about this opportunity to show you the now what as you advance your skills with data management and analytics in Excel.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.