Essential

Features
Sort and Filter
Advanced Filter
Paste - Transpose
Name June July Total
Fauzia Amin 73.00 50.00 123.00
Iqramul Haque 121.00 77.00 198.00
Fauzia Amin 167.00 140.00 307.00
Isharul Islam 167.00 107.00 274.00
Mosharraf Hossain 75.00 109.00 184.00

Name Fauzia Amin Iqramul Haque Fauzia Amin Isharul Islam Mosharraf Hossain
June 73.00 121.00 167.00 167.00 75.00
July 50.00 77.00 140.00 107.00 109.00
Total 123.00 198.00 307.00 274.00 184.00

There is too many Paste tools such Value Paste, Formula Paste, Paste as Picture, Paste as source link etc.
One sample example has shown here.
Copy & Paste Visible Cells Only
CONVERTING TEXT TO COLUMNS

Date
Mon, 21, November, 2016
Tue_22_April_2017
Wed, 23; May; 2019 Week Day Month Year
Mon 21 November 2016
Thu, 24, March, 2018
Tue 22 April 2017
Wed 23 May 2019
Thu 24 March 2018
Freeze Panes
Split View
Spelling Check
Comments
SUM & SUM IF logical function
SUM SUMIF SUMIFS
10 Red 10 Blue Red 10
1 Green 1 Yellow Green 1
7 Red 7 Blue Red 7
20 Green 20 Blue Green 20
3 Red 3 Yellow Red 3

Sum Sum of Green Sum of Blue & Green

41 21 20

Count Sum Average

AVERAGE
COUNT
There is too many IF Logical Functions tools such as Count IF,

SUM
Countif Sumif Averageif
Average IF etc. One sample example has shown here.
Countifs Sumifs Averageifs
Dated IF
=DATEDIF(Start Date,End Date,Interval) Where Interval is:

Start Date 01-01-17 “m” Months

End Date 19-09-23 “d” Days
“y” Years
Day Difference 2452 “ym” Months Excluding Years
Month Difference 80 “yd” Days Excluding Years
Year Difference 6 “md” Days Excluding Years And Months
 IF Logical Functions
CL Status Numer of Number of
Due CL Status Asper EBL Remarks
checking as per Installment Installment Paid
HYC 27.40 28 (0.60) UC UC Match

Number of
CL Status
Numer of Installment Installment Due CL Status
checking as
P aid
per HYC
=IF(I7=1,DATEDIF(J7,J2,"d")/30,DATEDIF(J7,J2,"d")/30/4) 28 -0.6 =IF(D12>30,"BL",IF(D12>18,"DF",IF(D12>6,"SS",I
Number of
Asper
Installment Due CL Status Remarks
EBL
Paid
7,J2,"d")/30/4) 28 -0.6 =IF(D12>30,"BL",IF(D12>18,"DF",IF(D12>6,"SS",IF(D12>2,"SM","UC")))) UC =IF(F12=E12,"Match","Not Match")

There is too many IF Logical Functions tools such as IFs, Nested IF, IF Or, IF And, IF Error etc.
One sample example has shown here.
Vertical Lookup (VLookup)
Source Sheet
ID Name Designation Email
Finding Name using ID value
650 Ohidul Ambia Choudhury Senior Manager ohidul@example.com
905 Md. Bodiuzzaman Manager zaman@example.com
409 Md Sukkur Ali Manager ali@example.com
289 Chayon Biswas Assistant Manager biswas@example.com
997 Md. Masud Rana Management Trainee rana@example.com
ID Name Email
502 Md. Masudur Rahman Senior Executive Officer rahman@example.com 142 Farhin Amin Samy farhin@example.com
911 Jamir Uddin Rashel Junior Officer rashel@example.com 502 Md. Masudur Rahman rahman@example.c
814 Zahangir Alam Senior Executive Officer zahangir@example.com
837 Md. Khairul Bashar bashar@example.co
208 Md. Shariful Islam Junior Officer shariful@example.com
995 Md. Maidul Islam Senior Officer maidul@example.com 650 Ohidul Ambia Choudhury ohidul@example.co
281 Kamrul Hashan Senior Officer kamrul@example.com 281 Kamrul Hashan kamrul@example.co
142 Farhin Amin Samy Officer farhin@example.com
584 Seraj Ullah Assistant Officer seraj@example.com
837 Md. Khairul Bashar Assistant Officer bashar@example.com

Other Data Finding Methods:

Horizontal Lookup (Hlookup), Index and Match Function, XLookup, DGET Function.
 Pivot Table
Example: Prepare Fixed Asset Schedule

Cost as per Asset register Depreciation as per Asset register

Sum of Opening Sum of Sum of Cost Sum of Opening Sum of Depreciation Sum of Sum of Accum. Sum of Written
Particulars Sum of Transfer
Cost Balance Acquisition Balance 2022 Depreciation during the year Dep.transfer Depreciaton 2022 down value
Electric Equipments 725,705,746.00 189,935,774.36 (31,132,327.00) 884,509,193.36 (368,584,209.43) (235,640,446.44) 28,208,948.92 (576,015,706.95) 308,493,486.41
21503100 684,141,057.00 186,204,000.00 - 870,345,057.00 (338,276,832.22) (228,350,742.41) - (566,627,574.63) 303,717,482.37
21881100 41,564,689.00 3,731,774.36 (31,132,327.00) 14,164,136.36 (30,307,377.21) (7,289,704.03) 28,208,948.92 (9,388,132.32) 4,776,004.04

Furniture & Fixture 28,607,759.00 2,860,776.10 - 31,468,535.10 (15,456,820.36) (4,610,857.57) - (20,067,677.93) 11,400,857.17
21380100 12,763,123.00 2,255,176.10 - 15,018,299.10 (2,388,427.74) (2,736,813.22) - (5,125,240.96) 9,893,058.14
21502100 4,525,651.00 605,600.00 - 5,131,251.00 (2,000,813.64) (1,653,161.44) - (3,653,975.08) 1,477,275.92
21880100 11,318,985.00 - - 11,318,985.00 (11,067,578.98) (220,882.91) - (11,288,461.89) 30,523.11

Hardware 12,762,509.00 7,535,570.00 31,132,327.00 51,430,406.00 (3,096,607.39) (7,009,187.47) (28,208,948.92) (38,314,743.78) 13,115,662.22
21810100 12,762,509.00 7,535,570.00 31,132,327.00 51,430,406.00 (3,096,607.39) (7,009,187.47) (28,208,948.92) (38,314,743.78) 13,115,662.22

Softwares 11,869,600.88 75,000.00 - 11,944,600.88 (538,445.00) (2,804,975.74) - (3,343,420.74) 8,601,180.14

20400100 10,282,216.00 75,000.00 - 10,357,216.00 (538,445.00) (2,804,975.74) - (3,343,420.74) 7,013,795.26
28131051 1,587,384.88 - - 1,587,384.88 - - - - 1,587,384.88

Grand Total 778,945,614.88 200,407,120.46 - 979,352,735.34 (387,676,082.18) (250,065,467.22) - (637,741,549.40) 341,611,185.94

Source File: Client’s Asset Register

Client's Asset
Register
Conditional Formatting
Finding
Duplicate Value

There is too many conditional formatting tools. One sample example has shown here.
Data Validation
Group/Ungroup
Charts
Slicer and Timeline
Page Layout