Home
Courses
Microsoft Office Suites
Microsoft Office Course
Diploma Course
ADCA
CCC
Designing cousre
Web Designimg
Video Editing
Editing with Adobe
Digital Marketing
Accountig Courses
Tally
Student Registration
Contact
Privacy Policy
Try for free
Search
ADVANCE EXCEL
Dsd Education
>
Courses
>
Microsoft Office Suites
>
ADVANCE EXCEL
Home
Courses
Microsoft Office Suites
ADVANCE EXCEL
20 Sections
127 Lessons
10 Weeks
Curriculum
20 Sections
127 Lessons
10 Weeks
Expand all sections
Collapse 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
Data entry restrictions
The lesson content is empty.
Leave a Reply
Cancel reply
Save my name, email, and website in this browser for the next time I comment.
Post Comment
Modal title
Main Content
Leave a Reply