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

microsoft-excel-training - excel training

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-training - Excel training

microsoft-excel-training - Excel training

ResolvedVersion Standard

Anastasia has attended:
Excel Introduction course

Excel training

How do you know which function to use?

RE: Excel training

Experience! Hi Anastasia,

it's all about practising and knowing what the desired outcome is.

if you want to add up a list of numbers in column A, you would use the sum function, like this:

=sum(A1:A500)

have a look thru all the functions by pressing the little Fx button next to the formula bar at the top of your spreadsheet.

Good luck with Excel!

Paul

RE: Excel training

Hi

The best thing to do is spend as much time as possible trying out different functions. The more you practice and gain experience the easier it will become.
Also if you are going into finance, you will be spending most of your time on Excel..
Or if that fails, you can always travel again..

Riaan

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.