Excel Unlocked: Beginner to Advanced

★★★★☆ (1,230 reviews)

Raunak Singh

Created by

2025-03-18

Start Date

2025-03-21

Last Date

Website Design & Development

What you'll learn

Data Management: Organize, sort, and filter large datasets effectively.
Powerful Formulas and Functions: Use key formulas like VLOOKUP, INDEX-MATCH, and SUMIFS.
Data Visualization: Create professional charts, graphs, and dashboards.
Pivot Tables: Summarize and analyze data dynamically with Pivot Tables and slicers.
Advanced Excel Tools: Master Conditional Formatting, Data Validation, and Flash Fill.
Connecting Data Sources: Power Query.

Requirements

Good wifi
Laptop

Description

Excel Unlocked: Beginner to Advanced

Excel Unlocked: Beginner to Advanced is your ultimate guide to mastering Microsoft Excel, designed to cater to both corporate professionals and aspiring students. This course takes a hands-on approach, ensuring that learners gain practical experience with tools and techniques used in real-world scenarios. Whether you’re preparing data reports for your manager, creating dashboards for presentations, or analyzing trends for a project, this course has you covered.

Step-by-Step Learning: Start from Excel basics like formatting, shortcuts, and simple formulas, and progress to advanced features like Pivot Tables, Conditional Formatting, and VLOOKUP.
Real-Life Applications: Work on practical case studies, such as sales reports, financial analysis, and project tracking.
Time-Saving Techniques: Learn how to automate repetitive tasks with macros, Flash Fill, and data validation tools.
Error-Free Work: Discover troubleshooting tips to fix common errors, improve accuracy, and ensure professional-grade work.
Interactive Exercises: Each module includes hands-on exercises and quizzes to reinforce learning.

Course Syllabus

What is a spreadsheet?
Interface and Ribbon
Data Types
Navigation
Introduction to Formulas
Game of Referencing
Practice – Momos Stand
Practice – Momos Stand Solution

Sorting, Filtering & Unique
Practice Sort & Filter
Horizontal Sortv
Text Cleaning Basic
Practice - Text Cleaning
Text Cleaning Advanced
Conditional Formatting
Data Validation

The Lookup Family VLOOKUP, HLOOKUP, and Beyond
VLOOKUP – HLOOKUP (Same Sheet)
VLOOKUP (Inter Sheet)
VLOOKUP with MATCH
INDEX – MATCH - MATCH
XLOOKUP

IF Statements
And/Or
Nested IF
IFS & Switch
Sumif – Countif – Averageif – Maxifs – Minifs
Iferrors

Introduction to Pivot Table Interface
Analysis on Pivot Tables – Pivot Grouping – Slicers
Practice Activity
Bonus Analysis

Introduction to Charts
Bar – Column – Line – Area
Pie – Treemaps – Sunburst – Maps – Others
Creating Charts

Introduction to Macros
Recording a Macro
Introduiction to VBA
Editing the Code
Finding a suitable code
Debuggin

Connecting Data Sources
Data Cleaning
Data Consolidation
Creating Output

Who this course is for:

Corporate Employees: Professionals looking to boost productivity, improve reporting skills, and analyze data effectively.
College Students: Individuals preparing for internships, projects, or placements.
Entrepreneurs and Small Business Owners: Those who want to manage business data efficiently.
Beginners and Intermediates: Anyone who wants to build a strong foundation or upgrade their current Excel skills.

Meet your instructors

Raunak Singh

View Profile

Raunak Singh is a seasoned instructor with a specialization in PowerPoint, Power BI, and Excel. With extensive experience teaching both corporate professionals and students, he has refined his skills in creating impactful presentations, simplifying data visualization, and enhancing data analysis. ...