## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

## Book Description

Excel can be daunting: that empty grid just stares you in the face when you start the program, challenging you to fill in the cells with thenumbers you need to crunch. How do you start? What do you do?

Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide answers those questions and puts you on the straight track to getting the job done. This new addition to Peachpit's Visual QuickProject Guide series by Excel guru Maria Langer uses full color screen shots and numbered steps to walk you through the process of creating an Excel workbook file. You'll learn how to build a worksheet from the ground up, enter data, write formulas, and copy cell contents. You'll then see how to duplicate and modify worksheets to fine-tune them for your needs. The project's steps also include creating a consolidation worksheet, formatting all worksheets, creating a colorful pie chart, and setting options for printing your work. There's no time wasted in this book; Maria shows you the quickest and most efficient way to perform each task and doesn't waste paper with lengthy explanations or alternative methods. This slim book is all you'll need to get started creating spreadsheets and charts with Excel.

2. Introduction
3. Meet Microsoft Excel
1. Learn the Lingo
2. Mouse Around
3. Start or Open Excel
4. Look at Excel (Windows)
5. Look at Excel (Mac OS)
6. Change the View
7. Scroll a Window
9. Use a Toolbar
10. Have a Dialog
11. Exit or Quit Excel
12. Extra Bits
4. Create the Workbook File
1. Create the Workbook
2. Set View Options (Windows)
3. Set View Prefs (Mac OS)
4. Save the Workbook (Windows)
5. Save the Workbook (Mac OS)
6. Extra Bits
5. Build the Budget Worksheet
1. Name the Sheet
2. Understand References
3. Enter Information
4. Activate a Cell
7. Make a Column Wider
8. Enter Values
9. Calculate a Difference
10. Calculate a Percent Diff
11. Sum Some Values
12. Calculate Net Income
13. Copy Formulas
14. Copy and Paste
15. Use the Fill Handle
16. Change a Value
17. Extra Bits
6. Duplicate the Worksheet
1. Copy the Sheet
2. Clear the Values
3. Insert a Row
4. Delete a Row
5. Enter New Values
6. Extra Bits
7. Consolidate the Results
1. Prepare the Sheet
2. Consolidate
3. Check the Consolidation
4. Calculate Percent Diff
5. Extra Bits
8. Format Worksheets
1. Set Font Formatting
2. Format Values
3. Format Percentages
4. Set Column Widths
5. Set Alignment
6. Indent Text
9. Change Text Color
10. Format all Worksheets
11. Extra Bits
1. Hide a Row
2. Start the Chart Wizard
3. Select a Chart Type
4. Check the Source Data
5. Set Chart Options
6. Set the Chart Location
7. Explode a Pie
9. Extra Bits