Summer Reading Sale
 
 

Recently Viewed clear list


Original Essays | June 20, 2014

Lisa Howorth: IMG So Many Books, So Many Writers



I'm not a bookseller, but I'm married to one, and Square Books is a family. And we all know about families and how hard it is to disassociate... Continue »

spacer
Qualifying orders ship free.
$29.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
9 Local Warehouse Personal Computers- Desktop Applications- Spreadsheets
16 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

More copies of this ISBN

Excel 2007 All-In-One Desk Reference for Dummies (For Dummies)

by

Excel 2007 All-In-One Desk Reference for Dummies (For Dummies) Cover

 

Synopses & Reviews

Publisher Comments:

Excel “ X” All In One Desk Reference For Dummies will be completely updated to reflect the major changes Microsoft is making to Office which includes notable changes such as a complete redesign of the interface to emphasize tasks,   a  more graphical interface, emphasis on collaboration, application servers, easier document  searching and more!

 

From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, the Excel X All-in-One Desk Reference For Dummies provides the reader with a broad scope of the most common Excel applications and functions — including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions.

 

  Covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries.

 

  More advanced topics include: worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Visual Basic and the Web.

Synopsis:

* New and experienced Excel users will get the most bang for their buck with this comprehensive reference on all things Excel, the most popular spreadsheet and data analysis tool available

* Completely updated to include coverage of the new release of Microsoft Office, this book discusses how to format worksheets, set up formulas, protect worksheets, import data, chart data, and perform statistical functions

* Also covers building and editing worksheets, generating pivot tables, performing financial functions, and executing Web queries

* More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Visual Basic and the Web

Synopsis:

Master the Ribbon, powerful graphics capabilities, and more!

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

About the Author

Greg Harvey has authored tons of computer books, the most recent being Excel 2007 For Dummies, Windows Vista For Dummies Quick Reference, and Excel Workbook For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough-and-tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, he went on to teaching semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.

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

Introduction.

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.

Product Details

ISBN:
9780470037386
Author:
Harvey, Greg
Publisher:
For Dummies
Author:
Harvey, Greg Phd
Author:
Greg Harvey, PhD
Subject:
Business
Subject:
Spreadsheets - General
Subject:
Spreadsheets - Excel
Subject:
Electronic spreadsheets
Subject:
Business -- Computer programs.
Subject:
Microsoft Excel
Subject:
Personal Computers-Applications
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
Micr
Subject:
osoft Excel
Copyright:
Edition Description:
WebSite Associated w/Book
Series:
For Dummies
Publication Date:
20070306
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
816
Dimensions:
9.21x7.42x1.77 in. 2.68 lbs.

Other books you might like

  1. Microsoft Excel 2000 Power... New Trade Paper $49.99
  2. Excel Formulas and Functions for Dummies Used Trade Paper $7.95
  3. Full Blast Used Mass Market $2.95
  4. Murder Carries a Torch: A Southern... Used Mass Market $3.50
  5. Murder Shoots the Bull: A Southern... Used Mass Market $4.50

Related Subjects


Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Excel 2007 All-In-One Desk Reference for Dummies (For Dummies) New Trade Paper
0 stars - 0 reviews
$29.99 In Stock
Product details 816 pages For Dummies - English 9780470037386 Reviews:
"Synopsis" by , * New and experienced Excel users will get the most bang for their buck with this comprehensive reference on all things Excel, the most popular spreadsheet and data analysis tool available

* Completely updated to include coverage of the new release of Microsoft Office, this book discusses how to format worksheets, set up formulas, protect worksheets, import data, chart data, and perform statistical functions

* Also covers building and editing worksheets, generating pivot tables, performing financial functions, and executing Web queries

* More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Visual Basic and the Web

"Synopsis" by , Master the Ribbon, powerful graphics capabilities, and more!

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

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.