Full Excel Journey: Master Basics To Advanced Functions

Full Excel Journey: Master Basics To Advanced Functions
Published 5/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

What you’ll learn

Master Excel from scratch and build powerful spreadsheets with confidence

Format cells, tables, and reports like a professional analyst

Automate your workflow with advanced sorting, filtering, and data validation

Import and connect data from text files, databases, cloud, and web sources

Clean, transform, and prepare data effortlessly using Power Query

Dominate essential Excel functions like IF, VLOOKUP, INDEX, MATCH, and more

Build interactive Pivot Tables and slicer-driven dashboards

Design KPI dashboards to monitor business metrics in real time

Work with Date, Time, Text, Numeric, and Statistical functions like a pro

Boost your Excel speed with productivity hacks and best practices

Solve real-world business problems through hands-on Excel projects

Requirements

No prior experience is required to join our Data Analytics course-it’s beginner-friendly and open to all.

We’ll teach you everything from basic formulas to advanced functions step by step. All you need is a laptop with Excel and a desire to learn!

Description

Overview

Section 1: Introduction to Data Analytics

Lecture 1 Excel Essentials: Your First Step to Mastering Data

Section 2: Excel Basics and Data Management

Lecture 2 Introduction to Excel and Its Components

Lecture 3 Formatting Cells and Data

Lecture 4 Navigating Excel and Conditional Formatting

Lecture 5 Advanced Sorting, Filtering, and Data Validation

Section 3: Importing, Connecting, and Visualizing Data

Lecture 6 Importing Data into Excel

Lecture 7 Hands-On with Data Reading & Connections

Lecture 8 Power Query & Data Exporting

Section 4: Excel Functions and Data Modeling

Lecture 12 Cell References & Logical Conditions

Lecture 13 Lookup Functions – Vertical & Match-Based

Lecture 14 Advanced Lookups & Navigation Tools

Lecture 15 Data Modeling with Excel Functions

Section 5: Pivot Tables and Dashboard Building

Lecture 16 Pivot Table Foundations

Lecture 17 Building Pivot Tables

Lecture 18 Advanced Pivot Tools & Interactivity

Lecture 19 KPI Metrics & Dashboards

Lecture 20 Practice Session: Pivot Tables & Dashboards

Section 6: Advanced Pivoting and KPI Dashboards

Lecture 21 Pivot Table Field Operations & Value Summarization

Lecture 22 Advanced Calculations – Rankings, Running Totals & More

Lecture 23 Pivot Enhancements & Styles

Lecture 24 Data Model & KPI Design

Lecture 25 Real-Time Dashboards with KPIs

Section 7: Excel Deep-Dive: Functions and Practical Application

Lecture 26 Date & Time Functions

Lecture 27 Text & Character Functions

Lecture 28 Numeric & Statistical Functions with Practical Examples

This Excel course is for anyone who wants to build strong spreadsheet skills from the ground up. It’s perfect for students, job seekers, working professionals, small business owners, or anyone looking to manage data better. Whether you’re from a non-technical background or switching careers, this course is for you.