Description
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.
Requirements
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 £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22.
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 | ||
Certificate and Transcript | |||
Order Your Certificates or Transcripts | 00:00:00 |

Ethel Lange
Something i was really looking forward to enhance my Microsoft skills!
Joan Romo
Highly recommended, a course surely would weigh my CV extensively as a Data Analyst!
Patrick Pringle
Now, in no time can resolve issues using excel! Thanks a ton to Advanced Microsoft Data Analysis.
Edward Clark
Requires a lot of patience due to lengthy outline but much informative to develop expertise as a Data Analyst.
Donald Garcia
Happy to simplify my data tasks using VBA which was a hassle earlier. Thanks