Articles

 

Mircosoft Excel Functions Part 1

Let's face it Excel can be....intimidating. Formulas and functions whisper secrets in a language only data wizards understand. In today's reading, we'll be going over some functions that I tend to use the most while spending time working on Excel creating spreadsheets for staffing plans, payroll/billing, inventory/asset tracking, and more. 


=SUM: The King of Calculations

Do you need to add a bunch of numbers? Ditch the calculator; the SUM function(a built-in summation feature employed to automatically add up the numbers in a few clicks to save time.) is your new best friend. Simply enter =SUM(range), "range" can be your cells (i.e. A1:A10) or even another formula. BAM! Instantaneous totals, no finger cramping required!


=AVERAGE: The Middle Ground

Lost in a sea of numbers? AVERAGE function(will return the average value of a given series of numbers in Excel) finds the center point to that sea. Use =AVERAGE(range) to instantly get the meaning of your data.


=COUNT

The =COUNT(range)(Count all cells with numbers) or =COUNTA(range)(Count cells that are not empty) function is like a headcounter on a field trip, tallying up the number of cells that meet your criteria, saving you from tediously counting manually. 


=PRODUCT: Multiplying Mayhem

The =PRODUCT(range) function specializing in.... multiplication! It's a great shortcut for figuring out grand totals by multiplying a bunch of numbers together. It saves you from some finger cramps and calculator errors.


Bonus - Keyboard Shortcuts




@Aaron Warnagiris | Date: 12/4/2023