Learning, Simplified
Learn Excel with real-world examples.
Every Excel function explained with practical, real-world examples for Finance, Sales, HR, Operations, and Data analytics.
Popular Functions
=AVERAGE()
The AVERAGE function finds the average of a group of numbers. It adds all the numbers together and divides the total by the number of values.
Think of sharing a restaurant bill equally with friends. Excel adds up the total cost of the food and tells you exactly how much each person needs to pay.
=COUNTIFS()
The COUNTIFS function counts the number of cells in a range that meet a single condition or multiple conditions.
Think of COUNTIFS like a security guard checking two IDs: a person is only counted if they are over 18 AND on the guest list.
=FILTER()
The Excel FILTER function shows only the rows that match one or more conditions. Instead of showing all your data, it displays just the information you want.
Imagine shopping online for shoes. You select filters like "Size 10" and "Black", and the website instantly shows only the shoes that match your choices and hides all the other shoes. The FILTER function works the same way in Excel.
=IF()
The IF function in Excel is used to run a logical test and show one result if the test is true, and a different result if the test is false.
=MATCH()
The Excel MATCH function searches for a specific item in a list and tells you exactly what position it is in. It gives you a number (like row 3 or column 5) instead of the actual data.
Imagine looking at a top 100 music chart. You do not want to hear the song; you just want to know its position number on the trending list. The MATCH function gives you that exact number.
=SUMIFS()
The Excel SUMIFS function adds numbers together only if they meet one or more specific conditions that you set.
Think of a bouncer at a club. The bouncer only lets people inside if they meet specific conditions, like wearing a certain colour shirt or being on the guest list.
=TEXT()
The Excel TEXT function converts a numerical value into a text string and applies a specific display format (like a date, currency, or percentage) to it.
=TODAY()
The Excel TODAY function automatically shows the current date in your spreadsheet. Every time you open the file, the date will update to match the current date on your computer calendar.
Imagine looking at a digital clock on your wall. You never have to manually adjust it; it just automatically knows what day it is. The TODAY function works the exact same way for your spreadsheet.