Star Wars Sale
 
 

Special Offers see all

Enter to WIN!

Weekly drawing for $100 credit. Subscribe to PowellsBooks.news for a chance to win.
Privacy Policy

More at Powell's


Recently Viewed clear list


Original Essays | June 20, 2014

Lauren Owen: IMG The Other Vampire



It's a wild and thundery night. Inside a ramshackle old manor house, a beautiful young girl lies asleep in bed. At the window, a figure watches... Continue »
  1. $18.90 Sale Hardcover add to wish list

    The Quick

    Lauren Owen 9780812993271

spacer
Qualifying orders ship free.
$39.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
1 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets
4 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Microsoft Excel 2010 in Depth (In Depth)

by

Microsoft Excel 2010 in Depth (In Depth) Cover

 

Synopses & Reviews

Publisher Comments:

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

Book News Annotation:

This comprehensive resource details the changes in the newest version of Microsoft's popular spreadsheet application. Designed for readers familiar with older versions of Excel, the work is divided into sections beginning with an examination of the changes to the user interface and covering such topics as calculations, business intelligence, visual presentation and the sharing of information. The work discusses improvements made to fulfill Microsoft's desire to upgrade usability for the scientific community as well as new enterprise level features such as PowerPivot integration with SQL, Oracle and other large database data-sets. Jelen is the host of mrexcel.com and the author of thirty books and numerous articles on the subject. Annotation ©2010 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

A beyond-the-basics guide for everyone who wants to streamline their work with Excel 2010, this title 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.

About the Author

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

Product Details

ISBN:
9780789743084
Author:
Jelen, Bill
Publisher:
Que
Subject:
Spreadsheets - General
Subject:
Spreadsheets - Excel
Subject:
Personal Computers-Applications
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Description:
Trade paper
Series:
In Depth
Publication Date:
June 2010
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
1152
Dimensions:
9 x 7 x 2.299 in 1699 gr

Other books you might like

  1. Excel 2010 All-In-One for Dummies... New Trade Paper $34.99

Related Subjects

Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Microsoft Excel 2010 in Depth (In Depth) New Trade Paper
0 stars - 0 reviews
$39.99 In Stock
Product details 1152 pages Que - English 9780789743084 Reviews:
"Synopsis" by , A beyond-the-basics guide for everyone who wants to streamline their work with Excel 2010, this title 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.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.