| Data Analysis - Excel 365 – Dynamic Array Formulas (a game changer), Pivot Table Techniques, Macros and beyond |
Excel 365 has heralded an explosion in the tools available for reporting and analysis in accounting. This course will provide a detailed introduction to these new tools showing what they do, how they operate and providing real world examples. Where appropriate, we will contrast how these real world issues would have been handled in ‘legacy’ (i.e. pre 365) Excel. Dynamic Array Formulas will be explored in detail, exploring their full functionality. The course will also present useful and practical techniques to enhance skills in more familiar areas; like Charting, and Formatting, Pivot Tables and Macros.
|