excel final project – day 4 notes due tomorrow!!!!!! you should have 4 reports done by the end of...
Post on 31-Dec-2015
212 Views
Preview:
TRANSCRIPT
Excel Final Project – Day 4 Notes
DUE TOMORROW!!!!!! You should have 4 reports done by the
end of today…
Formatting
All numbers should be in comma style Borders should be nicely done. All spreadsheets should be centered on the
page.
Formatting
If you use pivot tables… Many of the titles have “Sum of” – Change the
names of the columns to better reflect the contents.
If Excel complains about duplicate names, Add a space to the end of the name.
Your charts may have buttons on them – Right click on any of the buttons and select “Hide all Fields setting buttons”
Formatting
If you use SubTotals… The word “Total” is included on all lines. Remove
it! Replace (CNTL-H), Find What “ Total”, Replace
with left blank and Replace All.
Charts are difficult with Subtotals. Pivot tables work better for the charts
2
3
4
5
This is what the reports should look like!
1
top related