Microsoft Excel 2010 In Depth
Product Author Bios
Bill Jelen is MrExcel, as well as an Excel MVP. He is an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts over 10 million page views annually.
Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Excel 2010, and get more done in less time. Legendary Excel expert Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2010, and adds new chapters on Excel Web App which allows multiple users to edit a spreadsheet simultaneously. New coverage also includes: Slicer, which offers dynamic filtering of PivotTables; Sparklines, which add data visualization to any cell; Calculation engine which improves the speed and accuracy of math, financial, and statistical functions; and the new version of Solver. As with all In Depth books, Excel 2010 In Depth presents comprehensive coverage, breakthrough techniques, exclusive shortcuts, quick access to information, troubleshooting help for tough problems, and real-world examples with nothing glossed over or left out. Step-by-step instructions with icons guide readers through essential tasks such as designing tables, entering data, importing external data, designing and executing queries, and designing data entry forms and printed reports. Additional chapters on advanced form and report design emphasize data entry efficiency and presentation clarity.
- By Bill Jelen, aka MrExcel, an Excel MVP and the principal behind the leading Excel website, MrExcel.com
- Covers all aspects of working with Excel 2010, from its updated Ribbon interface to its breakthrough collaboration and improved business intelligence
- For everyone who wants to get the most out of Excel 2010, from casual users to corporate professionals
Table of Contents
I. Changes in User Interface
1 Out vs In actions: Out Pane
2 Review Ribbon, QAT, Galleries
3 Customizing Ribbon
4 Mini Toolbar, Normal vs Page Layout, Zoom, Live Preview
5 Keyboard Shortcuts
6 Excel Options
7 Compatibility Mode (Big Grid, File Formats)
II. Calculating with Excel
9 Controlling Formulas
10 Understanding Functions
11 Everyday Functions
12 Logical, Lookup, Database
15 Trig, Matrix, Engineering
16 Connecting Worksheets and External Data
17 Super Formulas
III. Business Intelligence
23 Pivot Tables
26 What-If Analysis
27 VBA Macros
28 Tips and Tricks
IV. Visual Presentation of Data
30 Formatting, Themes, Cell Styles
31 Data Visualizations
34 Using SmartArt, Shapes, WordArt and TextBoxes
35 Pictures and ClipArt
38 Excel Services
Includes EPUB, MOBI, and PDF
About eBook Formats
This eBook includes the following formats, accessible from your Account page after purchase:
EPUBThe open industry format known for its reflowable content and usability on supported mobile devices.
MOBIThe eBook format compatible with the Amazon Kindle and Amazon Kindle applications.
PDFThe popular standard, used most often with the free Adobe® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discretely watermarking it with your name, making it uniquely yours.
Also available in other formats.
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.