Copy Meeting Attendees from Outlook

**Download this tutorial (zipped PDF)** I’ve been asked how to copy the names of meeting attendees from Outlook to Excel. This Focus Guide uses a "quick and dirty method" that requires no VBA and therefore, is unable to distinguish between invitees who...

Calculate End Date of Loan or Project

**Download this tutorial (zipped PDF)** Not only do spreadsheets excel at calculating numbers, they can also calculate dates too. Imagine that you have taken out a 6-month loan and you want to know when it will be paid off (assuming that it is 6 calendar months from...

Split List into Multiple Columns

**Download this tutorial (zipped PDF)** A common problem that many people have is where they have a spreadsheet where data in a single column needs to be split into multiple columns. For example a list of employee names where both First Name and Surname are in the...