Welcome to next-gen Illumeo platform. All individual and corporate users are required to reset their account passwords before accessing the new platform. Click login and then 'Lost my Password' and follow the simple process. For any assistance, please email us at support@illumeo.com

Contact Info

  • 96 Queen Park, Los Vegas, USA
  • +1 800 555 44 00
  • mail@illumeo.com
  • Office Hrs: Today 9.00am to 6.00pm

Excel Power Query: Create an Automated Business Dashboard

$36.00

SKU: crs-1658669 Category:

Description

Learn how to explore and analyze your data by creating an automated business dashboard in Excel using pivot tables, Power Query, and a little Visual Basic. Using these lessons, you can create a dynamic, automated template to generate reports and gain insights from your data. Along the way you’ll learn how to import and transform external data using using Power Query, design dashboards using Pivot Tables, and add macros and buttons to make the template interactive.

We’re going to leverage new functionality in Excel in order to automate data extraction and data cleansing and thus concentrate on turning our data into insights and insights into actions. Let’s get started.

LOGIN