How to Use SMALL & LARGE Functions in Excel | Step by Step Practical Exercise
Struggling to find the smallest and largest values in your Excel data? In this hands-on lesson from **Digital World Tech Academy**, you'll learn how to use two powerful Excel functions—**SMALL() and LARGE()**—to quickly identify ranked values in a dataset and apply them to practical data analysis.
Whether you're a beginner learning data analysis or looking to improve your Excel skills, this tutorial breaks everything down in a **simple, clear, and easy-to-follow way**, with a practical exercise performed directly on an Excel spreadsheet.
🔑 *What You'll Learn in This Video:*
✅ How the *SMALL() function* works and how to use it to find the smallest, second smallest, third smallest, and other ranked values in a dataset
✅ How the *LARGE() function* works and how to identify the largest, second largest, third largest, and other ranked values in your data
✅ How to correctly use the *SMALL() and LARGE() syntax* in Excel
✅ The difference between the SMALL and LARGE functions and when to use each one
✅ A *step-by-step practical exercise* using spreadsheet data to demonstrate how these Excel functions work in a real data-analysis situation
✅ How SMALL and LARGE functions can help you analyze and interpret numerical datasets more efficiently
💡 *Why This Matters:*
The ability to identify the smallest, largest, and ranked values in a dataset is an important part of working with data in Excel. The *SMALL() and LARGE() functions* can be useful when analyzing student results, sales data, financial records, performance reports, business data, and other numerical datasets.
Understanding these functions can help you reduce manual calculations, work more efficiently with spreadsheets, and build a stronger foundation in **Excel and data analysis**.
👨🏫 *About Digital World Tech Academy*
At *Digital World Tech Academy**, we simplify complex technology and data-analysis topics into **practical, easy-to-understand lessons* for students and learners at different skill levels.
Our goal is to equip learners with practical, hands-on, and *job-ready technology and data-analysis skills* that can be applied in real-world situations.
📌 *Don't Forget To:*
👍 *LIKE* this video if you found it helpful.
🔔 *SUBSCRIBE* to Digital World Tech Academy and turn on the notification bell so you never miss our next Excel and Data Analysis lesson.
💬 *COMMENT* below if you have any questions or let us know which Excel or data-analysis topic you'd like us to teach next.
🎓 *Want to Learn More? Register Now!*
Take your *Excel and data-analysis skills* to the next level with our full online and physical classes at **Digital World Tech Academy**.
📞 *Call or WhatsApp:* +2349069601693
👉 *Register today and start your journey toward becoming a confident, job-ready data analyst!*
#Excel #ExcelTutorial #DataAnalysis #ExcelFunctions #MicrosoftExcel #ExcelForBeginners #DigitalWorldTechAcademy