Overview

Become an expert in data analysis and master Excel to stand out to prospective employers, with this step-by-step training course.

Split in 10 in-depth modules, the Data Analysis, Automating and Visualisation in Excel course is designed for learners of all levels, covering the very basics to more complex areas of data analysis. It will guide you key topics such as through how to automate workbook functionality, forecast data and work with multiple worksheets and workbooks, as well as how to visualise data with charts.

Master data analysis in Excel online and add a new qualification to your CV to fast track your career!

Why buy this Data Analysis, Automating and Visualisation in Excel?

  1. Unlimited access to the course for forever
  2. Digital Certificate, Transcript, student ID all included in the price
  3. Absolutely no hidden fees
  4. Directly receive CPD accredited qualifications after course completion
  5. Receive one to one assistance on every weekday from professionals
  6. Immediately receive the PDF certificate after passing
  7. Receive the original copies of your certificate and transcript on the next working day
  8. Easily learn the skills and knowledge from the comfort of your home

Certification

After studying the course materials of the Data Analysis, Automating and Visualisation in Excel you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8.

Who is this course for?

This Data Analysis, Automating and Visualisation in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning. 

Prerequisites

This Data Analysis, Automating and Visualisation in Excel was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.

Career path

As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Data Analysis, Automating and Visualisation in Excel is a great way for you to gain multiple skills from the comfort of your home.

Course Curriculum

Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00
Search for and Replace Data 00:09:00
Use Proofing and Research Tools 00:07:00
Working with Lists
Sort Data 00:10:00
Filter Data 00:10:00
Query Data with Database Functions 00:09:00
Outline and Subtotal Data 00:09:00
Analyzing Data
Apply Intermediate Conditional Formatting 00:07:00
Apply Advanced Conditional Formatting 00:05:00
Visualizing Data with Charts
Create Charts 00:13:00
Modify and Format Charts 00:12:00
Use Advanced Chart Features 00:12:00
Using PivotTables and PivotCharts
Create a PivotTable 00:13:00
Analyze PivotTable Data 00:12:00
Present Data with PivotCharts 00:07:00
Filter Data by Using Timelines and Slicers 00:11:00
Working with Multiple Worksheets and Workbooks
Use Links and External References 00:12:00
Use 3-D References 00:06:00
Consolidate Data 00:05:00
Using Lookup Functions and Formula Auditing
Use Lookup Functions 00:12:00
Trace Cells 00:09:00
Watch and Evaluate Formulas 00:08:00
Automating Workbook Functionality
Apply Data Validation 00:13:00
Search for Invalid Data and Formulas with Errors 00:04:00
Work with Macros 00:18:00
Creating Sparklines and Mapping Data
Create Sparklines 00:07:00
MapData 00:07:00
Forecasting Data
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

Course Reviews

4.9

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

No Reviews found for this course.

Studyhub Course Certification

Add a new crest to your professional endeavour now with successful completion of this resourceful course developed diligently by Studyhub. Upskill yourself with quality education, and attain this accredited certificate to manifest a rock-solid foundation of your knowledge. Enhance your CV, showcase this added glory with pride and confidence.

image

Setup Menus in Admin Panel