Step 1 Basic Data Entry and Saving

Transcript

BASIC Excel - teachoo.com Make a folder Called Training Make Some subfolders like Excel,Tally,GST,TDS Open Excel Folder. Make an Excel file called Basic Excel Open Excel File and Make the following in different sheets Q1 Item Quantity Rate Amount Discount 40% Net Amount GST 28% Total P 10000 2 Q 20000 4 R 15000 5 S 18000 6 T 40000 3 Total Q2 Employess Name Basic Pay DA HRA Bonus Gross Salary PF ESI Net Salary L 40000 1/2 of Basic 1/4 of (Basic + DA) Double of (basic + HRA) Total Salary 12% of (Basic + DA) 1.75% of Gross Salary Gross - PF -ESI M 15000 N 10000 O 20000 P 18000 Total Q3 Useful Excel Formulas Make the Following in Excel To Make Folder Ctrl Shift N Drag Down Select Area Ctrl D 1 1 100 100 Drag Right Select Area Ctrl R 2 3 200 200 Copy Paste Ctrl C CTRL V 3 5 300 400 Cut Paste Ctrl X Ctrl V 4 7 400 800 Bold Ctrl B 5 9 500 1600 If Some Mistake Ctrl Z or Esc 6 11 600 3200 To Edit a Cell F2 7 13 700 6400 To Save Ctrl S 8 15 800 12800 To Go To Next Sheet Ctrl Pagedown 9 17 900 25600 To Come Back Ctrl Pageup 10 19 1000 51200 To Minimize Windows D Q4 Make Depreciation chart WDV Method SLM Method Year Opening Value Dep 10% Closing Value Year Opening Value Dep 10% Closing Value 2020 100000 20000 80000 2020 100000 20000 80000 2021 80000 16000 64000 2021 80000 20000 60000 2022 64000 12800 51200 2022 60000 20000 40000 2023 51200 10240 40960 2023 40000 20000 20000 2024 40960 8192 32768 2024 20000 20000 0