Advanced Microsoft Data Analysis Bundle

Advanced Microsoft Excel:

• Use advanced graphs in minutes instead of wasting hours trying to figure them out
• Increase interactivity by automating your spreadsheets with macros and VBA
• Solve complex problems with superpower functions
• Turn raw data into ‘must make’ decisions using PivotTables and PowerPivots.
• And more!

Advanced Microsoft Excel is available in versions: 2007 PC, 2010 PC, 2013 PC, 2016 PC

Advanced Microsoft Access:

• How to effectively link to other data sources.
• How to split a database by splitting the frontend and backend.
• To create and maintain macros.
• The use of Visual Basic for Applications (VBA).
• Advanced options for the use of forms.
• Packaging your application for distribution.

Advanced Microsoft Access is available in versions: 2013 & 2016

Advanced Microsoft VBA:

• Advanced methods for automating tedious Excel jobs.
• How to write and implement Excel events.
• How to modify a variety of standard behaviours, such as double-clicking, opening files and saving files.
• How to design and implement specialised classes of objects.
• How to customise the right-click menu within cell ranges.
• External libraries, and how you can extend VBA’s capabilities beyond standard Excel options.
• How to modify the Excel user interface, including the “Ribbon” and context menus to interact with your VBA code

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