Home
Courses
Microsoft Office Suites

ADVANCE EXCEL 20 Sections127 Lessons10 Weeks

Curriculum

20 Sections
127 Lessons
10 Weeks

Expand all sectionsCollapse all sections

Unit 1: Introduction to Microsoft Excel
10 Items
- 1.1
  Microsoft Excel kya hai
- 1.2
  Spreadsheet kya hoti hai
- 1.3
  Workbook aur Worksheet
- 1.4
  Rows, Columns aur Cells
- 1.5
  Cell Address
- 1.6
  Data Entry
- 1.7
  Excel Workbook file format
- 1.8
  Formula Bar
- 1.9
  Name Box
- 1.10
  Function Wizard
Unit 2: Functions & Formulas
7 Items
- 2.1
  Insert Function
- 2.2
  Function Wizard
- 2.3
  Functions kya hain
- 2.4
  Operators
- 2.5
  Function Arguments
- 2.6
  Formula ka structure
- 2.7
  Formula kya hai
Unit 3: Cell References
6 Items
- 3.1
  Relative Reference
- 3.2
  Absolute Reference
- 3.3
  Mixed Reference
- 3.4
  $ symbol ka use
- 3.5
  F4 key se reference change karna
- 3.6
  Formulas mein cell references ka use
Unit 4:Named Cells & Ranges
6 Items
- 4.1
  Name kya hai
- 4.2
  Cell/Range ko name dena
- 4.3
  Define Name
- 4.4
  Name Box
- 4.5
  Named Range ka formula mein use
- 4.6
  Named cells/ranges ko manage karna
Unit 5: Basic Excel Practical Theory
10 Items
- 5.1
  Total Marks
- 5.2
  Sorting
- 5.3
  Minimum & Maximum
- 5.4
  Student Report
- 5.5
  Rows/Columns insert aur delete
- 5.6
  Find option
- 5.7
  Worksheets ka use
- 5.8
  Grade
- 5.9
  Percentage
- 5.10
  Result
Unit 6: Fee Calculation
9 Items
- 6.1
  Course Fee
- 6.2
  Admission Fee
- 6.3
  Prospectus Fee
- 6.4
  Examination Fee
- 6.5
  Tax Calculation
- 6.6
  Installment Calculation
- 6.7
  Lump Sum Payment
- 6.8
  Discount Calculation
- 6.9
  SUM ke different methods
Unit 7: Conditional Formatting
5 Items
- 7.1
  Conditional Formatting kya hai
- 7.2
  Conditions ke basis par formatting
- 7.3
  Values ko highlight karna
- 7.4
  Data analysis ke liye conditional formatting
- 7.5
  Practical applications
Unit 8: Paste Special & Data Transformation
7 Items
- 8.1
  Paste Special
- 8.2
  Paste Link
- 8.3
  Values paste karna
- 8.4
  Formulas paste karna
- 8.5
  Formatting paste karna
- 8.6
  Transpose
- 8.7
  Row ko Column aur Column ko Row mein convert karna
Unit 9: Data Analysis Functions
5 Items
- 9.1
  AVERAGE
- 9.2
  MAX
- 9.3
  MIN
- 9.4
  Different data ranges par calculations
- 9.5
  Practical data analysis
Unit 10: Fill Handle & Fill Series
7 Items
- 10.1
  Fill Handle
- 10.2
  Auto Fill
- 10.3
  Fill Series
- 10.4
  Number Series
- 10.5
  Date Series
- 10.6
  Linear Series
- 10.7
  Growth Series
Unit 11: Sorting
5 Items
- 11.1
  Sorting kya hai
- 11.2
  Ascending Order
- 11.3
  Descending Order
- 11.4
  Multiple-column sorting
- 11.5
  Data ko organize karna
Unit 12: Filtering
7 Items
- 12.1
  AutoFilter
- 12.2
  Custom AutoFilter
- 12.3
  Filtering by criteria
- 12.4
  Advanced Filter
- 12.5
  Criteria Range
- 12.6
  AND condition
- 12.7
  OR condition
Unit 13: Data Validation
4 Items
- 13.1
  Data Validation kya hai
- 13.2
  Data entry restrictions
- 13.3
  Criteria based data entry
- 13.4
  Valid data maintain karna
Unit 14: Goal Seek & Scenarios
5 Items
- 14.1
  Scenarios
- 14.2
  Different conditions ke according result analysis
- 14.3
  Goal Seek
- 14.4
  Financial calculations mein Goal Seek
- 14.5
  Target value find karna
Unit 15: Pivot Tables
6 Items
- 15.1
  Pivot Table kya hai
- 15.2
  Pivot Table create karna
- 15.3
  Data summarize karna
- 15.4
  Rows aur Columns mein fields arrange karna
- 15.5
  Values ka calculation
- 15.6
  Pivot Table sorting
Unit 16: Two-Dimensional Pivot Table
5 Items
- 16.1
  Row fields
- 16.2
  Column fields
- 16.3
  Value fields
- 16.4
  Two-dimensional data analysis
- 16.5
  Summary report create karna
Unit 17: Slicers
4 Items
- 17.1
  Slicer kya hai
- 17.2
  Pivot Table ke saath Slicer
- 17.3
  Data filtering through Slicer
- 17.4
  Interactive data analysis
Unit 18: Charts
9 Items
- 18.1
  Chart kya hai
- 18.2
  Charts ka purpose
- 18.3
  Data ko graphical form mein represent karna
- 18.4
  Line Chart
- 18.5
  Column Chart
- 18.6
  Chart data select karna
- 18.7
  Row/Column switch karna
- 18.8
  Legend
- 18.9
  Data Labels
Unit 19: Combination Chart
4 Items
- 19.1
  Combination Chart
- 19.2
  Different chart types ko combine karna
- 19.3
  Data comparison
- 19.4
  Professional reporting
Unit 20: Financial & Business Analysis
6 Items
- 20.1
  Financial Projection
- 20.2
  Salary Analysis
- 20.3
  Sales Analysis
- 20.4
  Discount Calculation
- 20.5
  Payroll Analysis
- 20.6
  Data-based reporting

Values paste karna

1. Values Paste kya hai?

Values Paste Excel ke Paste Special ka ek important option hai. Iska use kisi cell ya range mein present sirf actual result/value ko paste karne ke liye kiya jata hai, formula, formatting ya other properties ko nahi.

2. Values Paste ki zarurat kyon hoti hai?

Advanced Excel mein kai baar formula se calculated result ko fixed value mein convert karna hota hai. Aise situation mein Values Paste ka use kiya jata hai.

Example:

A1 mein formula hai:

=B1+C1

Aur result hai ₹25,000.

Agar A1 ko copy karke Paste Special → Values kiya jaye, to destination cell mein:

₹25,000

paste hoga, lekin =B1+C1 formula paste nahi hoga.

3. Values Paste ke Benefits

Formula ko permanent result mein convert kar sakte hain.
Source cells se dependency remove ki ja sakti hai.
Data sharing ke time formulas hide/remove kiye ja sakte hain.
Large reports ko static format mein convert kiya ja sakta hai.
Calculated data ko further processing ke liye use karna easy hota hai.

4. Practical Uses

Advanced Excel mein Values Paste ka use:

MIS Reports
Sales Reports
Financial Reports
Employee Salary Sheets
Data Cleaning
Monthly Reports
Final Report Preparation
Formula Results ko Fixed Values mein Convert Karna

mein kiya jata hai.

5. Shortcut

Ctrl + C → Ctrl + Alt + V → V → Enter

Is process se copied data ko Values ke form mein paste kiya ja sakta hai.

Search

Company

Platform

Subscribe