Microsoft Excel & Data Analysis

Go from Excel beginner to data analysis pro — master formulas, pivot tables, dashboards and more.

ZedSkills

English

Certificate Course

0 Students

01h 15m

Course Overview

Excel is the world's most used data tool — and knowing it well sets you apart in any industry. This course takes you from the basics right through to professional-level data analysis and dashboard building.

What You'll Cover

Excel interface, navigation and workbook management
Essential formulas: SUM, IF, VLOOKUP, INDEX/MATCH
Data cleaning and transformation
Pivot tables and pivot charts
Conditional formatting and data validation
Advanced formulas: XLOOKUP, dynamic arrays
Interactive dashboards and reports
Introduction to Power Query
Keyboard shortcuts to work 10x faster

FAQ

Course curriculum

Requirment

<ul><li>Microsoft Excel installed (2016 or later recommended)</li><li>No prior Excel knowledge needed</li></ul>

Outcomes

<ul><li>Build powerful Excel dashboards</li><li>Analyse large datasets with pivot tables</li><li>Automate repetitive tasks with formulas</li><li>Present data visually with professional charts</li></ul>

Publisher

ZedSkills

Learn Skills That Matter

ZedSkills is an online learning platform dedicated to empowering individuals with the practical skills needed to thrive in today's world. From technology and business to lifestyle and agriculture, our expert-curated courses are designed to inspire, educate, and transform.

Reviews

Rate this course :

Remove all

Top course

K2

Buy Now

Students
0
Language
English
Duration
01h 15m
Level
beginner
Expiry period
Lifetime
Certificate
yes

Looking to upskill?

Ebooks

Find A Tutor

Course Bundles