Excel and Google Sheets are fundamental programs used for calculations and organizing data, which are efficient tools for improving work accuracy. Today, Classwin has compiled 5 simple Excel formulas that you can immediately apply.
1. Finding the sum of numbers
Use the SUM function to find the sum of numbers. For example, =SUM(B3:B10) sums the numbers in cells B3 to B10.
2. Finding the average
Use the AVERAGE function to find the average of numbers. For example, =AVERAGE(A2:A10) calculates the average of the numbers in cells A2 to A10.
3. Inserting today’s date:
Simply type =TODAY() and press Enter. The current date will be based on the settings in the Control Panel.
4. Converting numbers to words
Type the formula BAHTTEXT(number). For example, BAHTTEXT(A7) converts the displayed amount to words.
5. Entering a date (year, month, day)
For example, =DATE(2025,10,01) displays the date according to the settings in the Control Panel.
These 5 Excel formulas are just the beginning. There are many more formulas and functions that make work much more convenient, especially for calculations. Rest assured, office workers like us can save a lot of time using them.
