Excel 2010 All-in-One For Dummies - Brossura

Harvey, Greg

 
9780470489598: Excel 2010 All-in-One For Dummies

Sinossi

Excel is such a powerhouse, it takes eight self-contained minibooks to cover all its features! Open this All-in-One and find just what you need to know, from how to use the Ribbon interface and Backstage View and how to set up your first spreadsheet to collaborating on a worksheet, presenting results with cool charts and graphs, and understanding formuulas and functions.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Informazioni sugli autori

Greg Harvey, PhD, is president of Mind Over Media, Inc. He is the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference. He's also an experienced educator.

Greg Harvey, PhD, is president of Mind Over Media, Inc. He is the author of all editions ofExcel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, andWindows For Dummies Quick Reference. He's also an experienced educator.

Dalla quarta di copertina

8 BOOKS IN 1

  • Excel Basics
  • Worksheet Design
  • Formulas and Functions
  • Worksheet Collaboration and Review
  • Charts and Graphics
  • Data Management
  • Data Analysis
  • Excel and VBA

Here's everything you need to know about using Excel in one handy package!

Excel is such a powerhouse, it takes eight self-contained minibooks to cover all its features! Open this All-in-One and find just what you need to know, from how to use the Ribbon interface and Backstage View and how to set up your first spreadsheet to collaborating on a worksheet, presenting results with cool charts and graphs, and understanding formulas and functions.

  • Welcome to 2010 explore the new user experience, learn where to get help, and customize your Excel
  • Workin' with worksheets learn to build, format, edit, proof, manage, and print them
  • Formula for success find out what formulas and functions do and how to use them
  • Share and collaborate discover how to send workbooks out for review and incorporate input from multiple users
  • Results that are pretty find out which type of chart shows off your data to best advantage
  • Keeping data in line learn to maintain, sort, and filter data lists using Excel
  • Analyze this use Excel's computational ability to predict possible outcomes
  • Making macros use Visual Basic for Applications, record macros, edit VBA code, and make Excel do your bidding

Open the book and find:

  • How to navigate the Ribbon and Backstage View
  • Shortcuts for switching from older versions
  • Tricks for eliminating Text to Speech errors
  • All about functions and how they work in formulas
  • How to secure data and still enable user edits
  • How to use line charts, pie charts, and scatter charts
  • Tips for creating macros and custom functions
  • How to perform what-if analysis

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.