This page lists some example Excel demonstrations. These are
presented in the form of an Excel spreadsheet, containing instructions as well
as a working example. Please feel
free to help yourself.
Many of these examples use macros, so you will need to ensure you
have set your Excel macro security level sufficiently low to allow them to run.
All workbooks are now zipped for faster downloading. If you
are not using Windows XP you might need to download the free version ofWinzip or
similar free software.
Advanced Filter
feature How to automate the Advanced Filter in
Excel using VBA.
Click here to download the
example (52Kb)
Calendar example This example demonstrates a calendar control. Created by
Phil Johnson for OzGrid Forum:
Click here
to download the example (82Kb)
CHOOSE()
function Selects a value or action from a list of values
(maximum of 29) based on a selection in another cell. In this example the choice
is made from a dropdown list using Data Validation.
Click here to download the example (29Kb)
Concatenation function The use of concatenation (&) to
combine the contents of two or more cells into another cell.
Click here to download the example (27Kb)
Contacts form example How a simple form can be created on a
spreadsheet to save data to another sheet that acts as a database.
Click here to download the example
(43Kb)
Database form
example Example of a simple database setup. Read
update
Click here
to download
the example (48Kb)
Data Validation
Dropdown List feature Use of Data Validation to create a
drop down list to ease data entry.
Click here to download the
example (34Kb)
This example demonstrates how to use a label on UserForm to
simulate a hyperlink
The form example provides a quick and easy way to let users email you directly
from the userform. This code allows users to click on a label that
contains an email address, and open the default email application and fills in
the email address All the user have to do is fill in the subject, and
the comments they wish to send.
The other labels act s hyperlinks to websites.Click here to download the
example (34Kb)
Message box feature
Use of a simple message box to get
a user's instructions.
Click here to download the example (38Kb)
Nesting example
The use of multiple functions in one
formula, i.e. "nesting". In this example we use the IF() function which can be
nested up to seven instances. The second example shows how to create a SUM()
function dependent on the contents of another cell.
Click here to download the
example (25Kb)
Populate UserForm example Call a UserForm by using the
Before_DoubleClick event, and to use the UserForm_Initialise event to populate
TextBoxes.
Click here to download the
example (47Kb).
This example demonstrates how to add data to a Protected
WorkBook without worrying about removing then adding protection. Click
here to download the
example (47Kb). (44Kb)
SUMIF()
and COUNTIF() functions This example demonstrates the use of the two functions SUMIF()
and COUNTIF() functions.
Click here to download the
example (47Kb).
Summary example
This example demonstrates how to create a summary sheet of data
from a number of sheets.
Click here to download the example
(55Kb)
Table of Contents example Create a Table of contents sheet of
the worksheets in a workbook. See also the free addin version
here
Click here to download the example (27Kb)
Timesheet example A simple spreadsheet which can be used
to calculate an employee's working hours.
Click here to download the
example (25Kb)
VLOOKUP()
function How to use the VLOOKUP() function to
populate a form with information from a database, which can be on a different
Worksheet within the same Workbook.
Click here to download the example (25Kb)
Advanced Filter
feature
Calendar example