Excel 2010 All-in-One For Dummies
- 14h 7m
- Greg Harvey
- John Wiley & Sons (US)
- 2010
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
About the Author
Greg Harvey 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.
In this Book
-
Introduction
-
The Excel 2010 User Experience
-
Getting Help, Tips, and Updates
-
Customizing Excel
-
Building Worksheets
-
Formatting Worksheets
-
Editing and Proofing Worksheets
-
Managing Worksheets
-
Printing Worksheets
-
Building Basic Formulas
-
Logical Functions and Error Trapping
-
Date and Time Formulas
-
Financial Formulas
-
Math and Statistical Formutas
-
Lookup, Information, and Text Formulas
-
Protecting Workbooks and Worksheet Data
-
Linking Workbooks with Hyperlinks
-
Sending Workbooks Out for Review
-
Sharing Worksheets and Worksheet Data
-
Charting Worksheet Data
-
Adding Graphic Objects
-
Building and Maintaining Data Lists
-
Filtering and Querying a Data List
-
Performing What if Scenarios
-
Generating Pivot Tables
-
Building and Running Macros
-
VBA Programming
SHOW MORE
FREE ACCESS
