MS Excel Complete Guide in Hindi | Notes, Tutorial, Formulas & Shortcut Keys

MS Excel की पूरी जानकारी

1. परिचय और बुनियादी अवधारणाएँ (Introduction & Basics)

• MS Excel Spreadsheet Basics & Features
• Concepts of Workbook & Worksheets
• Getting Started (शुरुआत)
• Creating a New Worksheet
• Using Wizards

2. डेटा प्रविष्टि एवं कक्ष प्रबंधन (Data Entry & Cell Management)

• Various Data Types
• Selecting Cells
• Entering and Editing Text
• Entering and Editing Numbers
• Removing & Resizing of Columns & Rows
• Inserting Rows & Columns
• Inserting Cells
• Deleting Parts of a Worksheet
• Clearing Parts of a Worksheet
• Different Views of Worksheets

3. सूत्र, संदर्भ और संपादन (Formulas, References & Editing)

• Entering and Editing Formulas
• Referencing Cells
• Moving & Copying Cells
• Sorting Cell Data

4. पेज लेआउट एवं बुनियादी फॉर्मेटिंग (Page Layout & Basic Formatting)

• Page Setup
• Cell Formatting
• Changing Column Widths and Row Heights
• Auto Format
• Changing Font Sizes and Attributes
• Centering Text Across Columns

5. उन्नत स्वरूपण एवं डेटा संरचना (Advanced Formatting & Data Structure)

• Using Border Buttons and Commands
• Changing Colors and Shading
• Hiding Rows and Columns
• Working with Data & Ranges
• Column Freezing
• Labels
• Hiding (Rows, Columns, Sheets)
• Splitting
• Merging etc.

6. चार्ट और प्रिंटिंग (Charts & Printing)

• Chart Parts and Terminology
• Chart Wizard
• Different Types of Charts
• Printing Charts
• Deleting Charts
• Printing of Workbook & Worksheets with various options

Quiz लगाएँ