How to Calculate MIN and MAX in Excel ?
MIN and MAX. In this Excel tutorial, we walk step-by-step through finding the smallest and largest values in a range, and then level up with a pro shortcut for copying formulas like a true spreadsheet wizard.
📚 Index
00:00 – Completing Excel’s “Big Five” Functions: What’s left to learn
00:19 – Introducing MIN and MAX: Finding values that are too small or too big
00:25 – How to find the smallest value using the MIN function
00:44 – Writing the MIN formula and selecting a cell range
01:03 – Interpreting MIN results and identifying lowest sales
01:10 – Finding the largest value with the MAX function
01:26 – Writing the MAX formula and identifying highest sales
01:44 – Copying formulas efficiently with Ctrl + D
02:07 – Verifying copied formulas and checking results
02:25 – Why Ctrl + D is a must-know Excel shortcut
✨ What You’ll Learn
How MIN helps you spot the lowest values instantly
How MAX identifies the highest numbers in your data
A quick, powerful trick to copy formulas down multiple rows
Practical examples using real cell ranges
🔧 Whether you're reviewing sales data or analyzing trends, mastering these two functions completes your essential Excel toolkit!