Free Excel Invoice Template – send as PDF
with No Comments

Free Excel Invoice Template – send as PDF from Outook The Norwegian free Excel Invoice template is rather popular, so I decided to translate it to English. Free to use:) You can use The Excel invoice template for free – and … Read More

Maintain Outlook contact list in Excel 2013/16
with No Comments

In this example we edit the Outlook contact list in Excel. Download the workbook here: 

Create a series of workdays, excluding weekends and holidays
with No Comments

Create a series of workdays In this example I have written the function NextWorkDay that returns the next workday after the date you pass to the function. It makes it easy to create a series of dates that includes only workdays. … Read More

Using a scrollbar in the sheet
with No Comments

Using a scrollbar in Excel In this example we demonstrate the use of a scrollbar to scroll through a list of names. We also use IFERROR(), VLOOKUP(), MATCH(), COUNTIF() and a bit of VBA coding.   Download the workbook here: 

Using MATCH() and HLOOKUP() to find table value
with No Comments

This example is actually about trees. Håkon wants to input one value from a row and one from the heading and get the table value from the cell where the row and column intersect. So, like in the image, if he … Read More

Create tasks in Outlook from Excel
with No Comments

This example create tasks in Outlook from Excel. The routine separates the tasks depending of the Windows username so you only transfer your own tasks. The tasks are marked after they are transferred so they won’t be duplicated. Here you will … Read More

Using VLOOKUP() to combine information from different sheets
with No Comments

I often get questions about how to use IF() to solve problems. In many cases the solution is not using IF() at all, but VLOOKUP(). In this example we collect information about employees from two different sheets using VLOOKUP(). Download … Read More