The Only TOP 10 Microsoft Excel Functions You Need as a Beginner.

Опубликовано: 15 Январь 2024
на канале: Open Training Camp

655

In this video, we go through 10 of the most popular Excel functions ranked by popularity. These functions are the most searched, and the most liked functions by most Excel users worldwide. When you master these functions, you will truly become awesome at Excel.

00:00 Introduction to Microsoft Excel’s Top 10 Ranked Functions

00:36 Rank # 10: How to use the INDEX function in Excel.
The INDEX function returns a value or the reference to a value from within a table or range.

03:38 Bonus Tip: How to Perform Two-way Lookups in Excel using the INDEX-MATCH functions.
With a combination of the INDEX and MATCH functions, we can perform two-way lookups.

05:34 Rank # 9: How to use the FIND function in Excel.
The FIND function in Excel is used to locate a set of text strings within a given text string and returns the number of the starting position of the text string counting from the first character of the text string.

08:51 Rank # 8: How to use the DAYS function in Excel.
The DAYS function returns the number of days between two dates.

10:41 Rank # 7: How to use the DATE function in Excel.
You can use Excel's DATE function when you need to take three separate values and combine them to form a date in other words, the DATE function returns the sequential serial number that represents a particular date.

14:07 Bonus Tip: How to use the DATEDIF function in Excel.
The DATEDIF function Calculates the number of days, months, or years between two dates. This is one of the functions in Excel that do not display function arguments, so you have to be careful while using it.

16:11 Rank # 6: How to use the CHOOSE function in Excel.
The CHOOSE function uses index numbers to return a value from the list of value arguments and then it chooses to select one of up to 254 values based on the index number. For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as an INDEX number argument.

23:10 Rank # 5: How to use the SUMIF and SUMIFS functions in Excel.
The SUMIF and SUMIFS functions return a total sum of values when a condition is met for example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5, you can use the SUMIF.

26:17 Rnak # 4: How to use the IF function in Excel
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. For example, an IF statement can have two results. The first result is if your comparison is True, and the second is if your comparison is False.

29:31 Rank # 3: How to use the VLOOKUP function in Excel
VLOOKUP is a popular Excel function that looks up for a value and returns another value to a cell if it finds a match. It comes with two range lookups and that is the EXACT match as well as the APPROXIMATE match.

35:49 Rank # 2: How to use the AVERAGE function in Excel
The average function is used to return an arithmetic mean of numbers and if you want to calculate the weighted average then you use the SUMPRODUCT function.

37:53 Rank # 1: How to use the SUM function in Excel
This function sums up numbers in a given range and it’s the most popular used function in the world by most Excel users.

To learn more about dashboard report designing in Excel, watch the video I created on Designing a Sales Dashboard Report using the link below.
• How to Design a Dashboard Report in E...

If you want to join our WhatsApp Group for Free Weekly Microsoft Excel Live Classes, please click the link below. https://chat.whatsapp.com/ImFuaZLuOZ8...

TikTok for daily tips and tricks on how to advance your Excel skills. https://vm.tiktok.com/ZMFcXgkJY

Thank you for watching! If you would like to contact me for training your team. My WhatsApp number: is +256 773 523 826 Email Address: is [email protected]