Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
Make the cursor start on the same cell in each sheet August 24, 2017
How to make the cursor start on the same cell in each sheet to avoid you scrolling up, down, left and right each time you are looking for a particular cell.
Export folder and subfolder list to excel August 22, 2017
In a previous post we showed how to export a list of filenames from a folder into Excel. But what can you do to export a list of files AND subfolders AND files in these subfolders into an Excel list? Here we are going to use a small trick in PowerQuery to export folder and subfolder list to Excel.
How to export file names from a folder to excel August 22, 2017
Excel is extremely useful in working with lists, and in the modern world, a common listing requirement is the list of files and folders within a folder. So whether you are just indexing a folder for backup purposes, or you need the names of files in the folder to find missing items, Excel can easily do it. In this post a method of how to export file names from a folder to excel.
Turn off automatic date and time grouping in Excel Pivot Tables August 12, 2017
You may have noticed that in the newer versions of Excel, if you drag a date or time into the columns or rows, it automatically groups them into months or hours respectively. You can stop this happening either with a quick (but repetitive fix) or a permanent fix.
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."