Microsoft Excel - Data Analytics Power Query and PivotTables
What you'll learn
- Create Connections and Discover External Data Sources
- Clean, Transform and Prepare Data Sets for Reporting within Excel
- Transform Raw Data with Power Query Calculations
- Create Consistentcy in Data with Power Querys Powerful Toolset
- Streamline Data Work by Automating with Power Query Steps
- Create Clean Data Interfaces with Power Query Parameters and Excel Variables
Requirements
- Microsoft Excel 2016 or newer to follow along
- Power Query is not Available in the MAC release of Excel
- Power Query is available through a free download for Excel 2010 and 2013. Best if you have Excel 2016 or newer.
Description
Microsoft Excel's Power Query tool is the biggest feature Microsoft has added to Excel since PivotTables. Seriously, no joke. Read on to learn more about Excel Power Query and how you'll save loads of time as you take advantage of this powerful feature.
In Excel 2016, 2019 and Office 365, Power Query is built directly in the Excel interface through the GET AND TRANSFORM command on the Data tab. (Power Query is NOT available on the MAC release of Excel)
Power Query is available on Excel 2010 and 2013 through a free download from Microsoft as described in the course.
Lets face it, retrieving, cleaning and transforming data to report on can take hours of precious time. With Excel Power Query you can eliminate repetitive tasks freeing your time for other important tasks, like lunch and going home on time. Excel Power Query removes the hassle and complex formulas of manual tasks such as:
Finding the Data each time you need a report
Cleaning Columns of Data
Splitting or Joining Column Values
Removing unnecessary characters and extra spaces
Formatting data correctly
Filtering data needed for the report
Combining multiple Datasets into a master list
Manipulating the data layout to work with other tools, i.e. Excel PivotTables and Charts
In just 3 easy steps, you'll have a final report ready for presentation and your next raise.
Get Data
Transform/Clean Data
Report on Data
Once you've got it all setup with Excel Power Query all you need to do is hit the Refresh button to update the report with next weeks data. Microsoft Power Query remembers all the steps you performed to get, transform and clean the data all you do is refresh and your report is updated.
Sounds all too easy, right? Enroll now and let me guide you through Excel Power Query and you'll quickly be on your way to harnessing the power of managing and reporting on data with Excel Power Query.
This Excel Power Query Course Includes:
6+ hours of video content
Downloadable exercise files to follow along
Access to the instructor through the QA section
Who this course is for:
- Microsoft Excel users looking to speed up their time managing and reporting on data
- Microsoft Excel users looking to learn the hottest tool in Excel since PivotTables were introduced
Featured review
Instructors
Welcome! I'm Kyle Pew, a Microsoft Certified Trainer (MCT), Microsoft Office Master Instructor, and Udemy Instructor Partner, with over 20 years of experience training over 2 million students in Microsoft Office and beyond. I’m passionate about helping students of all backgrounds and skill levels succeed in using tools like Excel, Word, PowerPoint, Access, and more, as well as diving into advanced topics like VBA and SharePoint.
With a background in media arts and animation from the San Francisco Art Institute and industry experience as a game designer at Electronic Arts, I bring a unique perspective to my training. My clients have included major corporations like Chevron, Facebook, Walmart, and many more, delivering training to both large-scale audiences and individuals, adapting each lesson to address real-world applications. My courses are built around the principle that the best way to learn is by tackling real-life challenges—allowing you to build confidence and problem-solving skills.
Join me on Udemy and let’s take your skills to the next level. When I’m not teaching, I’m enjoying time with my six children or cheering on my favorite hockey team, the San Jose Sharks.
Here to support your progress through courses provided by Office Newb, LLC.