eBook.de : Ihr Online Shop für eBooks, Reader, Downloads und Bücher

Connect 01/2015 eBook-Shops: Testsieger im epub Angebot, Testurteil: gut Die Welt: Kundenorientierte Internetseiten Prädikat GOLD
+49 (0)40 4223 6096
€ 0,00

Zur Kasse

PORTO-
FREI

Excel 2002 for Dummies Quick Reference

Sprache: Englisch.
Lieferbar innerhalb von zwei Wochen
Buch (kartoniert)
Buch € 18,99* inkl. MwSt.
Portofrei*
Produktdetails
Titel: Excel 2002 for Dummies Quick Reference
Autor/en: John Walkenbach, Colin Banfield

ISBN: 0764508296
EAN: 9780764508295
Sprache: Englisch.
FOR DUMMIES

Juni 2001 - kartoniert - 204 Seiten

This Quick Reference will quickly get you up to speed with Excel's new features, whether you're a novice user or an expert. You'll master how to easily publish interactive Web pages that include spreadsheets and tables. You'll learn how to use new Smart Tags to access real-time data from the Web for your Excel documents. You will be able to use Excel's latest speech recognition capabilities to "talk to your spreadsheets," and much, much more!
The Big Picture: Microsoft Excel 2002.
What You See: The Excel Window BP-2.
What You See: Dialog Boxes BP-4.
Toolbar Table BP-6.
The Basics: Starting Excel BP-8.
The Basics: Getting Acquainted with Excel BP-8.
The Basics: Getting Help BP-10.
The Basics: Creating an Empty Workbook File BP-12.
The Basics: Saving a Workbook File BP-12.
The Basics: Opening a Workbook File BP-13.
The Basics: Closing a Workbook File and Exiting Excel BP-14.
What You Can Do: Show Data Graphically BP-15.
What You Can Do: Import Web Data for Analysis BP-16.
Part I: Using Workbook Files.
Changing the Default File Location.
Creating Multiple Windows (Views) for a Workbook.
Deleting a Workbook File.
Opening Non-Standard Files.
Protecting a Workbook File.
Recovering Workbook Files after a System Crash.
Saving Files.
Switching Among Open Workbooks.
Working with Workbook Templates.
Creating a default workbook template.
Part II: Working with Worksheets.
Activating Worksheets.
Adding a New Worksheet.
Arranging Windows Automatically.
Changing a Worksheet's Name.
Coloring a Worksheet Tab.
Copying a Worksheet.
Deleting a Worksheet.
E-Mailing Worksheet Data.
Freezing Row or Column Titles.
Hiding and Unhiding a Worksheet.
Moving a Worksheet.
Protecting a Worksheet.
Publishing Your Worksheet Data to the Web.
Splitting Panes.
Using Full-Screen View.
Zooming Worksheets
Part III: Entering and Editing Worksheet Data.
Copying Cells and Ranges.
Deleting Entire Rows and Columns.
Editing a Cell's Contents.
Entering Data into a Range.
Entering Dates and Times.
Entering Formulas.
Entering Text.
Entering Values.
Erasing Data in Cells and Ranges.
Filling a Series.
Inserting Decimal Points Automatically.
Inserting Entire Rows and Columns.
Moving Cells and Ranges.
Replacing the Contents of a Cell.
Searching and Replacing Data.
Selecting Cells and Ranges.
Transposing a Range.
Undoing Changes and Mistakes.
Part IV: Using Formulas and Functions.
Absolute, Relative, and Mixed References.
Add-in Functions.
Basic Formula Essentials.
Changing When Formulas Are Calculated.
Converting Formulas to Values.
Editing Functions in Formulas.
Entering Functions in Formulas.
Modifying a Range Reference Used in a Function.
Referencing Cells in Other Worksheets.
Part V: Creating and Using Names.
Changing Names.
Creating Names.
Creating a Table of Names.
Deleting Names.
Names in Formulas.
Naming Constants.
Redefining Names.
Part VI: Auditing Your Work.
Cell Comments.
Checking for Specific Worksheet Errors.
Displaying Formulas on a Worksheet.
Evaluating Parts of a Formula.
Formula Error Values.
Handling Circular References.
Locating Errors by Selecting Special Cells.
Proofreading Your Worksheet Data.
Spell Checking.
Tracing Cell Relationships.
Using the Watch Window.
Hiding the Watch Window.
Part VII: Formatting Your Data.
Adding Borders to a Cell or Range.
Aligning Cell Contents.
Applying Background Colors and Patterns.
Applying a Background Graphic.
Changing the Appearance of Text in Cells.
Changing Text Orientation (Direction).
Copying Formats.
Formatting a Table Automatically.
Formatting Based on a Cell's Contents.
Formatting Numbers.
Hiding Cell Contents.
Hiding and Unhiding Columns and Rows.
Merging Cells.
Modifying Cell Size.
Using Named Styles.
Applying named styles.
Part VIII: Printing Your Work.
Adjusting Margins.
Centering Printed Output.
Changing Default Print Settings by Using a Template.
Changing the Header or Footer.
Controlling Page Settings.
Dealing with Page Breaks.
Previewing Your Work.
Printing Cell Comments.
Printing Charts.
Printing Colors in Black and White.
Printing in Draft Quality.
Printing or Substituting Error Values.
Printing or Suppressing Gridlines.
Printing Row and Column Headings.
Selecting Print Options.
Setting Print Titles.
Part IX: Charting Your Data.
Adding Elements to a Chart.
Adding Fill Effects to a Chart.
Changing a Chart's Data Series.
Changing a Chart's Location.
Changing Chart Elements.
Changing the Chart Type.
Creating a Chart by Using the Chart Wizard.
Creating a Custom Chart Type.
Creating a Default Chart on a Chart Sheet.
Deleting a Chart Element or Data Series.
Displaying a Data Table in a Chart.
Displaying Data Labels in a Chart.
Formatting a Chart Element.
Handling Missing Data in a Chart.
Inserting and Modifying Chart Legends.
Moving a Chart Element.
Rotating 3-D Charts.
Selecting a Chart Element.
Part X: Linking and Consolidating Worksheets.
Consolidating Worksheets.
Linking Workbooks.
Updating links.
Part XI: Working with Lists and External Data.
Accessing Advanced Filtering.
Calculating Subtotals.
Filtering a List.
Importing Data from a Text File.
Importing Data from the Web.
Refreshing Imported Data.
Sorting a List.
Using a custom sort order.
Part XII: Goal Seeking and What-If Analysis.
Creating Data Input Tables.
Goal Seeking.
Using Scenario Manager.
Displaying a named scenario.
Part XIII: Analyzing Data with PivotTables.
Adding and Removing Fields in a PivotTable Report.
Creating a PivotTable Report.
Formatting a PivotTable Report.
Grouping PivotTable Items.
Modifying a PivotTable's Structure.
Refreshing a PivotTable Report.
Glossary: Tech Talk.
Index.
Colin Banfield has been working in the telecommunications field for over 20 years. Colin has been using spreadsheet programs for over 18 years and has used every major spreadsheet program at one time or another, including every version of Microsoft Excel for the PC. He works closely with acclaimed spreadsheet author and guru John Walkenbach in beta testing and providing valuable input for John's award-winning Power Utility Pack Excel add-in, as well as in reviewing many of John's spreadsheet books (including the previous edition of this book, which was originally written by John). Colin's largest Excel project to date is a comprehensive tool designed for central office equipment configuration, pricing, and manufacturing, that is used by sales, engineering, and manufacturing personnel. John Walkenbach is one of the country's leading authorities on spreadsheet software. He's principal of JWalk & Associates Inc., a Southern California-based consulting firm that specializes in spreadsheet application development. John is also a shareware developer, and his most popular product is the Power Utility Pak add-in for Excel. John has written more than 250 articles and reviews for publications such as PC World, InfoWorld, Windows, and PC/Computing. In addition, he's authored more than 20 other spreadsheet books, including Microsoft Excel 2000 Bible, Excel 2000 For Windows For Dummies Quick Reference, and Excel 2000 Programming For Dummies. He also maintains the Spreadsheet Page on the World Wide Web (http://www.j-walk.com). When he's not banging away on his computer keyboard, he's probably banging away on one of his guitars, trying to cop a few blues licks from Freddie King.

Gedruckte Welten


 
Bücher bei eBook.de entdecken.

 

Jetzt die besten Bücher entdecken!

Kunden, die diesen Artikel gekauft haben, kauften auch

Mörderischer Mistral
- 20% **
eBook
von Cay Rademache…
Print-Ausgabe € 9,99
Taxi für eine Leiche
- 29% **
eBook
von Edith Kneifl
Print-Ausgabe € 9,95
tolino shine 2 HD
- 9% **
Hardware
Statt € 119,00
The Rose Tree
Buch (gebunden)
von John Broderic…

Kundenbewertungen zu John Walkenbach, Co… „Excel 2002 for Dummies Quick Reference“

Noch keine Bewertungen vorhanden
Zur Rangliste der Rezensenten
Veröffentlichen Sie Ihre Kundenbewertung:
Kundenbewertung schreiben

Diese Artikel könnten Sie auch interessieren

Act of Law - Liebe verpflichtet
- 70% **
eBook
von Karin Lindber…
Print-Ausgabe € 11,99
Endstation Donau
- 54% **
eBook
von Edith Kneifl
Print-Ausgabe € 19,90
Harry Potter 1 und der Stein der Weisen
Buch (gebunden)
von Joanne K. Row…
Inseltage
eBook
von Jette Hansen
Harry Potter 1 und der Stein der Weisen. Schmuckausgabe
Buch (gebunden)
von Joanne K. Row…

Unsere Leistungen auf einen Klick

Unser Service für Sie

Zahlungsmethoden
Bequem, einfach und sicher mit eBook.de. mehr Infos akzeptierte Zahlungsarten: Überweisung, offene Rechnung,
Visa, Master Card, American Express, Paypal mehr Infos
Geprüfte Qualität
  • Schnelle Downloads
  • Datenschutz
  • Sichere Zahlung
  • SSL-Verschlüsselung
Servicehotline
+49 (0)40 4223 6096
Mo. - Fr. 8.00 - 20.00 Uhr
Sa. 10.00 - 18.00 Uhr
Chat
Ihre E-Mail-Adresse eintragen und kostenlos informiert werden:
* Alle Preise verstehen sich inkl. der gesetzlichen MwSt. Informationen über den Versand und anfallende Versandkosten finden Sie hier.
Artikel mit dem Hinweis "Pünktlich zum Fest" werden an Lieferadressen innerhalb Deutschlands rechtzeitig zum 24.12.2017 geliefert.
Bei als portofrei markierten Produkten bezieht sich dies nur auf den Versand innerhalb Deutschlands.

** im Vergleich zum dargestellten Vergleichspreis.
eBook.de - Meine Bücher immer dabei
eBook.de ist eine Marke der Hugendubel Digital GmbH & Co. KG
Folgen Sie uns unter: