* Covers everything a reader needs to know to perform the task at hand, then goes a step beyond by outlining the most practical and useful applications for Excel in the workplace
* Organized in convenient minibooks to help the reader find necessary information about particular topics quickly and easily
* Includes basic coverage of importing data, building and editing worksheets, creating formulas, generating PivotTables, and performing financial functions, what-if scenarios, database functions, and Web que-ries
* Advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with VBA and the Web
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Illustrationen
Maße
Höhe: 23.2 cm
Breite: 19.3 cm
Dicke: 2 cm
Gewicht
ISBN-13
978-0-7645-3758-5 (9780764537585)
Schweitzer Klassifikation
Greg Harvey is a veteran computer trainer and consultant who has written more than 50 books. He's the owner of a multimedia publishing venture called Mind Over Media.
Introduction.
Book I: Excel Basics.
Chapter 1: Getting Acquainted with Excel.
Chapter 2: Getting Help.
Chapter 3: Customizing Excel.
Book II: Worksheet Design.
Chapter 1: Building Worksheets.
Chapter 2: Formatting Worksheets.
Chapter 3: Editing Worksheets.
Chapter 4: Managing Worksheets.
Chapter 5: Printing Worksheets.
Book III: Formulas and Functions.
Chapter 1: Building Basic Formulas
Chapter 2: Logical Functions and Error Trapping
Chapter 3: Date and Time Formulas
Chapter 4: Financial Formulas
Chapter 5: Math and Statistical Formulas
Chapter 6: Lookup, Information, and Text Formulas.
Book IV: Worksheet Collaboration.
Chapter 1: Sharing and Reviewing Workbooks.
Chapter 2: Protecting Worksheets.
Chapter 3: Sharing Data with Other Programs.
Chapter 4: Sharing Data via a SharePoint Team Services Web Site.
Book V: Charts and Graphics.
Chapter 1: Charting Worksheet Data.
Chapter 2: Adding Graphic Objects.
Book VI: Data Management.
Chapter 1: Building and Maintaining Data Lists.
Chapter 2: Filtering and Querying a Data List.
Book VII: Data Analysis.
Chapter 1: Performing What-If Scenarios.
Chapter 2: Generating Pivot Tables.
Book VIII: Excel and the Web.
Chapter 1: Worksheets As Web Pages.
Chapter 2: Adding Hyperlinks to Worksheets.
Book IX: Excel and Visual Basic for Applications.
Chapter 1: Building and Running Macros.
Chapter 2: VBA Programming.
Index.
