Useful Site of Excel Functions

Excel is such a useful program but many people using it only scratch the surface. One of the most useful things about Excel are its functions for doing calculations. They are basically built in formula to work out everything from adding up a row or column to calculating loan or mortgage repayments. There are many scientific, engineering, financial and other functions too. One you get the hang of a few you will see how they work.

You can also use functions to look up text or values and return information. You can also cleverly combine functions known as nesting. Check out the combining HLOOKUP and VLOOKUP tutorial.

Aside from doing calculations they can display the current date or even extract text from part of a string of characters.

Here is a page of Excel tutorials I have created that have a number of functions including getting started with functions in both Windows and a Mac. I’m adding more to it regularly http://www.jargonfreehelp.com/excel-functions/

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, Excel Functions, Microsoft Office and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s