Chester Tugwell - Articles

Creating a User Defined Function in Excel using VBA
Excel includes many different functions that help you complete calculations, but have you ever wished for a function that that doesn’t exist in Excel? If you have, this tutorial will explain how to create a function DIY style. Read
By: Chester Tugwell | 10/07/2009 | Software

Excel SUMIFS Function
SUMIFS is a function that first appears in Excel 2007. You may have previously used SUMIF to sum up values in a list based on criteria in another column. SUMIFS works the same way but allows you to use multiple criteria either in different columns or the same column. Read
By: Chester Tugwell | 03/07/2009 | Software

Create A Drop Down List In Excel
Drop down lists are a great addition to a worksheet making data more efficient and also restricting what values can be entered into a cell. Read
By: Chester Tugwell | 03/07/2009 | Software

Excel Mortgage Payment Formula
A walk through of the PMT function in Excel which allows you to calculate monthly repayments on a mortgage. Read
By: Chester Tugwell | 22/06/2009 | Software

Tips and Tricks for working with Microsoft Access Reports
A selection of tips and tricks for working in Microsoft Access reports. Not all tips will be relevant to all versions of Access Read
By: Chester Tugwell | 18/06/2009 | Databases

Tips and Tricks for working with Microsoft Access Forms
A selection of tips for working with Microsoft Access Forms. Not all tips will be relevant to all versions of Access. Read
By: Chester Tugwell | 18/06/2009 | Databases

Tips and Tricks for working with Microsoft Access Queries
A collection of tips and tricks that you may find useful when working with queries in Microsoft Access. Read
By: Chester Tugwell | 18/06/2009 | Databases

Displaying Parameter Values in a Microsoft Access Report
If you use parameter queries and then base reports on those queries this tutorial is for you. It will show you to display the parameter values that have been used in the heading of the report. Read
By: Chester Tugwell | 18/06/2009 | Databases

Using a lookup table in Microsoft Access
This exercise shows you how to use lookup tables in Microsoft Access. If you have used lookup functions in Excel, this works in a similar way. Read
By: Chester Tugwell | 18/06/2009 | Databases

Microsoft Access Tips and Tricks for Creating Tables
A miscellaneous selection of tips and tricks for working with Microsoft Access tables. Read
By: Chester Tugwell | 13/06/2009 | Databases