Description
Excel Power Tools – Reporting Made Easy
This course will introduce you to the Excel Power Tools – built-in functionality within Excel that’s designed to make your life easier when preparing reports in Excel. If you need to do any reporting, graphing or repetitive tasks in Excel then this is the course for you.
We will start with a basic overview of Excel tables and cover off some best practice tips for working with data in Excel. Then we will move into an introduction to Excel Power Query – the one-stop-shop for transforming your data within Excel. See how you can quickly cleanse your data with just the click of a button (split columns, replace values, calculated columns, and more).
From the Power Query, we will load our data into the Excel Data Model. If you struggle with VLOOKUPs or have slow, cumbersome Excel reports due to lots of formulae and calculations, then you don’t want to miss this module.
Along the way, we will be creating PivotTables and PivotCharts to gather insights from our data. At the end of this course, you will have the tools and knowledge to create robust, insightful, and easy to use Excel reports in a fraction of the time it takes you now.
Link to the agenda and sample videos from the course
Length: 3 Hours and 29 Minutes
Instructor
Allison Kennedy
Allison Kennedy is a Microsoft Certified Professional in BI Reporting. An analytical thinker with a passion for teaching, Allison supports business professionals and companies to work smarter, not harder. Extracting valuable insights from multiple data sources, leveraging the power of Microsoft Power Platform, optimizing the architecture for MS Teams, SharePoint, and document management systems. Allison makes connections between technology and people.
Reviews
There are no reviews yet.