Excel 2007 All-In-One Desk Reference for Dummies
-
Author:
-
Subject:
-
Published by:John Wiley & Sons Inc (US)
-
Published:15/12/2006
-
Price:$44.99
- < Buy this book >
Your one-stop guide to great-looking spreadsheets that actually mean something
Create colorful spreadsheets and charts, use Live Preview, and maximize everything Excel 2007 has to offer! Find just what you need to know about using the new Ribbon, designing spreadsheets that communicate, editing and printing them, working with formulas, protecting your data when you collaborate, turning out cool charts, and much more. The included four-color insert highlights the Ribbon, new graphics features, and more!
Discover how to
- Create dynamic spreadsheets with style galleries
- Work with more than 40 new cell styles
- Automate formatting with Live Preview
- Share Excel data with other programs
- Use VBA to write custom Excel functions
Biography
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience, the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Table of Contents
Book I: Excel Basics.
Chapter 1: The Excel 2007 User Experience.
Chapter 2: Getting Help, Tips, and Updates.
Chapter 3: Customizing Excel.
Book II: Worksheet Design.
Chapter 1: Building Worksheets.
Chapter 2: Formatting Worksheets.
Chapter 3: Editing and Proofing 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 and Review.
Chapter 1: Protecting Workbooks and Worksheet Data.
Chapter 2: Linking Workbooks with Hyperlinks.
Chapter 3: Sending Workbooks Out for Review.
Chapter 4: Sharing Worksheets and Worksheet Data.
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 VBA.
Chapter 1: Building and Running Macros.
Chapter 2: VBA Programming.
Appendix: Using XML File Formats.
Index.
Configuration, Not Coding
For years, many support teams have been hamstrung by their traditional service desk platforms, which require complex, time-consuming coding for virtually every aspect of customisation. This paper can show how organisations can complete their initial deployments quickly, easily and adapt efficiently to the evolving needs of the business with Nimsoft Service Desk.
Dropbox
Dropbox is a sharing tool that allows you to synchronize your documents, as well share files with others. It automatically uploads the files to the ...
Process-Driven Master Data Management for Dummies
We wrote this book to introduce you to the subject of processdriven MDM. It’s a big topic, one that far outstrips the ability of a brief book to cover. However, our hope is that by reading this book you will gain a fundamental understanding of processdriven MDM, how it works, and what it takes to make it a success in your organisation.
- CCSAP PM ConsultantNSW
- FTSenior Network Engineer - Cisco / Nexus / UCS / - Routing / Switching / WirelessNSW
- FTIT Account Manager - System Integrator - Career Progression - Start ImmediatelyNSW
- FTChange Management ProfessionalsNSW
- FTTechnical Services Engineer - ShoreTel/MitelVIC
- CCSystem Engineer - Lync and Exchange - CONTRACTSWA
- FTSenior Network Field Engineer - Cisco R&S / Wireless SolutionsNSW
- FTSAP Basis ConsultantNSW
- FTSenior Network Field Engineer - Cisco R&S / Wireless SolutionsNSW
- CCOBIEE ConsultantWA
- CCSAP FICO ConsultantNT
- FTProduct Manager Strategist - Enterprise ApplicationsNSW
- FTSAP Basis ConsultantACT
- CCSystem Engineer - Exchange - CONTRACTSWA
- FTQM Trainer and ConsultantNSW
- FTSenior Citrix EngineerNSW
- FTSenior Citrix EngineerNSW
- CCAvaya Engineer - ERS 8600 4.1NSW
- CCPC Relocation Technicians - Multiple Roles availableSA
- FTiPhone Developer DeveloperNSW
- FTIT Service Desk EngineerNSW
- FTiPhone App DeveloperNSW
- FTiPhone App DeveloperNSW
- FTiPhone App DeveloperNSW
- FTIT Service Desk EngineerNSW
