Free Microsoft Office Training and Tutorial Resources


February 19, 2011

Excel Functions and Formulas Help and Support

Here are 7 Excel resources that explain and show how to use Excel Functions, Formulas, and some Advances Techniques. One of Excel’s most useful features is that it allows users to create custom formulas to perform calculations on their data. Excel also contains built-in formulas called functions that make it easy to perform common calculations on data.

How to Create Custom User Defined Excel Functions
Excel allows you to create custom functions, called “User Defined Functions” (UDF’s) that can be used the same way you would use SUM() or some other built-in Excel function.

Excel Functions
Provides information and examples of Excel spreadsheet functions and topics such as graphs, testing and short cuts.
  - Functions and Calculations
- IF, conditions and selecting
- Formatting Cells and Values
- Dates and Times
- Sharing data with other programs
- Reference, Input and Navigation
- Auditing and other stuff

Excel Function Reference
Create your own worksheet functions
Go with the cash flow: Calculate NPV and IRR in Excel
List of worksheet functions (by category)
Using worksheet functions for quality control
Creating custom functions
Database Functions
Date and Time Functions
Engineering Functions
External Functions
Financial Functions
Information Functions
Logical Functions
Lookup Functions
Math Functions
Statistical Functions
Text and Data Functions
Basic Excel
Built-In Functions
Text Functions
Logical Functions
Information Functions
Date & Time Functions
Lookup & Reference Functions
Math Functions
Statistical Functions
Database Functions
Financial Functions
Engineering Functions
Excel Vlookup Tutorial
Pivot Table Tutorial
Excel Formulas
Array Formulas
Tips & Tricks
Common Excel Errors
Excel Templates
Excel Macros
Excel VBA Tutorial

Excel Formulas and Functions
Here you will find step by step tutorials, tips and shortcuts on how to use formulas and the common and less common functions available in Excel. Excel 2010 Functions (48)
IF Functions (14)
Count Functions (8)
Date Functions (15)
Logical Functions (4)
Math Functions (13)
Text Functions (10)
Rounding Number Functions (9)
Excel 2003 Functions (20)
Random Number Functions (3)
Trig Functions (5)
Lookup Functions (11)
Statistical Functions (14)
Information Functions (5)
Engineering Functions (1)
Financial Functions (2)
Basic Excel 2007 Spreadsheet Tutorial
This tutorial covers creating a basic spreadsheet in Excel 2007. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.

Excel Function Dictionary
This Excel Function Dictionary contains over 150 examples of functions.

Advanced excel tips, Excel tools, Excel reporting applications, and Excel add-ins.

Tags for this post>> | |

No Comments »

No comments yet.

RSS feed for comments on this post.

Leave a comment

You must be logged in to post a comment.