-
When Text-to-Columns Fails
A functional Van der Merwe story In a column of full names containing first, middle and last names, Excel’s Text-To-Columnsfunction…
-
Excel Tip: Forms & Protection
Sometimes we need to create form-like sheets in a workbook, for example where user input is wanted. Presenting a plain…
-
Shading alternate rows or columns
This is simple enough, but surprisingly few people know how easy it is. It’s a question I get a lot.…
-
CV TIPS from an HR Professional
Gone are the days when CVs require a complete listing of every goal achieved during your lifetime or a two…
-
Latest KRS Club Tip – Expiry of old products
When opening a gym, a number of products are created to facilitate the members. Over time, gyms often end up…
-
Excel: TLC – A Question of Design
TLC? No, we haven’t gone soft. We mean Top Left Corner. Excel 2010 finally became insert-smart a while back. Cutting…
-
Introduction to Entity Framework Power Tools
So, you’ve got a legacy system and have decided to make the smart move of embracing domain driven design. To…
-
Error Zen
Excel errors (like weeds in a garden) can be useful as indicators. Using IFERROR can mask most ugly horrors preceded…
-
Excel: Search and Replace
Spaces are disallowed in Excel named ranges. If someone, say “Fred Nerx”, wants to name a range after himself, and…
-
Excel: Named Constants
Using Name Manager (on Formulas Tab in Excel 2007/2010) or Name, Define on Insert menu (Excel 21003), add its name…
