會員專區 會員登入
會員登記忘記密碼
尋找門市
Microsoft Excel 2010 In Depth
作者 Bill Jelen
出版社 Que
ISBN 9780789743084
分類 Computer & Information Technology > Software Application
價格 HK$320.00
 
匯率只供參考
貨幣兌換參考
匯率只供參考
本網站未能顯示存貨,書籍資料僅供參考。
如欲查詢店存或選購,請致電或親臨門市了解更多。
 更多資料
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.


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.


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


本網站建議瀏覽環境: Chrome/Firefox/Internet Explorer 9.0+; 屏幕解像度1024x768或以上
©1999-2020 商務印書館(香港)網上書店有限公司 版權所有
放入暫存架