Excel Forum
Similar Content
Scale Data for Printing in Excel - Fit more onto a Printed Page
Tutorial: This tip shows you how to fit more Excel data onto a page for printing. This does not chan...
Print Comments in Excel
Tutorial: How to print the comments in a worksheet when you print from Excel. This includes how to p...
Error bars in Charts in Excel
Tutorial: How to add, manage, and remove error bars in charts in Excel. Error bars allow you to sh...

Office 2010 Class #19: Excel Intro Project 02: Formulas, Charts, Page Setup Net Income

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm

Topics Covered in Video:
1. Stylistic Formatting
a. Fill Color
b. Font Color
c. Borders
2. Format Cells Dialog box Number tab
a. Number Formatting
i. Currency
3. Delete
a. For deleting cell content, use Delete key, not Right-click Delete.
4. Formulas with:
a. Formula Inputs are in An assumption Table
b. Equal Sign
c. Relative Cell References
d. Absolute Cell References
e. * for Multiplying
5. Charts
a. Insert Ribbon tab, Charts Group
b. Column Chart
c. Add Chart Title: Chart Tools Layout Ribbon tab, Labels group, Chart Title button
6. The beauty of Excel: When formula and chart inputs are changed, everything updates in the workbook!!!
7. Page Setup:
a. Keyboard = Alt, P, S, P
b. We looked at:
i. Page tab
ii. Margins tab
iii. Header/Footer tab

Got a Question? Ask it Here in the Forum.