M5- Excel Training

Create a Formula Using 3D References

cell F4 =SUM( click january worksheet press and hold shift then click march click F4 enter on formula bar

Group and Ungroup Worksheets

click January worsksheet press and hold the shift key until march click F16 editing autosum f4:f15 enter in formula bar right click january ungroup sheets click february

Fill a Series Based on a Linear Trend

click and drag B5:F5 editing fill series trend ok

Create a Formula Using a Worksheet Reference

click cell B8 type = click B6 type - view window switch windows GIC expenses click B14 press enter

Explode a 3-D Pie Chart Slice

click orange slice right click format data point point explosion: 30 and enter close

Add Chart Element at a Specific Location

click the chart click the chart elements button data labels arrow outside end

Insert a New Worksheet

+at bottom of excel window

Copy and Paste Using a Paste Option

B9:B11 clipboard copy click C9 clipboard paste paste values & numbers

Enter a Series of Values Using Autofill

cell A4 type January lower right corner and drag down

Create a Formula Using the TODAY Function

cell B2 formulas function library date & time today ok

Create a Formula Using the ROUND Fuction

cell B6 type =ROUND click J6 ,0) enter button in formula bar

Resize a Chart

click the chart press and hold lower right corner until within cell D20

Set Custom Worksheet Margins

page layout margins custom margins left:0.5 right:0.5 ok

Insert a Header using Header & Footer Elements

page layout in status bar click add header design header & footer elements sheet name click right header section Last Viewed_ Header &footer elements current date click A4

Move a Chart on a Worksheet

position mouse ove chart press andn hold left mouse button and drag the chart so upper left corner is over cell F1

Copy a Worksheet

right click income statement sheet move or copy create a copy move to end ok

Enter Text in a Header

view page layout click add header type Confidential click A4