Excel Part-1: Data Entry, Formatting & Tables in Hindi

Excel Part-1: Data Entry, Formatting & Tables in Hindi

This beginner-friendly Excel class walks you step by step through data entry, basic formatting, and creating a clean, professional table. You’ll learn how to set up columns like Name, Class, Marks, and Percentage, navigate efficiently with Tab, Enter, and Arrow keys, edit text inside cells with double-click, and use AutoFit to adjust column width for clear visibility. The lesson also covers styling headers with Bold, Font Size, Font Color, and Fill Color for a polished look.

You will practice alignment options (Left, Center, Right), build a title using Insert Row + Merge & Center, apply All Borders for a neat grid, and use Format as Table to instantly add styles and filters. Practical skills include inserting rows, adjusting row height and vertical alignment, copying a table to a new sheet, and productivity shortcuts like Ctrl+A, Ctrl+C, Ctrl+V, Ctrl+Z, and Ctrl+Y. At the end, there is a hands-on practice task: create an Employees List with Name, Department, Salary, and City, then apply proper formatting.

If you want to master data entry, formatting, and basic table styling in a simple, hands-on way, this session is perfect. Like the video, ask questions in the comments, and subscribe for the next part on formulas (SUM, AVERAGE, MAX, MIN) and AutoFill. Add helpful links such as practice files, next-part link, and Excel playlist in the description when publishing.

Excel basics in Hindi
Excel data entry tutorial
Excel formatting for beginners
AutoFit and alignment in Excel
Merge and center title in Excel
Format as Table Excel
Excel shortcuts Ctrl A C V Z Y
Insert row and borders Excel
Excel table styling Hindi
Excel practice task employees list


#ExcelInHindi
#ExcelBasics
#DataEntry
#ExcelFormatting
#ExcelTutorial
#FormatAsTable
#MergeAndCenter
#MicrosoftExcel

Timestamps
00:00 Intro and quick interface recap
00:20 Create student list: Name, Class, Marks, Percentage
00:52 Navigation: Tab, Enter, Arrow keys
02:36 In-cell editing with double-click
03:28 Column width and AutoFit
04:12 Style headers: Bold, font size, colors
05:21 Alignment: Left, Center, Right
06:28 Title: Insert row, Merge & Center “Student Report”
07:25 Emphasize numbers: bold/green
07:56 Borders: All Borders for table
08:26 Format as Table and filters, undo if needed
09:21 Row height and vertical alignment
10:07 Insert a new row via right-click
11:28 Increase font size for readability
11:57 Copy to new sheet with shortcuts
12:30 Delete/Undo/Redo on second sheet
12:52 Practice task: Employees list
13:34 What’s next: Formulas and AutoFill teaser