Excel 2007 Just the Steps For Dummies
1st Edition
Published on 2. February 2007
Book
Paperback/Softback
240 pages
978-0-470-03921-2 (ISBN)
Description
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 nonsequential) 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(r)
Simple steps.
.for great results
Create a Basic Chart
1.Select the data (sequential or nonsequential) 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(r)
More details
Product info
PB
Edition
1., Auflage
Language
English
Place of publication
United States
Publishing group
John Wiley & Sons Inc
Target group
Professional and scholarly
Illustrations
Screen captures: 400 B&W, 0 Color
Dimensions
Height: 23.4 cm
Width: 18.3 cm
Thickness: 1.2 cm
Weight
390 gr
ISBN-13
978-0-470-03921-2 (9780470039212)
Schweitzer Classification
Person
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.
Diane and her husband enjoy spending their free time fishing, traveling and playing with their four grandsons and Little Joe, their Yorkshire Terrier.
Content
Introduction.
Part I: Putting Excel to Work.
Chapter 1: Working with Excel Files.
Chapter 2: Entering Spreadsheet Data.
Chapter 3: Building Formulas.
Chapter 4: Protecting Excel Data.
Part II: Sprucing Up Your Spreadsheets.
Chapter 5: Formatting Cells.
Chapter 6: Applying Additional Formatting Options.
Chapter 7: Designing with Graphics.
Chapter 8: Managing Workbooks.
Part III: Viewing Data in Different Ways.
Chapter 9: Changing Worksheet Views.
Chapter 10: Sorting Data.
Chapter 11: Creating Charts.
Chapter 12: Printing Workbooks.
Part IV: Analyzing Data with Excel.
Chapter 13: Working with Outlines.
Chapter 14: Filtering Data.
Chapter 15: Creating PivotTables.
Chapter 16: Building Simple Macros.
Chapter 17: Saving Time with Excel Tools.
Part V: Utilizing Excel with Other People and Applications.
Chapter 18: Collaborating in Excel.
Chapter 19: Integrating Excel into Word.
Chapter 20: Blending Excel and PowerPoint.
Chapter 21: Using Excel with Access.
Part VI: Practical Applications for Excel.
Chapter 22: Designing an Organization Chart.
Chapter 23: Creating a Commission Calculator.
Chapter 24: Tracking Medical Expenses.
Chapter 25: Planning for Your Financial Future.
Index.
Part I: Putting Excel to Work.
Chapter 1: Working with Excel Files.
Chapter 2: Entering Spreadsheet Data.
Chapter 3: Building Formulas.
Chapter 4: Protecting Excel Data.
Part II: Sprucing Up Your Spreadsheets.
Chapter 5: Formatting Cells.
Chapter 6: Applying Additional Formatting Options.
Chapter 7: Designing with Graphics.
Chapter 8: Managing Workbooks.
Part III: Viewing Data in Different Ways.
Chapter 9: Changing Worksheet Views.
Chapter 10: Sorting Data.
Chapter 11: Creating Charts.
Chapter 12: Printing Workbooks.
Part IV: Analyzing Data with Excel.
Chapter 13: Working with Outlines.
Chapter 14: Filtering Data.
Chapter 15: Creating PivotTables.
Chapter 16: Building Simple Macros.
Chapter 17: Saving Time with Excel Tools.
Part V: Utilizing Excel with Other People and Applications.
Chapter 18: Collaborating in Excel.
Chapter 19: Integrating Excel into Word.
Chapter 20: Blending Excel and PowerPoint.
Chapter 21: Using Excel with Access.
Part VI: Practical Applications for Excel.
Chapter 22: Designing an Organization Chart.
Chapter 23: Creating a Commission Calculator.
Chapter 24: Tracking Medical Expenses.
Chapter 25: Planning for Your Financial Future.
Index.