CART

(0) items

Microsoft Excel 2010 in Depth,9780789743084

Microsoft Excel 2010 in Depth

by
Edition:
1st
ISBN13:

9780789743084

ISBN10:
0789743086
Format:
Paperback
Pub. Date:
6/25/2010
Publisher(s):
Que Publishing
List Price: $39.99

Buy Used Book

(Recommended)
In Stock Usually Ships in 24-48 Hours
U9780789743084
$25.99

Buy New Book

Currently Available, Usually Ships in 24-48 Hours
N9780789743084
$33.99

eBook

Downloadable Offline Access
  • Apple Devices
  • Android Devices
  • Windows Devices
  • Mac Devices
Lifetime Access
$24.37

Rent Book

We're Sorry
Sold Out

More New and Used
from Private Sellers
Starting at $23.93
See Prices

Questions About This Book?

What version or edition is this?
This is the 1st edition with a publication date of 6/25/2010.
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 Used copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included.

Related Products


  • Excel 2013 in Depth
    Excel 2013 in Depth




Summary

The beyond-the-basics, beneath-the-surface guide to Microsoft Excel 2010: comprehensive coverage, real solutions! bull; bull;By Bill Jelen, aka MrExcel, an Excel MVP and the principal behind the leading Excel website, MrExcel.com. bull;Covers all aspects of working with Excel 2010, from its updated Ribbon interface to its breakthrough collaboration and improved business intelligence. bull;For everyone who wants to get the most out of Excel 2010, from casual users to corporate professionals. 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.

Author Biography

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

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
8 Formulas
9 Controlling Formulas
10  Understanding Functions
11  Everyday Functions
12  Logical, Lookup, Database
13  Financial
14  Statistical
15  Trig, Matrix, Engineering
16  Connecting Worksheets and External Data
17  Super Formulas
18  Names
19  Tables
 
III. Business Intelligence
20  Sorting
21  Filtering
22  Subtotals
23  Pivot Tables
24  Gemini
25  Slicers
26  What-If Analysis
27  VBA Macros
28  Tips and Tricks
29  Add-Ins
 
IV. Visual Presentation of Data
30  Formatting, Themes, Cell Styles
31  Data Visualizations
32  Charting
33  Sparklines
34  Using SmartArt, Shapes, WordArt and TextBoxes
35  Pictures and ClipArt
 
V. Sharing
36 Printing
37  Sharing
38  Excel Services


Please wait while the item is added to your cart...