Microsoft Data Analysis Bundle

Microsoft Excel:

• How Excel works, how to navigate and design a spreadsheet
• The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF
• To use PivotTables, Pivot Charts and Basic Macros
• To create beautiful looking graphs and charts
• Formatting, including; conditional, cell and number formatting
• How to print what you want

Microsoft Excel is available in versions: 2003 PC, 2007 PC, 2010 PC, 2016 PC, 2013 PC, 2011 MAC, 2016 MAC

Microsoft VBA:

• To automate tasks and operations that you perform frequently.
• How to define and manage variables, set up subroutines, and create functions.
• How to use input boxes and message boxes to interact with end users.
• Practical methods for using macro errors to improve your VBA code.
• About the PivotTable object and basic approaches to utilizing it.
• What variables are, and how they relate to functions versus methods and subroutines.
• To create cross-functional flowcharts

Microsoft Access:

• How to set-up a database—on your desktop, or on the web.
• How to add records, and save and delete data.
• To explore the Ribbon interface and how to work with touch devices.
• To use table templates to create forms and add custom elements.
• To sort data and run queries.
• Macros and how they work.
• How to import data from external sources.

Microsoft Access is available in versions: 2013 & 2016

Microsoft Power BI:

• How to use the Query Editor to transform and morph data into the right format for your reporting purposes.
• How to perform complex data modelling operations using relationships, calculated columns, measures, and DAX expressions.
• How to share dashboards and reports, with colleagues, business partners and potential clients.
• How to use Power BI’s sophisticated security features to control the exact content your audience can view.
• How to use Power BI Desktop, Service and Mobile Apps
• How to connect with a variety of data sources