| Added: Jul 10, 2009 | |
| By: chestert | |
| Views: 30 | |
| 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. |
| Added: Jul 10, 2009 | |
| By: chestert | |
| Views: 82 | |
| For next looping works by using a counter variable. The counter states the number of times a specific piece of code should be repeated. |
| Added: Jul 10, 2009 | |
| By: chestert | |
| Views: 37 | |
| If you want to make your macros interactive then one way of doing this is to introduce message boxes and input boxes. These allow you to display messages that require a response or ask the user to enter values before the macro can proceed any further. |
| Added: Jul 03, 2009 | |
| By: chestert | |
| Views: 80 | |
| 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. |
| Added: Jul 03, 2009 | |
| By: chestert | |
| Views: 168 | |
| 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. |
| Added: Jun 22, 2009 | |
| By: chestert | |
| Views: 119 | |
| In Excel it is possible to calculate monthly repayments on a mortgage by using the PMT function. |
| Added: Jun 22, 2009 | |
| By: chestert | |
| Views: 79 | |
| In this tutorial we will lookup values in one table based on values in another. You may be familiar with the lookup concept if in Excel you have used VLookup or HLookup functions. I am going to use a really simple example to get you started. |
| Added: Jun 21, 2009 | |
| By: chestert | |
| Views: 13 | |
| This tutorial is for Access users who have some experience with parameter queries and creating their own reports. A parameter prompts the end user to enter criteria each time the query is run. This tutorial shows you how to display the parameter value that is given by the end user in the heading of a report based on the query. |
| Added: Jun 04, 2009 | |
| By: chestert | |
| Views: 429 | |
| Added: Jun 01, 2009 | |
| By: chestert | |
| Views: 263 | |
| Overview of the History of the Internet - or the beginnings of. Alternative to the bullet point style of slide. |