Advanced Microsoft Data Analysis

4.8( 9 REVIEWS )

Advanced Microsoft Data Analysis

4.8( 9 REVIEWS )

Extra 50% OFF! Get subscription of 1000+ courses for £99!£49! Find Out More

Advanced Microsoft Data Analysis TAKE THIS COURSE loader


Do you want to improve your Microsoft Analysis Skills to an advanced level? Then this course is all you are looking for.

Microsoft still a giant in the world of data analysis. Understanding how to utilize these tools and functions to extract meaningful business decisions from data could be the difference between business or career success and failure.

This bundle course includes Microsoft Excel Advanced, Microsoft Access Advanced, Microsoft VBA and Microsoft Power BI courses – designed to make you an Expert Microsoft Data Analyst.

After completion of the course, you will be able to solve complicated problems using excel, control and administrate your database using Access, create charts, tables and other visualizations of your data using Power BI and simplify data tasks using VBA.

Who is this course for?

Advanced Microsoft Data Analysis is suitable for anyone who wants to gain extensive knowledge, potential experience, and professional skills in the related field. This course is CPD accredited so you don’t have to worry about the quality.


Our Advanced Microsoft Data Analysis is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc.

CPD Certificate from Course Gate

At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99.

Career path

This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry.

Course Curriculum

Microsoft Excel Advanced
Use Links and External References 00:12:00
Use 3-D References 00:06:00
Consolidate Data 00:05:00
Use Lookup Functions 00:12:00
Trace Cells 00:09:00
Watch and Evaluate Formulas 00:08:00
Collaborate on a Workbook 00:19:00
Protect Worksheets and Workbooks 00:08:00
Apply Data Validation 00:13:00
Search for Invalid Data and Formulas with Errors 00:04:00
Work with Macros 00:18:00
Create Sparklines 00:07:00
MapData 00:07:00
Determine Potential Outcomes Using Data Tables 00:08:00
Determine Potential Outcomes Using Scenarios 00:09:00
Use the Goal Seek Feature 00:04:00
Forecasting Data Trends 00:05:00
Activities and Exercise Files: Microsoft Excel Advanced 00:00:00
Microsoft Access Advanced
Add Controls to Forms FREE 00:11:00
Enhance Navigation and Organization of Forms 00:14:00
Apply Conditional Formatting 00:04:00
Import Data into Access 00:08:00
Export Access Data 00:06:00
Link Tables to External Data Sources 00:05:00
Create a Mail Merge 00:02:00
Create a Macro 00:08:00
Restrict Records by Using a Condition 00:04:00
Validate Data by Using a Macro 00:05:00
Automate Data Entry by Using a Macro 00:04:00
Manage a Database 00:08:00
Determine Object Dependency 00:04:00
Manage a Database 00:07:00
Determine Object Dependency 00:04:00
Document a Database 00:04:00
Splitting a Database for Multiple User Access 00:05:00
Implement Security 00:03:00
Convert an Access Database to an ACCDE File 00:04:00
Package a Database with a Digital Signature 00:01:00
Create a Database Switchboard 00:05:00
Modify a Database Switchboard 00:02:00
Set Start up Options 00:04:00
Activities and Exercise Files: Microsoft Access Advanced 00:00:00
Microsoft Excel VBA
Create a Macro Using the Macro Recorder 01:00:00
Edit a Macro 01:00:00
Debug a Macro 00:30:00
Customize the Quick Access Toolbar and Hotkeys 00:30:00
Set Macro Security 01:00:00
Insert Text 00:30:00
Format Text Boxes 00:09:00
Sort Data 00:30:00
Generate a Report 01:00:00
Determine the Dialog Box Type 00:15:00
Capture User Input 01:00:00
Insert, Copy, and Delete Worksheets 00:30:00
Rename Worksheets 00:30:00
Modify the Order of Worksheets 00:15:00
Print Worksheets 00:30:00
Create User-Defined Functions 00:30:00
Automate SUM Functions 00:30:00
Activities and Exercise Files: Advanced Microsoft Data Analysis 00:00:00
Microsoft Power BI
TOPIC A An Introduction to Power BI 00:15:00
TOPIC B Working with Power BI Desktop Files 00:15:00
TOPIC C Connecting to Data Sources with Power BI Desktop 00:15:00
TOPIC D Creating a Report with Visualizations 00:15:00
TOPIC E Doing More with Visualizations 00:15:00
TOPIC A Transforming and Sanitizing Data 00:15:00
TOPIC B Using the Query Editor 00:15:00
TOPIC C Data Modeling 00:15:00
TOPIC D Managing Relationships 00:15:00
TOPIC A Managing Report Pages 00:15:00
TOPIC B Changing Report View Options 00:15:00
TOPIC C Working with Visualizations 00:15:00
TOPIC D Adding Static Objects to a Report 00:15:00
TOPIC A Matrixes, Tables and Charts 00:15:00
TOPIC B Maps 00:15:00
TOPIC C Cards, Gauges, and KPIs 00:15:00
TOPIC D Slicers 00:15:00
TOPIC A Getting Started 00:15:00
TOPIC B Connecting to Data Sources with the Power BI Web App 00:15:00
TOPIC C Using Workspaces, Dashboards, and Reports 00:15:00
TOPIC D Creating Custom Dashboards 00:15:00
TOPIC E Power BI Web App Features 00:15:00
Lesson Labs 00:15:00
Activities and Exercise Files:Microsoft Power BL 00:00:00
Mock Exam
Mock Exam – Advanced Microsoft Data Analysis 00:20:00
Final Exam
Final Exam – Advanced Microsoft Data Analysis 00:20:00
Advanced Microsoft Data Analysis

Course Reviews


9 ratings
  • 5 stars3
  • 4 stars2
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. Ethel Lange


    Something i was really looking forward to enhance my Microsoft skills!

  2. Joan Romo


    Highly recommended, a course surely would weigh my CV extensively as a Data Analyst!

  3. Patrick Pringle


    Now, in no time can resolve issues using excel! Thanks a ton to Advanced Microsoft Data Analysis.

  4. Edward Clark


    Requires a lot of patience due to lengthy outline but much informative to develop expertise as a Data Analyst.

  5. Donald Garcia


    Happy to simplify my data tasks using VBA which was a hassle earlier. Thanks

Advanced Microsoft Data Analysis TAKE THIS COURSE loader


© Course Gate Edukite Ltd, Reg no: 11378092

Your Cart

Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £59.00per year


No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.