Excel Power Tools – Reporting Made Easy

$259.00

  • EUR: €239.13
  • GBP: £204.95
  • NZD: $431.21
  • CAD: $351.33
  • AUD: $396.31

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.

Length: 3 Hours and 29 Minutes

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.

Be the first to review “Excel Power Tools – Reporting Made Easy”

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Product Enquiry

You may also like…