Excel Job Ready Course in Hindi
- 626 likes on YouTube
- 21.7K views
Created by Intellectual learner on YouTube
What you'll learn
- SUM function
- VLOOKUP syntax and arguments
- Invoice layout and formatting
- Basic math functions (SUM, AVERAGE, COUNT, MAX, MIN)
- Marksheet layout and formatting
- Bank loan record setup
- SUM with Alt+= shortcut
- Exact match in VLOOKUP
Explore related topics
Course content
01Excel SUM, SUMIF & SUMIFS Formula Explained | Complete Guide in HindiPreview06:24
This chapter teaches three Excel functions for totalling numbers: SUM, SUMIF and SUMIFS. It starts with the basic SUM function, which adds a selected range of cells. Every Excel formula begins with an equals sign, and SUM is written as =SUM(range). The chapter also shows a shortcut: selecting the cell just below a set of numbers and pressing Alt with equals (Alt+=) automatically inserts a SUM of the cells above. This shortcut works only when the total sits directly under the numbers.
- SUM function
- SUM with Alt+= shortcut
- SUMIF function
- SUMIFS with multiple conditions
02VLOOKUP vs XLOOKUP Explained in Hindi | Excel Beginners to Advanced 🔥Preview12:34
This chapter compares two Excel lookup functions, VLOOKUP and XLOOKUP, using an employee data sheet where Employee ID is used to find other details such as Name, Department, City, Salary and Joining Date. In VLOOKUP, the four parts are the lookup value (the ID being searched), the table array (the data range to search), the column index number (which column to return, counted from the left of the table) and the range lookup (0 or FALSE for an exact match). Because the column index is a fixed number, dragging the formula does not move to the next column automatically. The fix is to use MATCH to find the column number, or COLUMNS to count columns, and to lock the references with F4 (absolute references) so the table array and lookup value stay fixed while the formula is copied.
- VLOOKUP syntax and arguments
- Exact match in VLOOKUP
- MATCH and COLUMNS for dynamic column numbers
- Absolute references with F4
- XLOOKUP syntax and advantages
- Dynamic data and column insertion
03“Excel me Invoice Kaise Banaye 🔥| Step-by-Step Full Tutorial (Hindi)”Preview17:12
This chapter is a step-by-step tutorial on building a professional invoice in Microsoft Excel. It starts with the page layout: merging and centering the top rows to hold the shop name, address, mobile number and email, then adding a title bar that reads 'Invoice / Cash Memo'. The invoice header is set up next, with fields for customer name, address, GST number, invoice date and invoice number. Merged cells and thick outside borders are used to give the sheet a clean, bordered look, and print preview is used to check how it will appear on paper.
- Invoice layout and formatting
- Formulas for amount and totals
- Data Validation drop-down lists
- GST calculation (CGST, SGST, IGST)
04Excel ke Top 25 Formulas | Beginner to Advanced (Hindi)Preview22:20
This chapter teaches the 25 most important Excel formulas for beginners and job seekers, split into four parts. Part one covers basic formulas using a mark-sheet example: SUM adds a range of numbers, AVERAGE finds the mean, COUNT counts only numeric cells (not text), COUNTA counts non-empty cells including text, MAX finds the highest value and MIN the lowest. Every formula starts with an equals sign, and double-clicking the fill handle copies it down a column.
- Basic math functions (SUM, AVERAGE, COUNT, MAX, MIN)
- Conditional functions (IF, SUMIF, AVERAGEIF, COUNTIF)
- Text functions (UPPER, LOWER, PROPER, LEFT, MID, LEN, TRIM, CONCAT)
- Date functions (TODAY, NOW, EDATE, EOMONTH)
- Date difference and working days (DATEDIF, NETWORKDAYS)
05Excel में Marksheet कैसे बनाए 🔥| Step-by-Step Guide In Hindi | Microsoft Excel | #excel #computerPreview14:23
This chapter shows how to build an automatic marksheet in Excel, step by step. The layout comes first: the top three rows are left empty for the school or institute name, and the header cells (Roll No, Student Name, Class, Subjects, Total Marks, Marks Obtained, Percentage, Result, Division) are merged and centred across columns. Column widths are fixed by double-clicking the column border so text is not hidden, and Alt+Enter is used to wrap long header text onto a second line. Formatting such as fill colours, borders and centring makes the sheet look neat.
- Marksheet layout and formatting
- Merge and Center
- RANDBETWEEN and paste as values
- SUM and percentage formulas
- COUNTIF with IF for result
- Nested IF for division
06Excel Work in Bank | Data Entry in Excel | Calculate Bank Loan EMI in Excel हिंदी में |Preview10:04
This chapter shows how to build a bank loan record in Excel. A loan record tracks who borrowed money, how much, on what date, at what interest rate, for how long, and when the loan ends. The main columns are serial number, client name, loan type, loan amount, loan date, rate of interest, duration, ending date, EMI, total amount, and interest. Loan types include home, car, personal, and business loans. Interest rates differ from bank to bank and by loan type, so they must be entered according to the bank's rate. The loan amount is the principal the bank lends to the client.
- Bank loan record setup
- Ending date with EDATE
- Finance • EMI calculation with PMT
- Finance • Total amount and interest on a loan
- Formatting dates and tables
- 07How To Make Attendance Sheet in MS Excel || Attendance Sheet in Excel MS Excel || #excel #msexcelPreview14:29
- 08How to create Salary sheet in excel || D.A, T.A, H.R.A, PF, ESI, Gross salary ||Ms ExcelPreview12:31
About the creator
- YouTube channel
- 56.6K subscribers
- 1 course on Studyio
The videos in this course are made by Intellectual learner and play from YouTube, credited to them. Studyio adds the chapters, notes, quizzes and a certificate around them.
More courses like this

11. Introduction to Machine Learning

Computer Vision Bootcamp | Full 12 hour series | OpenCV, RCNN, UNet, YOLO and Roboflow

SQL Tutorial for Beginners (Complete Course using MySQL)

11. Classical Machine Learning | Complete Playlist

2026 FREE Data Analyst Bootcamp [24 Hours+] for FREE | SQL, Excel, Python, Power BI, GitHub, AWS
