April 2024

Microsoft Excel Lookup Function – VLOOKUP, HLOOKUP AND XLOOKUP

April 14, 2024

Sample Dataset: Consider a dataset with student information where we want to retrieve the grades based on the student’s ID using lookup/vlookup. Here’s a simplified version of the data: Student ID Name Grade 101 Alice A 102 Bob B 103 Charlie C 104 David B 105 Emma A VLOOKUP Example: Suppose we want to find […]

Microsoft Excel Lookup Function – VLOOKUP, HLOOKUP AND XLOOKUP Read More »

Learn Microsoft Excel Function SUMIFS()

April 13, 2024

The SUMIFS function in Excel allows you to sum values based on multiple criteria. It’s particularly useful when you need to filter data based on certain conditions and then sum the corresponding values. Here’s the syntax of the SUMIFS function: Here’s an example to illustrate how SUMIFS works: Let’s say you have a dataset with

Learn Microsoft Excel Function SUMIFS() Read More »

× Chat