Qgrabs

Data Analysis, Automating & Visualisation in Excel Online Course!

Data Analysis, Automating & Visualisation in Excel Online Course!
Bought:1
Deal starts at:-5 hours 41 min 25 sec

QR 45

Share this:

Highlights

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

Fine Print

  • Valid from 26 Jun - 26 Aug 2026

  • 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 26 Aug 2026 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 email [email protected]

  • 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

Study Hub
Vendor Info
Study Hub
  • Loading ...