Excel Mac: How To Use Averages For Decision Making

Channel:
United Kingdom Hmran UK (Hmran)
Subscribers:
22,100
Published on ● Video Link: https://www.youtube.com/watch?v=XGaEQ28BQBQ


Duration: 4:27
30 views
0

In this video I have demonstrated how to use easily compute the averages and make informed decision. You can do this manually if the list of the data is short as this example by comparing the values with the averages and make your decision. However, if the list (dataset) was long you can use the IF formula to examine each observation with the averages as I did. Then you can use conditional formatting to highlight those identified as “Good Deal”. Producing a column chart helps identify the best deal as well as using the INDEX function.


Hope you enjoy the video :)



Other Videos By Hmran UK (Hmran)


2020-06-25Minecraft: Took Me 4 Years To Complete All Survival World Buildings
2020-06-04Minecraft: The Ultimate Weapon For Destroying The Ender Dragon
2020-06-03Minecraft: Draining The Ocean Quickly & Building Football Pitch
2020-06-02Pokemon Go: Gaining Over 1 Million XP
2020-06-01Minecraft: Blowing Up Ender Dragon With TNT
2020-05-29Nespresso: Quality Time Making Coffee
2020-05-23Excel Mac: How to Monitor Electricty and Gas Usage
2020-05-22Pokemon Go: Best PVP Fighters And Movesets For Great League
2020-05-22Excel Mac: How To Add Changeable Parameters
2020-05-22Excel Mac: How To Create Home Learning Math For Kids Automatically
2020-05-22Excel Mac: How To Use Averages For Decision Making
2020-05-21Excel Mac: How To Use Sparkline to Summarise Multiple Data Variables
2020-05-21Excel Mac: How To Use Checkbox To Control Data In A Chart
2020-05-21Excel Mac: How to Extract Information From Data Using Pie Chart
2020-04-05Pokemon Go: Will Shiny Pokemon Be Registered In The Dex If It Ran Away?
2019-12-21Tutorial: The Optimal Way To Clean Up PokemonGo Storage
2019-10-15Sneaky Sasquatch Hidden Treasure Box in Maze Map
2019-08-24One Of The Most Rewarding Views in Monaco, Monte Carlo Casino
2019-08-24A Lizard Invaded My Rental Audi Car in Nice/Monaco
2019-08-24The Art of Making Bubbles by Dolphins
2019-07-06Leamington Spa Classic Cars Show Event


Tags:
iMovie
excel
mac
macbook
macbookpro
macos
macossierra
sierra
excel2016
2016
howto
how
to
timeline
project
data
automatically
automatic
auto
label
sort
milestones
stages
template
charts
chart
graph
pie
information
useful
study
easy
simple
checkbox
line
true
false
informed
average
mean
median
if
function