- Full Price
- 1483 QR
- You Save
- 1438 QR
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.