microsoft-excel-training - excel training

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

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

microsoft-excel-training - Excel training

resolvedResolved · Low Priority · Version 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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips


Server loaded in 0.09 secs.