Excel Business Functions - Functions everyone should know - Excel Essentials Training
Did you know that there are over 500 Functions in Excel? In this short video, part of my Excel Essentials Training Course, we look at the seven business functions I use all the time, and these functions should be used by every Excel user. Functions with one argument shown include SUM, AVERAGE, MAX MIN, and MEDIAN. Functions with two arguments shown include LARGE and SMALL. We will look at the difference between a formula, and a function.
Chapters/Bookmarks
0:00 Intro
0:33 Enter Data
2:35 Function vs. Formula
4:17 Start using Functions
4:45 SUM Function
5:47 AVERAGE Function
7:10 MAX Function
8:23 MIN Function
9:00 LARGE Function
13:03 SMALL Function
14:08 MEDIAN Function
Functions with one argument
SUM
AVERAGE
MAX
MIN
MEDIAN
Functions with two arguments
LARGE
SMALL
Both functions have two arguments since they have one comma.
Chris Menard's Blog Post https://chrismenardtraining.com/post/...
Menard Excel Training Courses https://courses.chrismenardtraining.com/
Recent Excel Videos
Title Watch Url
Excel PivotTable - Percentage of Row Totals and Five Awesome Tips • Excel PivotTable - Percentage of Row Total...
Excel Tiered Conditional Formatting with Dates using functions AND and TODAY • Excel Tiered Conditional Formatting with D...
Teams Online Course Promotion • Teams Online Course Promotion
Excel PivotTables Percentages - Grand Total, Parent Row Total, and Parent Total • Excel PivotTables Percentages - Grand Tota...
Excel - Turn on Multiple Filters in a PivotTable - Allow multiple filters per field Setting • Excel - Turn on Multiple Filters in a Pivo...
Excel - Filter a PivotTable with a Timeline • Excel - Filter a PivotTable with a Timeline
PivotTables - 3 Annoying Things FIXED! • PivotTables - 3 Annoying Things FIXED!
Excel Add Sparklines on a Separate Worksheet • Excel Add Sparklines on a Separate Worksheet
Excel Chart Maps used with the Geography Data Type • Excel Chart Maps used with the Geography D...
Excel Concatenate Text and Dates with the TEXT function • Excel Concatenate Text and Dates with the ...
Tasks by Planner in Teams - Recurring Tasks - New Feature • Tasks by Planner in Teams - Recurring Task...
Excel - Insert a blank row after every row or every Nth row • Excel - Insert a blank row after every row...
#msexcel #chrismenardtraining #chrismenard #exceltraining
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!