Advanced Spreadsheet Modeling

Catalog description

The goal of this hands-on course is to develop further proficiency with Microsoft Excel with emphasis on the following main components. Accessing, managing, and analyzing data with power query, power pivot, data model, hierarchies, advanced charting, regression and forecasting. Designing malleable pivot tables using sorting, grouping, conditional formatting, calculated fields, etc. Developing excel applications using WordArt, macros, and visual basic. Ensuring authenticity of data using data validation, protecting (as needed) the workbook content.