Microsoft Excel 2007 In Depth
(häftad)av Bill Jelen
- Format:
- Häftad (paperback)
- Utgiven:
- 2008-07-01
- Språk:
- Engelska
Microsoft Office Excel 2007 In Depth will ease the upgrade path to the latest version of Microsoft best-selling spreadsheet program. The author introduces you to the new interface, allowing you to quickly get back up-to-speed in performing your job, and will then introduce the powerful new features available in Excel 2007
Summary:
This book has been crafted to grow with the user, providing the reference material needed for move towards Excel proficiency and use of more advanced features. If you buy only one book on Excel, Microsoft Office Excel 2007 In Depth is the one to choose.
Does your life play out in a spreadsheet? Do numbers in columns and rows make or break you in the work world? Tired of having numbers kicked in your face by other Excel 2007 power users who make your modest spreadsheets look paltry compared to their fancy charts and pivot tables?
If you answered yes to any of these questions, Microsoft Office Excel 2007 In Depth is the book that will make it all better. Learn quickly and efficiently from a true Excel master using the In Depth formula for success. Here, youll find information thats undocumented elsewhereeven in Microsofts own Help systems. Youll learn from finely crafted, real-life examples built by an author who lives and dies by the integrity of his spreadsheets.
Excels backbone is its formulas and functions. Master those and you will master your spreadsheets. Microsoft Office Excel 2007 In Depth provides more down and dirty help with your formulas and functions than youll find in any other book! See how its done in real life! Dont settle for lame pivot table and chart examples found in other books This book provides beautifully detailed examples that not only show you how it should be done, but how to be the local worksheet hero!
Author:
Bill Jelenis 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 over 300 clients around the English-speaking world. His website hosts over 10 million page views annually. Prior to founding MrExcel.com, Jelen spent twelve years in the trenches, - working as a financial analyst for finance, marketing, accounting and operations departments of a $500 million public company.
(Computer Bookshops Limited)
Fler böcker av Bill Jelen
|
|
|
|
|||
Pivot Table Data Crunching: Microsoft Excel 2010Bill Jelen, Michael Alexander (häftad) |
PowerPivot for the Data Analyst: Microsoft Excel 2010Bill Jelen (häftad) |
VBA & Macros For Micorosoft Office Excel 2007Bill Jelen, Tracy Syrstad (häftad) |
Charts and Graphs: Microsoft Excel 2010Bill Jelen (häftad) | |||
|
238:- Köp
|
238:- Köp
|
265:- Köp
|
265:- Köp
|
Kundrecensioner
Bloggat om Microsoft Excel 2007 In Depth
Innehållsförteckning
Table of Contents
Introduction
I Mastering the New User Interface
1 Introducing the Ribbon User Interface . . . . . . . . . . . . . 21
2 The Quick Access Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
3 The Mini Toolbar and Other U.I. Improvements . . . 53
4 Keyboard Shortcuts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
5 Galleries, Live Preview, and Themes . . . . . . . . . . . . . . . . 87
6 The Excel Options Dialog . . . . . . . . . . . . . . . . . . . . . . . . . . 103
II A Tour of Whats New
7 The Big Grid . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121
8 Fabulous Table Intelligence . . . . . . . . . . . . . . . . . . . . . . . . 131
9 Visualizing Data in Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153
10 Using Pivot Tables to Analyze Data . . . . . . . . . . . . . . . . 191
11 Formatting Pivot Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215
12 Pivot Table Data Crunching for Excel 2007 . . . . . . . 237
13 Removing Duplicates and Filtering . . . . . . . . . . . . . . . . 271
14 Sorting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 287
15 Using Excel Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 299
16 Using SmartArt, Shapes, WordArt, and Text Boxes . . 327
17 Using Pictures and Clip Art . . . . . . . . . . . . . . . . . . . . . . . . 351
III Working in a Legacy Environment
18 File Format Differences . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 365
19 Working with Prior Versions of Excel . . . . . . . . . . . . . . 371
IV Calculating with Excel
20 Understanding Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . 385
21 Controlling Formulas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 409
22 Understanding Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . 431
23 Using Everyday Functions: Math, Date and Time,
and Text Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 451
24 Using Powerful Functions: Logical, Lookup, and
Database Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 525
25 Using Financial Functions . . . . . . . . . . . . . . . . . . . . . . . . . . 587
26 Using Statistical Functions . . . . . . . . . . . . . . . . . . . . . . . . . 631
27 Using Trig, Matrix, and Engineering Functions . . . . 735
28 Connecting Worksheets, Workbooks, and
Ex...
(Computer Bookshops Limited)
