Step 1 Basic Data Entry and Saving
Last updated at June 3, 2021 by Teachoo
Assignments
How to Make a Folder
View Answer
Shortcut of Folder
All Folder Made
How to Make an Excel File
View Answer
Open Excel File
Answer of Q1
Formulas of Q 1
Hindi Videos
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
English Videos
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
Answer of Q2
Formulas of Q 2
English Video
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
Hindi Video
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
Formulas of Q 3
Hindi Video
This video is only available for Teachoo black users
English Video
This video is only available for Teachoo black users
Formula SLM Method of Q4
Formula WDV Method of Q4
Hindi Video
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
English Video
This video is only available for Teachoo black users
This video is only available for Teachoo black users
This video is only available for Teachoo black users
Make Excel File with Following details
Employee Name
|
Basic Salary
|
P
|
50000
|
Q
|
40000
|
R
|
10000
|
S
|
90000
|
T
|
8000
|
Make File Name- Basic Excel
Put Folder Name- Excel
Save Folder in D Drive
This video is only available for Teachoo black users
This video is only available for Teachoo black users
Important Points
Dont Start from First Column First Row
Leave few rows on left and few rows on right
It is always better to Save File in D or E drive instead of Desktop or My Documents
(because data may be lost if computer windows is changed
We can create shortcut on Desktop for our convenience
Learn GST, TDS, Excel (with certification)