Learn how to import raw data from different Excel locations into Power Query. Then use Power Query to clean and transform the data. From there, use the output data as the source for an interactive Excel dashboard. Build the dashboard with several PivotTables, PivotCharts and other interactive components. See the dynamic nature of the dashboard with changes in the original data.
Speaker Profile
Craig Brody runs Craig Brody, LLC, a software training and consulting business. Craig has trained thousands of employees, managers, executives and students in application software including Microsoft 365 and Adobe Acrobat Pro. Conducts and facilitates in person and online training workshops for professionals in the fields of Accounting, Business, and Law. Conducts workshops, classes and consulting services for the University of Pennsylvania’s Wharton Business School and Penn Carey Law School. Provides clients with spreadsheet analysis and design, software programming, consulting services and course curriculum including videos, reference guides and related materials
Instructor
Craig Brody