Advanced Microsoft Data Analysis Bundle

Advanced Microsoft Data Analysis Bundle

Course Overview

Are you ready to advance your Microsoft Analysis Skills?

Microsoft still reigns supreme in the world of data analysis. Knowing how to use these tools to extract meaningful business decisions from data could be the difference between business or career success and failure.

This four-course bundle is a combination of our Advanced Excel, Advanced Microsoft Access, Advanced Microsoft VBA and Microsoft Power Bi courses – designed to make you a Microsoft Data pro.
 
What you get with this Advanced Microsoft Data Analysis Bundle:

• 4 advanced, skills-based courses to make you a data analysis pro.
• 259 modules of training, covering the most business-relevant areas of Microsoft Excel.
• 166+ videos and over 100 downloadable exercises.
• Tailored learning. If you have some knowledge, you can use the filter to show only what you most need to learn.
• Multiple videos, practice exercises and test questions to aid your learning.
• Knowledge to understand the data that drives your business.
 
The courses this bundle will cover:

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
 
More about us:

• We have nearly a million students
• Our training is personal. Use the filter to show you which parts of the course to skip.
• Our platform is award-winning and always improving. We work with our authors to ensure our courses are up to date.
• All of our courses are certificated on completion – most of our Business Courses are also CPD Accredited. 

If you are not 100% happy with your EwB Advanced Microsoft Data Analysis Bundle, you have 30 days to exchange or refund.