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...
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...
Print Comments in Excel
Tutorial: How to print the comments in a worksheet when you print from Excel. This includes how to p...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.