Troubleshoot VLOOKUP() Formula - The Common Mistakes

Troubleshoot VLOOKUP() Formula – The Common Mistakes

Excel’s VLOOKUP() function is notorious for returning wrong results, but it’s not the function, it’s the way you’re using it! Excel’s VLOOKUP() function finds a matching value in a list. It’s one of Excel’s most popular and misunderstood functions. It’s possible to enter the correct formula and still get the wrong result but with just […]

Read More
Learn to use Vlookup in Excel

Learn to use Vlookup in Excel

Vlookup is one of the most popular look up functions in Excel. When you need to extract data from a table based on a particular value, you can use Vlookup to do that.

Read More
10 Top Excel Keyboard Shortcuts

The 10 most useful Excel keyboard shortcuts

The 10 most useful Excel keyboard shortcuts Why complicate your spreadsheet life with a bunch of tricks you’ll never use? These 10 shortcuts will expedite the Excel tasks you perform every day. It’s great to know the resources are out there. But on a practical level, mastering 10 genuinely useful shortcuts will get you a […]

Read More
Learn to use appropriate Cell Reference in Excel Formulas

Learn to use appropriate “Cell Reference” in Excel Formulas

Learn to use appropriate “Cell Reference” in Excel Formulas >> Relative Cell Reference ================= Cell Reference changes with formula being copied and pasted in other cells >> Default cell references in a spreadsheet are relative, which change when copied and pasted. eg; E8, E9, E10, etc >> Obsolete Cell Reference ================= Cell Reference does NOT […]

Read More
Combine Text in Cells

Combine Text in Cells (Concatenate)

Combine Text in Cells Here’s another little-known feature available in Excel that I bet you’ll find various uses for. It is the ability to combine text from multiple cells into one cell. I use it frequently for joining text when I receive a file that has first and last names in separate columns. This feature […]

Read More