Best Excel Tutorial

The Largest Excel Knowledge Base ✅ The Best Place to Learn Excel Online ❤️

How to Use the Search Function in Excel

In this Excel tutorial I show how to use the Search function in Excel. It’s a tool for finding text within other text, and while it might seem a little intimidating at first, it’s actually quite straightforward once you get the hang of it. Think of it as a more powerful version of Ctrl+F. While that shortcut helps you find things visually, Search lets you use those findings in formulas, opening up a whole new level of possibilities.

Read More

How to use the lookup function in Excel

In this Excel tutorial I show how to use the lookup function in Excel. The lookup function helps you to find specific data quickly. This function comes in two forms: vector and array. The vector form searches a single row or column. The array form searches multiple rows and columns. Both forms are useful for different tasks. Below is a step-by-step guide to using lookup effectively.

Read More