Skills & Outcomes
What Will You Learn?
Navigate Excel, enter data, format cells, and manage worksheets with ease
Master basic to advanced formulas like IF, VLOOKUP, INDEX, and XLOOKUP
Organize and filter large datasets quickly for better insights and cleaner analysis
Create impactful charts, graphs, and dynamic visuals to present data clearly
Summarize complex data efficiently using Pivot Tables with slicers and calculated fields
Speed up your work using Flash Fill, Named Ranges, and an introduction to Macros
Apply Conditional Formatting to highlight trends and outliers visually
Work with Data Validation, Drop-down Lists, and Sorting & Filtering
Build professional dashboards combining dynamic charts and pivot tables
Complete a real-world Capstone Project to showcase your Excel skills
Target Audience
Who Should Take This Course?
Beginners with zero Excel experience
Students & graduates aiming for analytics, finance, or operations roles
Aspiring data analysts and business analysts
Working professionals looking to build reporting and dashboarding skills
Anyone who regularly works with data in spreadsheets
Managers and executives who need to analyse and present data clearly
Software & Platforms
Tools You'll Work With
From installation to your first query — we cover everything.
Microsoft Excel
The world's most-used spreadsheet tool — essential for every data professional.
Pivot Tables
Summarize thousands of rows instantly with slicers, groupings, and calculated fields.
Excel Charts
From bar charts to speedometer and heatmap charts — visualize data professionally.
Excel Formulas
IF, VLOOKUP, XLOOKUP, INDEX-MATCH, and 50+ formulas covered in depth.
Course Content
Course Curriculum
24 lessons • 63 videos • 15 hours of content • Quizzes & resources included
- ▶Understanding Excel StructuresFREE PREVIEW19:00
- ▶Understanding Navigation, QAT and Tabs & Ribbons in Excel22:00
- ▶Understanding Alt Shortcuts, Active Cell and Customization of Ribbons and Tabs37:00
- ▶Understand the Data Entry and Modification of Cell Content in Excel31:00
- ▶Introduction to Autofill and Number Formatting26:00
- ▶Data Formatting Made Easy!35:00
- ▶Understand Cell Address Nomenclature and Copying, Pasting and Paste Special in Excel51:00
- ▶Excel Power Tools You Must Know | To Special, Find & Replace & Quick Analysis32:00
- ▶Managing Worksheets in Excel30:00
- ▶Understanding Excel Tables and Slicers32:00
- ▶Understand Auto-fill, Custom Lists, and Flash Fill30:00
- ▶Number Formatting in Excel23:00
- ▶Introduction to Excel Formulas23:00
- ▶How to Enter and Edit Excel Formulas!17:00
- ▶Cell Referencing and Formula Auditing!21:00
- ▶Logical Formulas in Excel36:00
- ▶Understanding Mathematical Formulas in Excel – Part 129:00
- ▶Understanding Mathematical Formulas in Excel – Part 238:00
- ▶Lookup and Reference Formulas in Excel – Part 130:00
- ▶Lookup and Reference Formulas in Excel – Part 220:00
- ▶Lookup and Reference Formulas in Excel – Part 310:00
- ▶Stats Formulas in Excel – Explained with Examples – Part 122:00
- ▶Stats Formulas in Excel – Explained with Examples – Part 220:00
- ▶Understanding the Text Formulas in Excel – Part 121:00
- ▶Understanding the Text Formulas in Excel – Part 226:00
- ▶Understanding the Text Formulas in Excel – Part 322:00
- ▶Understanding Date and Time Formula in Excel – Part 122:00
- ▶Understanding Date and Time Formula in Excel – Part 216:00
- ▶Understanding Date and Time Formula in Excel – Part 319:00
- ▶Creating Named Ranges in Excel | Dynamic Named Range in Excel23:00
- ▶Data Validation in Excel | Drop-down Lists – Part 120:00
- ▶Data Validation in Excel Drop-down Lists – Part 219:00
- ▶Data Sorting & Filtering in Excel (Basic + Advanced)34:00
- ▶Excel Conditional Formatting (Overview + Advanced Examples)42:00
- ▶Introduction to Excel Charting | Excel Charts for Beginners59:00
- ▶How to Create a Multi Category Chart in Excel06:00
- ▶How to Create a Speedometer Chart in Excel11:00
- ▶Combo Charts in Excel Made Simple12:00
- ▶How to Create an Advanced Bar Chart in Excel18:00
- ▶How to Create a Dumbbell Chart in Excel17:00
- ▶Excel Thermometer Chart Tutorial | Easy & Beginner Friendly08:00
- ▶How to Create a Heatmap Chart in Excel19:00
- ▶Creating Dynamic Charts in Excel (Using Scroll Bar)33:00
- ▶Creating Dynamic Charts in Excel (Using Drop-down List)18:00
- ▶Excel Pivot Table (Intro, Formatting, Grouping)39:00
- ▶Excel Pivot Table (Slicers, Calculated Fields and Pivot Charts)28:00
- ▶Protecting Worksheets / Workbooks in Excel | Lock Worksheets in Excel15:00
- ▶Excel Capstone Project—
Recognition
Certificate You'll Earn
- Industry-recognized certificate awarded on completing the course and all quizzes.
- Unique verifiable ID that employers and recruiters can validate online.
- LinkedIn-shareable — add it directly to your Licenses & Certifications in one click.
- Backed by SkillLearn's hiring partner network for placement support.
Verifiable Certificate
Common Questions
Frequently Asked Questions
Not at all. This course starts from the very basics — we explain what Excel is and how to navigate it before diving into formulas or charts. If you can use a computer, you're ready to begin.
We recommend Excel 2019, Excel 2021, or Microsoft 365 (Office 365) for the best experience. Most lessons also work on Excel 2016. A free trial of Microsoft 365 is available if you don't already have it.
Lifetime access. Once enrolled you can revisit any lesson at any time, including future content updates added to the curriculum.
Yes. After earning your certificate you get access to SkillLearn's hiring partner network, resume review, and mock interview sessions with mentors.
Yes. All lessons are pre-recorded. You can pause, rewatch, and complete the course on your own schedule. Live Q&A sessions are optional extras.
Absolutely. Pivot Tables, slicers, calculated fields, dynamic charts, and a full dashboard-building module are included. You'll also complete a Capstone Project that ties all skills together.