top of page



Understanding VLOOKUP and HLOOKUP: The Dynamic Duo of Excel Lookups
Click to Watch Walk-Through Takeaways: This video provides a tutorial on the VLOOKUP function in Excel, which is used for finding specific data within large datasets. It explains that VLOOKUP stands for vertical lookup and works by searching the first column of a table for a specified value and returning a value from the same row in a designated column. The video breaks down the syntax of the function, detailing the purpose of each argument: the lookup value, the table array,
Sep 14, 20255 min read


🔢Ranking Data with Excel
Click to Watch Walk-Through Key Takeaways This video demonstrates how to use the RANK function in Microsoft Excel. The video focuses on...
May 28, 20254 min read
bottom of page