formulars

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Formulars

resolvedResolved · Low Priority · Version 2003

Alisa has attended:
Excel Intermediate course

Formulars

Excellent course, informative however for my role I will be need a good knowledge of formulars any tips on getting farmilar.

RE: Formulars

Hi Alisa

Thank you for your question; and welcome to the forum.

A couple of things you may find useful:

- Formulas always start with an equals sign =

- You can get a total for a row or column of numbers by clicking in the next available blank cell in the row or column; and using Alt + = to enter the Sum function. You will need to check that Excel has selected all the cells you wish to add together; if not you can use your mouse to select the cells that contain the values to be added.

- There is a key located to the left of the 1 key and below the Esc key on your keyboard which is called the pipe key - it has three different symbols on it. If you hold down the Ctrl key and press the pipe key at the same time, you will be able to see where all the formulas are in a spreadsheet. Use the same two keys to change your spreadsheet view back to normal.

I hope you find these useful.
Amanda


 

Excel tip:

The Easiest and Quickest Way to use Autosum in Excel 2010

Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature.

1) Go to the bottom of the column of data.

2) Shortcut click in the column then Ctrl + down arrow

3) Use Alt + = for Autosum and press the enter key to complete.

View all Excel hints and tips


Server loaded in 0.08 secs.