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.
Table of contents
- Copyright
- Introduction
- Meet Microsoft Excel
- Create the Workbook File
-
Build the Budget Worksheet
- Name the Sheet
- Understand References
- Enter Information
- Activate a Cell
- Enter Row Headings
- Enter Column Headings
- Make a Column Wider
- Enter Values
- Calculate a Difference
- Calculate a Percent Diff
- Sum Some Values
- Calculate Net Income
- Copy Formulas
- Copy and Paste
- Use the Fill Handle
- Change a Value
- Extra Bits
- Duplicate the Worksheet
- Consolidate the Results
- Format Worksheets
- Add a Chart
- Print Your Work
Product information
- Title: Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide
- Author(s):
- Release date: October 2004
- Publisher(s): Peachpit Press
- ISBN: 9780321255822
You might also like
book
Creating Spreadsheets and Charts in Microsoft Office Excel 2007 for Windows: Visual QuickProject Guide
Microsoft Excel is the world's most-popular spreadsheet program--used by schools, offices, and home users. In Excel …
book
Special Edition Using® Microsoft® Office Excel 2003
Does your life play out in a spreadsheet? Are numbers in columns and rows what make …
book
Special Edition Using Microsoft® Office Excel® 2007
Special Edition Using Microsoft Office Excel 2007 will ease the upgrade path to the lastest version …
book
IBM z15 (8561) Technical Guide
This IBM® Redbooks® publication describes the features and functions the latest member of the IBM Z® …