• Purpose: Data entry, calculations, analysis, reports
• HR examples: Attendance sheets, payroll, performance tracking
Example:
erformance tracking
2025
No ID Fist Name Last Name Salary Jan Feb Mar Apr May
1 01 ALi Rahmanzai $ 300 $ 5,000 $ 200 $ 4,000 $ 500 $ 2,000
2 02 Arrash Tekkin $ 300
3 03 Arrghwan Ahmadzai $ 300
4 04 Ayoob Ansari $ 250
5 05 Khan Gul Ahmadzai $ 250 Jan Feb Mar Apr May
6 06 Adil Delawar $ 250 $ 6,543 $ 1,213 $ 300 $ 1,230 $ 2,000
7 07 Ibrahim Sadat $ 500
8 08 Jalil Sabawoon $ 500
9 09 Jalal Ahmad $ 500
10 010 Abed Ahmadzai $ 400 Jan Feb Mar Apr May
11 011 Malwand Afghan $ 400 $ 555 $ 400 $ 200 $ 300 $ 120
12 012 Hashmat Ehsas $ 400
13 013 Ali zada Noor $ 750
14 014 Romal Wali $ 750
15 015 Nooryalay Hootak $ 800 Jan Feb Mar Apr May
16 016 Samim Kohestani $ 900 $ 7,550 $ 4,000 $ 5,000 $ 8,000 $ 12,000
Average $ 472
Minimum $ 250
Maximum $ 900
Employees 16
Total $ 7,550
Montly Report 20
$- $10,000 $20,000 $30,000 $40,000
Average Minimum Maximum Employees Total Average
2022
Jun Jul Aug Sep Oct Nov Dec
$ 12,000 $ 3,200 $ 4,300 $ 78,887 $ 2,334 $ 9,876 $ 7,500
Total $ 129,797
2023
Jun Jul Aug Sep Oct Nov Dec
$ 2,400 $ 2,600 $ 4,600 $ 9,876 $ 8,787 $ 6,787 $ 5,000
Total $ 51,336
2024
Jun Jul Aug Sep Oct Nov Dec
$ 878 $ 600 $ 9,898 $ 500 $ 300 $ 100 $ 3,400
Total $ 17,251
2025
Jun Jul Aug Sep Oct Nov Dec
$ 7,550 $ 7,000 $ 7,550 $ 7,550 $ 3,600 $ 7,550 $ 12,000
Total $ 89,350
Total 2025 $ 89,350 Grand Total $ 287,734
Max $ 12,000 Max 129797
Min $ 3,600 Min 17251
Average $ 7,446 Average 68470.75
2025 Report
$30,000 $40,000 $50,000 $60,000 $70,000 $80,000 $90,000 $100,000
Average Min Max Total 2025
PPC-Kitchen Montly Price list
Monthly Report No Item Price Amount
1 Beans AFN 90 30
2 Potato AFN 80 30
3 sugar AFN 55 4
4 salt AFN 55 4
5 tomato AFN 30 5
6 Chicken AFN 100 4
7 Meet AFN 200 4
8 Eggs AFN 150 6
9 Salad AFN 20 30
0 0 00 00 00 00 00
N 00 ,0 ,0 ,0 ,0 ,0 10 Water AFN 80 30
AF 5, 10 15 20 25 30
N
AF AF
N
AF
N
AF
N
AF
N
AF
N 11 Tea AFN 80 30
12 Oil AFN 90 30
Maximum Minimum Average Total
13 Gas AFN 200 60
ntly Price list
Tota Price Monthly Report
AFN 2,700
AFN 2,400
AFN 220
AFN 220
AFN 150
AFN 400
AFN 800
AFN 900 Total Average Minimum Maximum
AFN 600
AFN 2,400 Monthly Report
AFN 2,400 Total AFN 27,890
AFN 2,700 Average AFN 2,145
AFN 12,000 Minimum AFN 150
Maximum AFN 12,000
n n cell n n
I am Row cell
cell
cell
I am Row cell
cell
cell
I am Row cell
cell
I am Row cell
n n
cell
cell
R
File Home Insert Layout Farmula Data
Collaboration Protection View Pivot Power Querry
1 File
2 Templates
3 New
4 Open
5 save
6 save as
7 Print
8 protect
9 Info
Additon 5+5=10
Example
Num1
5
33
5656
Basic math operators
Cell1 + Cell 2 = Result Substraction 5-5=0 Divission x/x=x
Ecample Example
Num2 Result Num1 Num2 Result Num1 Num2 Result
5
66
44
Multiplication x*x=x
Example
Num1 Num2 Result
The table below lists keyboard shortcuts for some of the most common Excel tasks
Task Shortcut
Close a workbook Ctrl+W
Open a workbook Ctrl+O
Save a workbook Ctrl+S
Copy Ctrl+C
Cut Ctrl+X
Paste Ctrl+V
Undo Ctrl+Z
Remove cell contents Delete
Bold Ctrl+B
Expand or collapse the
Ctrl+F1
ribbon
Move up one cell in the
Up arrow key
worksheet
Move down one cell in the
Down arrow key
worksheet
Move one cell left in the
Left arrow key
worksheet
Move one cell right in the
Right arrow key
worksheet
Move to the edge of the
Ctrl+Arrow key
current data region in the
(e.g. Ctrl+Down
worksheet (e.g. end of
arrow)
column)
Move to the last cell on a
Ctrl+End
worksheet
Move to the beginning of a
Ctrl+Home
worksheet
Extend the selection of
cells to the last used cell
Ctrl+Shift+End
on a worksheet (lower
right corner)
Move to the cell in the
upper-left corner of the Home+Scroll
window (when Scroll Lock Lock
is On)
Move one screen down in
Page Down
a worksheet
Move one screen up in a
Page Up
worksheet
Move one screen to the
Alt+Page Down
right in a worksheet
Move one screen to the
Alt+Page Up
left in a worksheet
Move to the next sheet in
Ctrl+Page Down
a workbook
Move to the previous
Ctrl+Page Up
sheet in a workbook
Edit the active cell and put
the cursor at the end of F2
the cell’s contents
Ctrl+Shift+colon
Enter the current time
(:)
Ctrl+semi-colon
Enter the current date
(;)
common Excel tasks.
