Nederlands
Identifying range names in Excel
Suppose you define 2 range names ‘CAR’ and ‘BIKE. There are two possibilities to identify range names. First option: Use Formulas tab, Data Manager, select Use in Formula, Paste Names […]
Formatting text
You can have parts of text constants in one cell be different sizes, fonts, color, by selecting the text and using the tools from the formatting features in the Home […]
PowerPoint: Searching for good quality stock photos
Good quality photos are essential for an impressive PowerPoint presentation (or an ecommerce store). Presentations containing photos that have been taken by yourself, make the story personal. If you do […]
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 […]