| Links | Books | Using Excel at work | Alphabetical Index |  

Excel Functions: Contents

These pages contain information and examples of Excel spreadsheet functions and topics such as graphs, testing and short cuts.


Functions and Calculations

Sum, Average and Count - the most basic functions
Financial functions such as compound interest and loan repayments
A detailed example of calculating loan repayments
Investment appraisal using NPV and IRR
Weighted averages and assessing risk
Frequency an array function to count ranges of values
Statistics 1 - Averages, standard deviation and confidence
Statistics 2 - Quartiles and interquartile range

For a detailed index click here

IF, conditions and selecting

DSum, DAverage - database functions
VLookup, Match to find a particular value within a range of data
If, And, Or, Rank, Errors - logical functions and preventing errors
A macro and an Advanced Filter to select records
Selecting values from drop down lists and boxes
Conditional SUM formulae and a costing model using SumProduct
Using Arrays to apply selective rules to functions

Custom internet search for Excel click here
(powered by Google)

Formatting Cells and Values

Text, Abs and formatting cells with numbers or dates
Conditional formatting of cells (2 pages)
A VB function to return cell colors and sum the values of cells which are a particular color
Protecting cells and worksheets
Displaying number values as words
Extracting text from strings and phrases
Configuring the appearance of Excel at startup
A VBA function to display cell contents

Help and tips using 
    Microsoft Excel spreadsheet functions
Colin discovers that wielding the sword of truth and shield of fair play can be difficult while wearing the helmet of hypocrisy

Dates and Times

Date and Time functions and calculations
Calculating hours worked and shift enhancements
An office holiday leave planner (SumProduct + Conditional Formatting)
Calculating the difference between two Dates

Sharing data with other programs

A simple macro to create web pages from Excel
A more complicated macro to make formatted web pages from Excel
Creating XML data files from Excel and Access using VBA
Linking tables and charts in a Word document to an Excel spreadsheet
Using an Excel table as a data source for a Word Mail Merge *New*
Using PowerPoint to display information from Excel (2 pages)
Basic examples of displaying XML / XSL files in a web browser
An example of a cascading style sheet for web page design
Linking Access database data to an Excel worksheet *New*
Using a macro to export text files from tables and forms

The MeadInKent website had over ONE MILLION visitors last year. Thankyou for your support.

Reference, Input and Navigation

Graphs which grow dynamically to include new data
Hyperlink navigation and buttons on worksheets
Two forms to input data and add it to a list using VBA macros
Using Indirect to enter cell references as text within formulas
A VB function to return worksheet names *New*
Using Offset and Choose to select particular cells or values

Your Excel questions on my Discussion Board. Can you offer help and solutions to other users?

Auditing and other stuff

Audit tools for checking a spreadsheet
Testing and mapping spreadsheets to check for design errors
Adding a macro to a toolbar and keyboard shortcuts
Improving your graphs using pictures and better axis labels
Tips for accountants on using Excel

Information about Excel 2007 click here


This site contains many useful examples of Excel functions and other information. Add it to your bookmarks or favorites now so that you can easily return here again.

Get this information as a document
accompanied by Excel worksheets
Document is in PDF format Click here for details about
obtaining this file

View a selection of recommended books about Excel. These can be ordered from either Amazon.com or Amazon.co.uk.

Was this Excel information useful?

Sorry - this form is temporarily unavailable. It should get fixed very soon

Send me an email



Please note that I cannot reply if you
don't tell me your email address!

If you are seeking help with an Excel query,
have you visited my new discussion board?


Office
Leave
Planner

an Access database for
recording and displaying
planned staff absences

[View details]


file: excel.htm page last updated Oct08 working to protect human rights worldwide