98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-training - Excel training
microsoft-excel-training - Excel training
Resolved · 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Cycling through Absoulte cell referencesIf 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. |