Excel Mastery: Learn from Basics to Advanced Level

In This Video You'll learn about Fonts, Alignments, Borders,

Number Formatting (Currency, Date, %)

Format Paingter

Wrap text and merge cells

In This Video You'll learn about Data Entry & Formatting and will create a Employee Salary Sheet and will use many things like  Fonts, Alignments, Borders,

Number Formatting (Currency, Date, %)

Format Paingter

Wrap text and merge cells

In this video, you will learn how to create a professional and automated Pay Slip format in Microsoft Excel from scratch. This step-by-step tutorial is perfect for beginners as well as intermediate users who want to design a clean and functional salary slip for employees.

We will cover how to structure employee details, salary components such as basic pay, allowances, and deductions, and how to calculate net salary using simple Excel formulas. You’ll also learn how to format the payslip for a professional look, making it ready for real-world use in offices and businesses.

By the end of this video, you will be able to create your own customized payslip template that can save time and reduce manual work.

1. Formula basics (= sign)

2. Arithmetic operations

3. SUM, AVERAGE, COUNT

4. MIN, MAX

5. Relative & Absolute reference ($)

1. Formula basics (= sign)

2. Arithmetic operations

3. SUM, AVERAGE, COUNT

4. CountIFS

5. Relative & Absolute reference ($)

1. Formula basics (= sign)

2. Arithmetic operations

3. SUM, AVERAGE, COUNT

4. Vlookup

5. Relative & Absolute reference ($)

In this video, you will master the IF function in Microsoft Excel from beginner to advanced level. The IF function is one of the most powerful and commonly used formulas in Excel, allowing you to make logical decisions based on conditions.

We will start with the basic syntax of the IF function and then move towards real-world examples like grading systems, pass/fail results, salary conditions, and performance analysis. You’ll also learn how to use nested IF statements and combine IF with other functions for more advanced scenarios.

By the end of this video, you will be confident in using IF formulas to automate decision-making in your Excel projects.

In this video, you will learn the VLOOKUP function in Microsoft Excel from beginner to advanced level. VLOOKUP is one of the most essential functions used to search and retrieve data from large datasets quickly and efficiently.

We will start with the basic syntax and then move to practical examples like fetching employee details, product prices, and sales data. You will also learn about exact match and approximate match, common errors, and how to fix them.

By the end of this video, you will be able to confidently use VLOOKUP in real-world scenarios and improve your data analysis skills.

In this video, you will learn the HLOOKUP function in Microsoft Excel from beginner to advanced level. HLOOKUP (Horizontal Lookup) is used to search for a value in the top row of a table and return a corresponding value from a specified row.

We will start with the basic syntax and move to practical examples such as retrieving monthly sales data, product information, and performance metrics. You’ll also learn about exact and approximate match, common errors, and best practices.

By the end of this video, you will be able to confidently use HLOOKUP in real-world scenarios and understand when to use it over other lookup functions.

In this video, you will master the XLOOKUP function in Microsoft Excel, one of the most powerful and modern lookup functions available. XLOOKUP is designed to replace older functions like VLOOKUP and HLOOKUP, offering more flexibility and accuracy.

We will start with the basic syntax and then move to real-world examples such as retrieving employee data, sales records, and product details. You will also learn advanced features like searching from right to left, handling missing values, and using different match modes.

By the end of this video, you will be able to confidently use XLOOKUP in your daily work and build more dynamic Excel reports and dashboards.

Are you ready to turn raw data into powerful business insights?

In this course, you will learn how to create a fully interactive Sales Dashboard in Microsoft Excel from scratch. This course is designed for beginners as well as intermediate users who want to build professional dashboards used in real-world business environments.

We will start with raw sales data and gradually transform it into a dynamic and visually appealing dashboard using powerful Excel tools like Pivot Tables, Pivot Charts, slicers, and advanced formulas.

You’ll not only learn how to design dashboards but also understand how to present data in a way that helps in better decision-making.

By the end of this course, you will have a complete sales dashboard project that you can showcase in your portfolio or use in your job.

Data is only as valuable as its quality—and in this course, you’ll learn how to transform messy, unstructured data into clean, reliable, and analysis-ready datasets using Microsoft Excel.

“Data Cleaning in Excel” is a practical, hands-on course designed for beginners as well as professionals who want to improve their data handling skills. Whether you're working with raw datasets, reports, or imported files, this course will teach you how to efficiently clean and organize your data like a pro.

You’ll start with the fundamentals of data cleaning and gradually move to advanced techniques used in real-world scenarios. Through step-by-step tutorials and practical examples, you’ll gain confidence in identifying errors, fixing inconsistencies, and preparing data for analysis.

What You’ll Learn:

• Remove duplicates and handle missing data

• Clean text using functions like TRIM, CLEAN, LEFT, RIGHT, MID

• Use Find & Replace for quick corrections

• Format and standardize data for consistency

• Split and merge data efficiently

• Work with dates, numbers, and formatting issues

• Apply sorting, filtering, and validation techniques

• Prepare datasets for dashboards and analysis