EXCEL – DATA ANALYTICS Level - Advanced
EXCEL – ADVANCED FUNCTIONS Level - Advanced This course concentrates on Microsoft Excel’s advanced functions that will allow you to work more efficiently with business data. Why attend? • Build well-structured, complex formulas to work more efficiently with data • Explore Logical, Lookup, Reference and Statistical functions and how they are used • Understand how to use Date functions to calculate date data • Understand how to use Text functions to clean up and manipulate text data imported from external databases • Build complex formulas with nested functions • Introduction to array formulas • Use formula auditing tools to troubleshoot errors in formulas. Course details: 2 days 9.00am – 4.30pm EXCEL – MACROS WITH VBA PROGRAMMING Level - Advanced This course will introduce and extend Visual Basic for Applications (VBA) programming within Microsoft Excel to enable you to create and manage complicated macros. Why attend? • Gain an understanding of the Visual Basic Editor (VBE) • Create and edit macros by writing VBA code in the VBE • Understand concepts of object oriented programming • Build user-defined functions in Excel • Learn how to resolve errors • Use events to trigger VBA procedures. Course details: 2 days 9.00am – 4.30pm
This course outlines analytic tools of Microsoft Excel which can be very useful for business planning and modelling. Why attend? • Understand the different types of analytics techniques • Use advanced sorting for descriptive analysis • Use advanced conditional formatting for descriptive analysis • Work with advanced analytic functions such as SUMPRODUCT and analytic database functions such as DSUM and DAVERAGE • Learn how to use What-If Analysis tools: - Goal Seek to calculate a single value needed to achieve a known outcome - Scenario Manager to switch between different calculations with different variables - Data Tables to view multiple results from one or two variables - Solver to calculate multiple values needed to achieve a known outcome • Gain an understanding of the Excel Analysis ToolPak. Course details: 1 day 9.00am – 4.30pm EXCEL – PIVOTTABLES AND PIVOTCHARTS Level - Advanced This course concentrates on creating PivotTables and PivotCharts to present business data for analysis. It also focuses on how best to manage the underpinning business data using List Management techniques. Why attend? • Set up the data to be analysed using Tables • Create PivotTables and PivotCharts • Learn to group items and filter data • Build formulas to better analyse the business data • Format PivotCharts. Course details: 1 day 9.00am – 4.30pm
93
Powered by FlippingBook