
In this lesson, we will explore the Starting Screen of Excel and learn how to open a new blank workbook, a template, and saved workbooks.
In this video, we will explore the Microsoft Excel 365 interface.
In this video, we will learn how to put data in a cell and how a Formula works within a cell. Additionally, we will learn how to edit data or a Formula in a cell.
In this video, we will learn what is a cell and what is a namebox. Additionally, we will learn how to custom name a cell.
In this video, we will practically demonstrate how to perform basic arithmetic operations in a Formula and understand how Excel uses the BODMAS method to evaluate a formula.
In this video, we will learn about Data Types and Data Formatting.
In this video, we will learn how to move data from one cell to another, We will also learn different methods of Copy/ Paste and Cut/ Paste.
In this video, we will learn about Ranges in Excel. Also, how to name and reference Ranges.
In this video, we will learn the basics of referencing cells and ranges.
In this video, we will learn how we can autofill data using the Fill handle and Fill Series tool.
In this video, we will learn how to adjust height and width of cells.
In this video, we will explore ways to format Font and examine the Font group in detail.
In this video, we will learn how to set the alignment of data within cells. We will examine the commands within the Alignment group.
In this video, we will learn the basic concept of Function in Excel.
In this video, we will learn seven super basic Functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK
In this video, we will learn the basics of managing worksheets and working between sheets.
In this video, we will learn to set the layout of the worksheet.
In this video, we will Learn how to save a workbook as an Excel workbook file, a PDF, and how to export as a PDF directly.
Course Overview
Are you a complete beginner to Microsoft Excel? Do you feel overwhelmed by spreadsheets, formulas, or the layout of Excel? Have you opened Excel before and closed it right away because it looked too complicated?
If so, this course is designed exactly for you.
Excel for Dummies is a beginner-friendly, super basic, step-by-step training course taught in simple Urdu and Hindi, perfect for anyone who wants to learn Excel from scratch. Whether you're a student, job seeker, freelancer, or office worker, this course will help you understand and use Excel confidently — even if you’ve never used it before.
We start from the very basics — such as how to open Excel and understand its interface — and slowly guide you through how to enter, format, and manage your data. The lessons are explained in plain language, using easy examples, and there’s no need to have any prior experience with Excel.
By the end of the course, you’ll be able to handle day-to-day Excel tasks that are essential for data entry, office work, freelancing, and personal productivity.
What You Will Learn
- How to open Excel, create a new workbook, and explore the Excel interface
- Understanding cells, rows, columns, and ranges — and how to manage them
- Entering text and numbers, editing data, and applying basic formatting (font, alignment, borders, etc.)
- Using essential formulas and functions like SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, and COUNTBLANK
- How to manage worksheets (renaming, adding, deleting, and rearranging sheets)
- Setting up a workbook for printing: page layout, print area, headers, footers, and scaling
- Practical time-saving tips and Excel shortcuts to make your work faster and easier
This course is designed to build your foundation so you can continue learning Excel for more advanced tasks like data analysis, dashboards, and automation — all at your own pace. And yes, it’s all taught in Urdu/Hindi so you can learn comfortably and confidently.