Blog - Excel Doctor

Part Two: How to create a SEARCHABLE drop-down list in Microsoft Excel

Part Two: How to create a SEARCHABLE drop-down list in Microsoft Excel Making a dynamic drop-down list is one thing. But if the list contains hundreds of thousands of items […]

Part One: How to make a DYNAMIC drop-down list in Microsoft Excel

Part One: How to make a DYNAMIC drop-down list in Microsoft Excel A drop-down list is an excellent powerful way to give multiple predefined options to your users and restrict […]

Excel SEARCH functions: Part Two: The SEARCH function

Excel SEARCH functions: Part Two: The SEARCH function As explained in part one, the SEARCH function in Excel is very similar to FIND because it also returns the location of […]

Excel SEARCH functions: Part One: The FIND function

Excel SEARCH functions: Part One: The FIND function Excel provides a wide variety of text and numeric data processing tools. Two popular search functions are FIND and SEARCH. These are […]

Functions that make your file DYNAMIC: Part Two: The OFFSET function

Functions that make your file DYNAMIC: Part Two: The OFFSET function In the first part we discussed the INDIRECT function. In this second part, we discuss the OFFSET function. The […]

Functions that make your file DYNAMIC: Part One: The INDIRECT function

Functions that make your file DYNAMIC: Part One: The INDIRECT function This blog is divided into two parts. First, we discuss the indirect function. Not many people use this formula. […]

The Excel Table Lookup Functions – Part TWO

The Excel Table Lookup Functions – Part TWO Microsoft recently introduced a new feature for Excel called XLOOKUP Function. This is a new addition in lookup family after HLOOKUP and […]

The Excel Table Lookup Functions – Part One

The Excel Table Lookup Functions – Part One One of the most useful functions available in Excel is the LOOKUP function. This allows you to take any value entered, find […]

How to Create Pivot Tables in Microsoft Excel

Sometimes, when you hear about Microsoft Excel, it seems too good to be true. Doesn’t it? You simply enter some number with a formula, and basically anything that you would […]

New Note Feature in Office 365 Excel

Microsoft is always trying to make its products be more than a match for its competitors. Microsoft office is a pioneer in productivity niche and still remains the leader. […]