Excel Business and Financial Modeling Powerpivots
ADVANCED EXCEL COURSE This course is tailored for those who perform intensive data analysis which incorporates data from other systems, for example, external sources like SAP, Sage among others. This may include consolidating corporate budgets and forecasts from various departments, cash flow management, tracking invoices, and management reporting among others which require flexible knowledge and use of various Advanced Excel Functions and Features. WHY THIS ADVANCED EXCEL COURSE? Advanced Excel plays a very important role in structuring & presenting data so that it looks impressive. Once one has a good understanding of Excel features like tables, cell styles, and formatting options, then it is necessary to make awesome Excel workbooks. The role of this course is to teach participants the various formulas used in Excel, how to debug them, audit them and how to use which formula for which occasion (and also know few alternatives for any given formula problem).