Data Analysis, Automating & Visualisation in Excel Online Course!

45 QR 1483 QR
Full Price
1483 QR
You Save
1438 QR
No longer
available
The deal ended at:
11/10/23
11:59PM
3 bought
limited quantity available

Fine Print

  • Valid from 22 Sep – 22 Nov 2023
  • 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 22 Nov 2023 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 Excelor write to [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:

  • Please visit the Redeem Voucher Page of Study Hub
  • 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

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

Chart Your Success: Master Data Analysis in Excel!

 

Over the course of 15 years, Studyhub has witnessed a continuous evolution in culture. Throughout its history, Studyhub’s core principles have remained steadfast, playing a central role in shaping behavior, fostering a customer-centric approach, and influencing collaborative dynamics among team members, learners, and the wider community. The combination of these elements contributes to the creation of a positive and nurturing environment.

The current era offers an unprecedented array of options and opportunities, all conveniently accessible at one’s fingertips. The ability to acquire new skills and foster personal growth has never been easier, with the availability of online platforms. Through Studyhub, individuals can now partake in learning experiences facilitated by the most seasoned instructors from across the globe. Furthermore, the internet has enabled individuals to ignite revolutionary movements and bring about transformative change, all from the comfort of their homes.