Questions About This Book?
What version or edition is this?
What is included with this book?
- The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.
- The eBook copy of this book is not guaranteed to include any supplemental materials. Typically only the book itself is included.
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.
Table of Contents
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