Microsoft Office Excel 2007 Just the Steps For Dummies

Just the steps you need to create spreadsheets, charts, and more
Simple steps…

…for great results

Create a Basic Chart
1.Select the data (sequential or non-sequential) you want to plot in the chart. See Figure 11-1 for an example of sequential data selected for a chart.

2.Press the F11 key. Excel immediately adds a new sheet called Chart 1 to your workbook with the data plotted into a column chart. Figure 11-2 shows you the various elements that can make up a chart

Some newer keyboards use a different function for the F11 key. If your F11 key does not produce a chart, use the Insert tab as explained in the next section.

Title: A descriptive name for the overall chart. By default, titles are not added in a basic chart.
X or Category axis: Column or row headings from your selected data, which Excel uses for Category axis names.
X Axis Title: A descriptive name for the Category axis. By default, a category label is not added in a basic chart.

Get ready to
– Enter data into a spreadsheet
– Build formulas and functions
– Format cells and add graphics
– Sort and analyzedata
– Create charts andPivotTables
– Blend Excel intoPowerPoint®

About the Author
Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988 that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane’s authoring experience includes over thirty five books on topics such as PC Security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money and Peachtree Accounting. Many of these titles have been translated into other languages such as French, Dutch, Bulgarian, Spanish and Greek. She has also developed and written numerous training manuals for her clients.

Diane and her husband enjoy spending their free time fishing, traveling and playing with their four grandsons and Little Joe, their Yorkshire Terrier.

Related Articles

Excel 2007 Just the Steps For Dummies

– Completely updated to reflect the many changes in the latest release of Excel, this helpful book presents readers with concise instructions for carrying out common Excel 2007 tasks
– An easy-to-navigate design features a two-column layout and is packed with step-by-step directions and illustrations that incorporate the notable changes to Excel 2007
– Readers can pick the task, find it fast, and get it done quickly, all while gaining a clear understanding of Excel 2007 enhancements, such as a new user interface, improved charting and PivotTable capabilities, and better data exchange with XML

Excel 2003 Just the Steps for Dummies

Easy steps for creating spreadsheets you can really use
Simple steps…

….for great results

Use AutoOutline

Choose Data Group and Outline AutoOutline. Figure 11-9 illustrates a worksheet with outline headings for both rows and columns. Row outline symbols are at the top of the worksheet.
AutoOutline works best if the worksheet has summary formulas that reference cells in the detail cells. The summary formulas must be adjacent to the detail.
To expand the outline, click the Show Detailbuttons to the left of the rows or above thecolumn headings. (See Figure 11-10.)
To collapse the outline, click the Hide buttonsto the left of the rows or above the columnheadings.
To remove the AutoOutline, choose Data Group and outline Clear Outline.

Get ready to

Format cells and data
Build formulas and functions
Save time with Excel tools
Add color graphics toyour spreadsheets
Analyze your data
Create charts and PivotTables

Peachtree For Dummies 3rd Edition

Not feeling too peachy about computerizing your accounting system? Relax! Peachtree For Dummies, 3rd Edition will show you how to set up your company in Peachtree and then use it to pay bills, invoice customers, pay employees, produce financial reports, and more. You’ll quickly discover how Peachtree can save you time, effort, and money so that you no longer have to do your accounting by hand or pay someone else to do it for you.
Publishing to coincide with the latest release of Peachtree, this third edition is revised to cover the newest updates and enhancements made to the most recent version of Peachtree. Veteran authors Elaine Marmel and Diane Koers break down the capabilities of Peachtree Premium Accounting, from building an effective chart of accounts, to customizing forms and modifying reports, to setting up default information that will save you time down the line.

You’ll also discover how to:
Work with purchase orders
Sell products and services
Generate invoices
Track project costs
Produce income statements
Back up and restore data
Balance accounts
Manage inventory
Handle customer prepayments
Pay for purchase orders with a credit card
Keep your account information safe

Packed with examples of everyday, real-life situations, Peachtree For Dummies, 3rd Edition is the reference you need so that you can put Peachtree to work for you and get the job done quickly and correctly.

Excel 2010 All-in-One for Dummies

A comprehensive, up-to-date, user-friendly guide to Excel 2010
Excel is the standard for spreadsheet applications and is used worldwide, but it’s not always user-friendly. That makes it a perfect For Dummies topic, and this handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more.

Eight minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.

Excel is the leading spreadsheet/data analysis software and is used throughout the world; the newest revision includes upgraded tools and a redesigned interface
For Dummies books are the bestselling guides to Excel, with more than three million copies sold
Excel 2010 All-in-One For Dummies covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions
Eight self-contained minibooks cover the basics, worksheet design, formulas and functions, worksheet collaboration, presenting data in charts and graphics, data management, data analysis, and creating macros with VBA.

Newcomers to Excel as well as veterans who just want to learn the latest version will find Excel 2010 All-in-One For Dummies has everything they need to know.

Excel 2010 for Dummies Quick Reference

Find the answers to your most important Excel questions with this reference
John Walkenbach’s name is synonymous with excellence in computer books that decipher complex technical topics. Known as “Mr. Spreadsheet,” Walkenbach—along with Excel expert Colin Banfield—answers your most common and important in this easy-to-understand reference.

You’ll learn how to open, save, protect, and recover workbook files; add, copy, and delete worksheets; enter and edit data and text; create formulas and functions; audit, format, and print; and more. Highly organized and free of unnecessary jargon, this essential reference allows you to find the answers you’re looking for quickly and easily.

Excel gurus Walkenbach and Banfield offer quick and easy answers to common Excel questions
Offers information in a highly organized, easy-to-understand format so you can find exactly what you need
Includes information on opening, saving, protecting and recovering workbook files; adding, copying, and deleting worksheets; entering and editing data and text; creating formulas and functions; auditing; formatting; printing; and more
Covers navigating the user interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and much more

Excel 2010 For Dummies Quick Reference enables you to spend more time working on your projects rather than trying to figure how to make Excel work for you!