Verkauf durch Sack Fachmedien

Koers

Excel 2007 Just the Steps for Dummies

Medium: Buch
ISBN: 978-0-470-03921-2
Verlag: FOR DUMMIES
Erscheinungstermin: 31.01.2007
Nicht mehr lieferbar

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)


Produkteigenschaften


  • Artikelnummer: 9780470039212
  • Medium: Buch
  • ISBN: 978-0-470-03921-2
  • Verlag: FOR DUMMIES
  • Erscheinungstermin: 31.01.2007
  • Sprache(n): Englisch
  • Auflage: Erscheinungsjahr 2007
  • Serie: For Dummies
  • Produktform: Kartoniert
  • Gewicht: 417 g
  • Seiten: 240
  • Format (B x H x T): 231 x 183 x 13 mm
  • Ausgabetyp: Kein, Unbekannt
Autoren/Hrsg.

Autoren

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.