Data Analysis - Excel 365 – Power Query, Power Pivot, Dashboard Production and beyond
Excel 365 has heralded an explosion in the tools available for reporting and analysis in accounting. This course will introduce two of the most powerful Excel tools - Power Query and Power Pivot and then use those techniques (with standard Excel skills) to produce an Excel Dashboard. We will examine Excel tools for ‘What if’ and newer techniques in the very important data analysis areas of LOOKUP (especially XLOOKUP) and FILTERING. The course will complete using the Excel Dashboard we created to communicate the results via exchanges between Excel and PowerPoint.
1 days
€375.00
Online
08/10/2024