Advanced Microsoft Data Analysis Bundle
Course
Online
Description
-
Type
Course
-
Level
Advanced
-
Methodology
Online
-
Class hours
65h
-
Duration
Flexible
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
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.
Facilities
Location
Start date
Start date
About this course
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.
CPD UK
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 4 years
Subjects
- Excel
- Microsoft Access
- Access
- PC
- PC training
- Data analysis
- MS Excel
- Automating
- Spreadsheets
- VBA
Course programme
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
Advanced Microsoft Data Analysis Bundle