Teach Yourself VISUALLYExcel 2007
Nancy C. Muir
- 出版商: Hungry Minds
- 出版日期: 2006-12-06
- 售價: $1,120
- 貴賓價: 9.5 折 $1,064
- 語言: 英文
- 頁數: 304
- 裝訂: Paperback
- ISBN: 0470045957
- ISBN-13: 9780470045954
-
相關分類:
Excel
已絕版
買這商品的人也買了...
-
人月神話：軟體專案管理之道 (20 週年紀念版)(The Mythical Man-Month: Essays on Software Engineering, Anniversary Edition, 2/e)$480$379 -
Windows 程式設計使用 MFC (Programming Windows with MFC, 2/e)$990$782 -
ASP.NET 2.0 深度剖析範例集$650$507 -
Microsoft Office SharePoint Server 2007 實戰手冊$450$356 -
MySQL 5 徹底研究, 3/e (The Definitive Guide to MySQL 5, 3/e)$690$538 -
Excel 2007 For Dummies$1,030$979 -
Special Edition Using Microsoft Office Excel 2007$1,680$1,596 -
輕鬆打造我的網站─XOOPS2 深入使用手冊$580$522 -
ADO.NET 2.0 實戰講座$690$587 -
Microsoft Office SharePoint Server 2007 技術手冊$350$277 -
C++ Primer, 4/e (中文版)$990$891 -
最新 JSP 與 Servlet 600 個活用範例大全, 2/e$620$484 -
深入淺出 PMP (Head First PMP)$880$695 -
Linux 網路安全技術與實現$620$527 -
Java 認證 SCJP 6.0/5.0 猛虎出閘$680$537 -
Linux 程式設計教學手冊 (Beginning Linux Programming, 4/e)$780$616 -
Web CSS 網頁設計大全$580$452 -
計算機概論 (Computer Science: An Overview, 10/e)$750$713 -
Linux 裝置驅動程式之開發詳解$780$663 -
Microsoft Robotics Developer Studio 實戰手冊$450$383 -
3D 繪圖程式設計：使用 Direct3D 10/9 與 OpenGL 2.0$700$553 -
精通 Flex－基於 ActionScript 實現$580$493 -
SQL Server 2008 SSIS 整合服務$780$663 -
Windows Server 2008 Active Directory 建置實務$620$490 -
Linux Device Driver Programming 驅動程式設計$690$587
商品描述
Description
* This book illustrates the extensive changes in the new version of Excel such as new collaboration tools, an updated Excel Server, list functionality, and information protection as well as a new look with a redesigned UI* Step-by-step instructions with practical examples and advice guide users through the world's most widely used spreadsheet application* With gorgeous, full-color illustrations on every page, high-resolution graphics, and clear screen shots, this book is a solid reference for any Microsoft Excel user* Features a totally redesigned interior that helps make information more accessible to readers
Table of Contents
Chapter 1. Excel Basics.An Introduction to Excel.
Start and Close Excel.
Navigate the Excel Program Window.
Understanding the Ribbon, Galleries, and Contextual Tools.
Change Views.
Customize the Quick Access Toolbar.
Display Task Panes.
Find Help.
Chapter 2. Workbook Fundamentals.
Start a New Workbook File.
Save a Workbook.
Publish a Workbook as an Excel Binary Workbook.
Open an Existing Workbook.
Close a Workbook.
Delete a Workbook.
Arrange Workbook Windows.
Protect a Workbook.
Hide or Show a Worksheet.
Chapter 3. Entering Data.
Enter Data.
Turn On Text Wrapping.
Resize Columns and Rows.
Select Cells.
Enter Data with AutoFill.
Work with AutoCorrect.
Edit Data.
Work with Smart Tags.
Check Spelling in a Worksheet.
Chapter 4. Working with Worksheets
Understanding Worksheet Structure.
Navigate Worksheets.
Name a Worksheet.
Add a Worksheet.
Delete a Worksheet.
Move a Worksheet.
Copy a Worksheet.
Format Worksheet Tab Color.
Protect Worksheet Data.
Chapter 5. Selecting Data with Formulas and Functions.
Understanding Formulas.
Create Formulas.
Reference Absolute and Relative Cells.
Copy Formulas.
Name Cells and Ranges.
Reference Ranges in Formulas.
Reference Cells from Other Worksheets.
Understanding Functions.
Apply a Function.
Total Cells with AutoSum.
Check for Formula Errors.
Audit a Worksheet for Errors.
Chapter 6. Rearranging Worksheet Data.
Move and Copy Data.
Delete Data or Cells.
Add Columns and Rows.
Delete Columns and Rows.
Center Data across Columns.
Transpose Columns and Rows.
Set Column Width and Row Height.
Hide Columns and Rows.
Freeze a Column or Row.
Split a Worksheet into Panes.
Find and Replace Data.
Chapter 7. Formatting Worksheets.
Apply Bold, Italics, and Underlining.
Change the Font and Size.
Change Number Formats.
Increase or Decrease Decimals.
Change Data Color.
Apply Workbook Themes.
Align Cell Data.
Rotate Cell Data.
Control Text Wrap.
Add Borders.
Add Background Color to Cells.
Assign a Background to a Worksheet.
Copy Cell Formatting.
Apply a Style.
Chapter 8. Enhancing Worksheets with Graphics.
Insert Image Files.
Insert Clip Art.
View Clip Art with the Clip Organizer.
Download Clip Art from the Web.
Draw Shapes.
Add a WordArt Object.
Move and Resize Objects.
Rotate and Flip Objects.
Crop a Picture.
Add Shadow and 3-D Effects.
Format an Object.
Group and Ungroup Objects.
Chapter 9. Previewing and Printing.
Add Headers and Footers.
Insert Page Breaks.
Preview a Worksheet.
Set Up Printing Options.
Print a Worksheet.
Define a Print Area.
Chapter 10. Communicating Information with Charts.
Understanding Excel Charts.
Create a Chart with Galleries.
Move and Resize Charts.
Change the Chart Type.
Change the Axes Titles.
Manipulate 3-D Charts.
Format Chart Objects.
Add Chart Objects.
Change the Chart Data.
Format Charts with Layouts and Styles.
Insert SmartArt Charts.
Chapter 11. Analyzing Worksheet Data.
Understanding Database Lists.
Create a Database Table.
Add Records Using a Data Form.
Edit Records.
Search for Records.
Identify Duplicate Values in a Table.
Set Data Validation Rules.
Sort Records.
Filter Data with AutoFilter.
Analyze Data with a PivotTable.
Chapter 12. Using Excel Tools.
Add a Watch Window.
Load Add-Ins.
Analyze Data with Add-In Tools.
Examine Alternatives with Goal Seek.
Create Scenarios.
Optimize Formulas with Solver.
Chapter 13. Sharing Excel Data.
Link Data.
Edit Linked Data.
Link Between Worksheets.
Embed Objects.
Enable Workbook Sharing.
Add a Comment.
Track and Review Workbook Changes.
Merge Workbooks.
E-mail a Workbook.
Import Data.
Export Data.
Chapter 14. Using Excel on the Web.
Add Web Tools to the Quick Access Toolbar.
Publish a Workbook as a Web Page.
Insert a Hyperlink.
Download a Stock Quote.
Copy Web Data to a Worksheet.
Run a Web Query.
Chapter 15. Improving Excel Efficiency
Personalize the Excel Program Window.
Change the Default Font.
Change the Default File Location.
Open Files in a Specified Folder Automatically.
Set Macro Security.
Record a Macro.
Create an Excel Template.
Apply an Excel Template.
