Excel 2010 All-in-One For Dummies

Excel 2010 All-in-One For Dummies
PDF

Book Description
A comprehensive, up-to-date, user-friendly guide to Excel 2010
Excel is the standard for spreadsheet applications and is used worldwide, but it’s not always user-friendly. That makes it a perfect For Dummies topic, and this handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more.
Eight minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.
  • Excel is the leading spreadsheet/data analysis software and is used throughout the world; the newest revision includes upgraded tools and a redesigned interface
  • For Dummies books are the bestselling guides to Excel, with more than three million copies sold
  • Excel 2010 All-in-One For Dummies covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions
  • Eight self-contained minibooks cover the basics, worksheet design, formulas and functions, worksheet collaboration, presenting data in charts and graphics, data management, data analysis, and creating macros with VBA.
Newcomers to Excel as well as veterans who just want to learn the latest version will find Excel 2010 All-in-One For Dummies has everything they need to know.

Content

Book I: Excel Basics
Chapter 1: The Excel 2010 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

Download Excel 2010 All-in-One For Dummies PDF or ePUB format free


Free sample

Download in .PDF format



Add comments
Прокомментировать
Введите код с картинки:*
Кликните на изображение чтобы обновить код, если он неразборчив
Copyright © 2019