Excel 2010 Bible
- 14h 27m
- John Walkenbach
- John Wiley & Sons (US)
- 2010
A comprehensive reference to the newest version of the world’s most popular spreadsheet application: Excel 2010
John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of all the new features of Excel 2010.
An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques you won’t find anywhere else.
- Excel guru and bestselling author John Walkenbach ("Mr. Spreadsheet") guides you through every aspect of Excel
- Delivers essential coverage of all the newest features of Excel 2010
- Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience
Excel 2010 Bible serves as an excellent resource on all things Excel!
About the Author
John Walkenbach aka "Mr. Spreadsheet" is the principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and the creator of the award-winning Power Utility Pak. John has written more than 50 books, as well as articles and reviews for publications including PC World, InfoWorld, and Windows.
In this Book
-
Introduction
-
Introducing Excel
-
Entering and Editing Worksheet Data
-
Essential Worksheet Operations
-
Working with Cells and Ranges
-
Introducing Tables
-
Worksheet Formatting
-
Understanding Excel Files
-
Using and Creating Templates
-
Printing Your Work
-
Introducing Formulas and Functions
-
Creating Formulas That Manipulate Text
-
Working with Dates and Times
-
Creating Formulas That Count and Sum
-
Creating Formulas That Look up Values
-
Creating Formulas for Financial Applications
-
Introducing Array Formulas
-
Performing Magic with Array Formulas
-
Getting Started Making Charts
-
Learning Advanced Charting
-
Visualizing Data Using Conditional Formatting
-
Creating Sparkline Graphics
-
Enhancing Your Work with Pictures and Drawings
-
Customizing the Excel User Interface
-
Using Custom Number Formats
-
Using Data Validation
-
Creating and Using Worksheet Outlines
-
Linking and Consolidating Worksheets
-
Excel and the Internet
-
Sharing Data with other Office Applications
-
Using Excel in a Workgroup
-
Protecting Your Work
-
Making Your Worksheets Error-Free
-
Getting Data from External Database Files
-
Introducing Pivot Tables
-
Analyzing Data with Pivot Tables
-
Performing Spreadsheet What-If Analysis
-
Analyzing Data Using Goal Seeking and Solver
-
Analyzing Data with the Analysis ToolPak
-
Introducing Visual Basic for Applications
-
Creating Custom Worksheet Functions
-
Creating UserForms
-
Using UserForm Controls in a Worksheet
-
Working with Excel Events
-
VBA Examples
-
Creating Custom Excel Add-Ins
