Posts

Showing posts from August 23, 2022

Basic Excel Functions Everybody Should Know

Image
   Microsoft Excel contains many functions that allow you to perform tasks without a calculator or extra work. But if you’re unfamiliar with formulas, it can feel intimidating. Here, we’ve listed 12 simple but useful Excel functions to get you started.   Table of Contents 1. Add Numbers in Cells: SUM 2. Average Numbers in Cells: AVERAGE 3. Find the High or Low Value: MIN and MAX 4. Find the Middle Value: MEDIAN 5. Count Cells Containing Numbers: COUNT 6. Insert the Current Date and Time: NOW 7. Round to a Certain Number of Digits: ROUND 8. Truncate a Number by Removing the Fraction: TRUNC 9. Find the Product by Multiplying Cells: PRODUCT 10. Use the Reference Number of a Given Cell: COLUMN and ROW 11. Eliminate White Space: TRIM 12. Count the Number of Characters in a String: LEN 1. Add Numbers in Cells: SUM One of the most basic things you can do with numbers is add them. Using the SUM function in Excel you can add numbers in cells. The syntax is SUM(value1, value2...