Data Analysis, Automating & Visualisation in Excel Online Course!

Data Analysis, Automating & Visualisation in Excel Online Course
Pay QR45 instead of QR1483

• Become an expert in data analysis and master Excel to stand out to prospective employers with this step-by-step training course!
• This course is split into 10 in-depth modules designed for learners of all levels, covering the basics to more complex areas of data analysis
• It will guide you through key topics such as automating workbook functionality, forecasting data, working with multiple worksheets and workbooks, and visualizing data with charts
• No formal qualifications are required! This course is suitable for people who want to learn new skills, start a new career, or upgrade their skillset
• Lifetime access to course materials
• Full tutor support is available Monday through Friday for all courses
  
  

Course Outline

Modifying a Worksheet

• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data
• Use Proofing and Research Tools

Working with Lists

• Sort Data
• Filter Data
• Query Data with Database Functions
• Outline and Subtotal Data

Analyzing Data

• Apply Intermediate Conditional Formatting
• Apply Advanced Conditional Formatting

Visualizing Data with Charts

• Create with Charts
• Modify and Format Charts
• Use Advanced Chart Features

Using Pivot Tables and Pivot Charts

• Create a Pivot
• Analyze Pivot Table Data
• Present Data with Pivot Charts
• Filter Data by Using Timelines and Slicers

Working with Multiple Worksheets and Workbooks

• Use Links and External References
• Use 3-D References
• Consolidate Data

Using Lookup Functions and Formula Auditing

• Use Lookup Functions
• Trace Cells
• Watch and Evaluate Formulas

Automating Workbook Functionality

• Apply Data Validation
• Search for Invalid Data and Formulas with Errors
• Work with Macros

Creating Sparklines and Mapping Data

• Create Sparklines
• MapData

Forecasting Data

• Determine Potential Outcomes Using Data Tables
• Determine Potential Outcomes Using Scenarios
• Use the Goal Seek Feature
• Forecasting Data Trends

Assignment

• Assignment – Data Analysis, Automating and Visualisation in Excel

• Valid from 24 Oct - 24 Dec 2025

• Redemption period: 2 months from the deal’s start date

• Limit 1 voucher per person

• Lifetime access to Course content and materials

• May buy multiple vouchers as gifts

• Vouchers not redeemed by 24 Dec 2024 will NOT be refunded

• No mandatory completion deadline. Learners can take and finish it anytime they want.

• Upon successful completion of this course, learners may download a soft copy of the certificate of completion by paying only £5.99; for a printed hard copy of the certificate, learners have to pay £9.60 (shipping charges apply)

• In order to be eligible for the certificate you need to successfully complete the course and pass each course module

• For more information visit: Data Analysis, Automating and Visualisation in Excel or write to info@studyhub.org.uk

• Internet access and audio required

• You’ll get access to detailed video tutorials, practical examples, and useful tips

• Not valid with other offers

• No cash value/No cash back/No refunds
  

How to Redeem:

To activate your voucher and assign your course:

• Click HERE

• Fill up the necessary information

• Enter the voucher code

• Click the submit button

• The course will be assigned to you within 48 hours

Please see the terms for all deals here