Chat with us, powered by LiveChat

Advanced Microsoft Data Analysis

4.9( 7 REVIEWS )
577 STUDENTS

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.

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
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
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
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
Mock Exam
Final Exam

Course Reviews

4.9

4.9
7 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE

Instructors

577 STUDENTS ENROLLED

Video Courses

© Course Gate Edukite Ltd, Reg no: 11378092

[{"code":""
[{"code":""
"label":"95% Off"
"label":"95% Off"
"win":false}
"win":false}
{"code":"10OFF"
{"code":"10OFF"
"label":"Free Certificate"
"label":"Free Certificate"
"win":false}
"win":false}
{"code":"FREESHIPPING"
{"code":"FREESHIPPING"
"label":"99% Off"
"label":"99% Off"
"win":false}
"win":false}
{"code":"10OFF"
{"code":"10OFF"
"label":"Free Course"
"label":"Free Course"
"win":false}
"win":false}
{"code":""
{"code":""
"label":"Almost"
"label":"Almost"
"win":false}
"win":false}
{"code":"CG14C"
{"code":"CG14C"
"label":"A Course £14.99"
"label":"A Course £14.99"
"win":true}
"win":true}
{"code":""
{"code":""
"label":"90% Off"
"label":"90% Off"
"win":false}
"win":false}
{"code":"10OFF"
{"code":"10OFF"
"label":"Free E-Book"
"label":"Free E-Book"
"win":false}
"win":false}
{"code":"25OFF"
{"code":"25OFF"
"label":"80% Off"
"label":"80% Off"
"win":false}
"win":false}
{"code":"FREESHIPPING"
{"code":"FREESHIPPING"
"label":"Buy 1 Get 1 Free"
"label":"Buy 1 Get 1 Free"
"win":false}
"win":false}
{"code":""
{"code":""
"label":"Spin Again"
"label":"Spin Again"
"win":false}
"win":false}
{"code":"25OFF"
{"code":"25OFF"
"label":"2 Courses At £19.99"
"label":"2 Courses At £19.99"
"win":false}]
"win":false}]