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