Blog & Excel Tips

We are busy working on our 2018 World Cup in Russia- Spreadsheet for running an office pool or sweepstake. The version will be available moments after the draw on the 1st December 2017 in Moscow. Although we plan to add more features, it will be be able to...

How can we reverse data in Excel so that it goes from the oldest to the newest. The method used depends on what you are reversing and whether you want it to repeat the process or whether it is a once off.

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.

What is after Excel Level 3? Have you attended Excel 3 (advanced) and been disappointed. You know there is more within Excel but the course didn't show it...

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.

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.

How to construct the international packing code in Excel where character 4 plus character 1 (in that order) is the week number and character 2 is the weekday

As you work through a spreadsheet you may delete a number of cells and then want Excel to shift all the cells up so that there are no blanks.