Basic Function


There are over 300 functions that Excel can do. The most popular ones are: Sum, Average, Max, min and count. The next most popular are IF and Vlookup.

All functions begin with   =

They follow a structure = function name (range)

The sum function is =sum (a1:a12)

If the sum is going to be positioned under a range of figures ensure you select all the figures first, then press Autosum. This will esure you don’t ¬†miss out on any figures from the list.

Related Topics

Basic Functions – YouTube

Basic Formulas- YouTube

Basic Formulas

Shortcut key for Autosum

 

Advertisements

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au
This entry was posted in Excel. 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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s