microsoft-excel-training - excel training
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 » microsoft-excel-training - Excel training

microsoft-excel-training - Excel training

resolvedResolved · Low Priority · Version Standard

replyReply Wed 14 Nov 2007, 16:16Delegate Anastasia said...

Anastasia has attended:
Excel Introduction course

Excel training

How do you know which function to use?

For upcoming training course dates see: Pricing & availability

replyReply Wed 14 Nov 2007, 16:52Delegate Paul said...

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

replyReply Wed 14 Nov 2007, 18:26Delegate Riaan said...

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:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

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