formula
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula

Formula

resolvedResolved · Low Priority · Version 2007

replyReply Mon 15 Jun 2009, 16:08Delegate sara said...

sara has attended:
Excel Intermediate course

Formula

What is a good course/resource for using formuala

For upcoming training course dates see: Pricing & availability

replyReply Tue 16 Jun 2009, 10:38Trainer Amanda said...

RE: Formula

Hello Sara

Thank you for your question and welcome to the forum.

It depends what specifically you are interested in learning with regard to formulas.

On Excel Introduction, we look at being able to create formulas to add, subtract, multiply, divide, and some functions (AVERAGE, MIN, MAX, COUNT, SUM).

On Advanced level, we look at logical functions (nested IF, OR, AND), some lookup functions (VLOOKUP, HLOOKUP), and database functions.

Otherwise looking up a particular function in Excel Help can be of assistance; you can ask us questions here through the forum; or the Microsoft web site has tutorials on various aspects of Excel.

I hope this helps.

Kind regards
Amanda

 

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard