Tag: Microsoft

Excel – Using VLOOKUP to compare two lists

Years ago the Training and Development manager of a large organisation invited me to spend some time in their Accounts department in order to observe how the Accounts team dealt with their day-to-day tasks. My job was to report on any process that could be improved using Microsoft® Excel.

I’ll always remember asking one of the team (a “just-out-of-school” new recruit) what he was working on after I’d observed him sitting with a red biro and a ruler, diligently drawing red lines on 2 separate sheets of paper. It turned out he was trying to reconcile a customer’s account. Read more

Outlook 2013 and 2016 – why are my folders no longer alphabetically listed?

Outlook 2013 now offers you the freedom of reordering your folders in any order that takes your fancy.

Now you can simply drag your most used folders to the top of the folder list.  No more fussing around placing numbers and zz’s  in front of folder names. Read more