| Links | Alphabetical Index | Excel 2010 Screen Layout |

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

# #N/A & Abs Address Age And Array Audit Autosum Average bandings BestFit Book Bullet Points Buttons Cell Chart Choose Code ColorIndex Colours ColourScales Combo Comments Compound Concatenate Confidence Configure Count CountA Criteria CSV DataBars Date Datediff Daverage Defaults Dependents Design DropDown Dsum Errors Filename Filtering Financial Find Footers Formats Formatting Forms Formula Frequency FV Graphs Grouping Hyperlinks If Index Indirect Int Interest Investment IRR IsError Isna Large Listbox Lists Loans Logical Lookup Macro Mapping Match Max Mean Median Mid Min Mod Mode NamedRanges Normal Now NPV Numbers



IF, conditions and selecting



Formatting Cells and Values

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

Support this site on Facebook

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



Dates and Times

For a detailed index click here



Sharing data with other programs

Offset Or Organisation Output Parsing PDF Personal PMT PowerPoint Precedents Principal Probability Projects Protection R1C1 Rand Rank Repayments Rept Ribbons Risk search Series sheet Shortcuts Slicers Small Statistics Styles Sum SumProduct Testing Text Time TrafficLights Transpose True Validation Value VBA VLookUp Waterfall WebApp Webpages Weekday Weighted Word Xlstart



Reference, Input and Navigation

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

For a detailed index click here

Help moving to new version of Excel



Auditing, charts and other stuff

download this free reference page with examples of 8 Excel functions

Download this PDF file onto your PC and keep it as a handy reference

The Excel Functions guide (available for sale) has been updated to Excel 2010

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.

Excel 2010 Get this information as a document
accompanied by Excel worksheets
Document is in PDF format Click here for details about obtaining this
file. It has been rewritten for Excel 2010.

Was this Excel information useful?

Do you have any comments or was there something else you were looking for?

Click here for Feedback form


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

If you are seeking help with an Excel query, visit my discussion board

Office Leave database

an Access database for
recording and displaying
planned staff absences

[View details]

South Downs Lodges

Luxury holiday lodges in the South Downs National Park

file: excel.htm Open MeadInKent Facebook page page last updated Apr15 CMIDX S0 P1 X Successfully checked as 'HTML 4.01 Transitional' working to protect human rights worldwide