In the tutorial I am going to show you how to include a date-picker in your Excel worksheet. The tutorial includes two ways of achieving this. Click here to download the featured file. The first method uses Sam Radakovitz’s Date Picker add-in which is compatible with all versions of Excel. Sam is a Microsoft… Read More »Install In-Cell Date Picker Calendar in Excel – Calendar Drop-down in Column
In this series of videos I demonstrate how to create an automated invoice template in Excel. You can download the invoice template using the form below. This automated invoice template includes VBA macros that will save the invoice either as an Excel workbook or a pdf. The template will also email invoices to your customers… Read More »How to Create an Automated Invoice Template in Excel
OK so you want to automatically date and time stamp your data entry in Microsoft Excel. In this video I will demonstrate two methods you can use to achieve this. The first method uses a formula and the second method uses a VBA macro. Click here to download the featured file Formula Method Watch… Read More »Automatically Date and Time Stamp Data Entry in Excel