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/excel-business-functions-functions-everyone-should-know-excel-essentials-training

Menard Excel Training Courses https://courses.chrismenardtraining.com/

Recent Excel Videos
Title Watch Url
Excel PivotTable - Percentage of Row Totals and Five Awesome Tips https://www.youtube.com/watch?v=6v2aj1GE3fg
Excel Tiered Conditional Formatting with Dates using functions AND and TODAY https://www.youtube.com/watch?v=uCmmuScmxQk
Teams Online Course Promotion https://www.youtube.com/watch?v=KJgxWOqdZHE
Excel PivotTables Percentages - Grand Total, Parent Row Total, and Parent Total https://www.youtube.com/watch?v=KSaM8JAVnSo
Excel - Turn on Multiple Filters in a PivotTable - Allow multiple filters per field Setting https://www.youtube.com/watch?v=qFnHYfn6yNs
Excel - Filter a PivotTable with a Timeline https://www.youtube.com/watch?v=FIKqdUC92f4
PivotTables - 3 Annoying Things FIXED! https://www.youtube.com/watch?v=U746wZCrq6k
Excel Add Sparklines on a Separate Worksheet https://www.youtube.com/watch?v=163KG9gImPI
Excel Chart Maps used with the Geography Data Type https://www.youtube.com/watch?v=iQvapFfAoEE
Excel Concatenate Text and Dates with the TEXT function https://www.youtube.com/watch?v=hljBSRnKZp4
Tasks by Planner in Teams - Recurring Tasks - New Feature https://www.youtube.com/watch?v=byV-dsWCrU0
Excel - Insert a blank row after every row or every Nth row https://www.youtube.com/watch?v=FPu3nJBwgEc

#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!

Видео Excel Business Functions - Functions everyone should know - Excel Essentials Training канала Chris Menard