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

introduction excel training - excel

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

introduction excel training - Excel

ResolvedVersion Standard

Alicja has attended:
Excel Intermediate course

Excel

How to create the formulae?

RE: excel

always start a formula with =
click on the cells you want to use in the formula (like A15).
separate the cells with operators (like +, -, *, / )

eg:

= A1+A2+A3
= Sum(A1:A3)

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.