MeadInKent
| Links | Books | 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.


Maths

Functions and Calculations



# #N/A & Abs Age And Array Audit Autosum Average bandings BestFit Book Buttons Cell Chart Choose 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 Formats Formatting Forms Formula Frequency FV Graphs Grouping Hyperlinks If Indirect Int Interest Investment IRR IsError Isna Large Listbox Lists Loans Logical Lookup Macro Mapping Match Max Mean Median Mid Min Mod Mode Normal Now NPV Numbers

Conditional

IF, conditions and selecting


Format

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

Dates and Times




For a detailed index click here

Sharing

Sharing data with other programs




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


Reference

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


Charts

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.

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?

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

Click here for Feedback form


feedback

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
Planner
Office Leave database

an Access database for
recording and displaying
planned staff absences

[View details]


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