Chester Tugwell's PowerPoint Presentations

History of the Internet

Overview of the History of the Internet - or the beginnings of. Alternative to the bullet point style of slide.

Views: 3048 Subscribers: 0 Presentations: 3

Creating a User Defined Function in Exce

Excel includes many different functions that help you complete calculations, but have you ever wished for a function that that doesn’t ..

Views: 107 Subscribers: 0 Presentations: 16

For-Next Looping in Excel VBA

For next looping works by using a counter variable. The counter states the number of times a specific piece of code should be repeated..

Views: 142 Subscribers: 0 Presentations: 9

USING MESSAGE BOXES AND INPUT BOXES IN E

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 ..

Views: 238 Subscribers: 0 Presentations: 7

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 ..

Views: 312 Subscribers: 0 Presentations: 10

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 c..

Views: 576 Subscribers: 0 Presentations: 12

Excel Mortgage Payment Formula

In Excel it is possible to calculate monthly repayments on a mortgage by using the PMT function.

Views: 261 Subscribers: 0 Presentations: 14

Creating a Lookup with Microsoft Access

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 Exce..

Views: 261 Subscribers: 0 Presentations: 13

Including Parameter Values in a Report

This tutorial is for Access users who have some experience with parameter queries and creating their own reports. A parameter prompts ..

Views: 39 Subscribers: 0 Presentations: 10

EXCEL COUNTIF WITH MULTIPLE CRITERIA

Views: 996 Subscribers: 0 Presentations: 8