買這商品的人也買了...
-
$1,710$1,625 -
$520$411 -
$620$527 -
$520$411 -
$580$458 -
$530$419 -
$620$484 -
$890$757 -
$750$593 -
$580$493 -
$450$351 -
$490$417 -
$640$506 -
$650$553 -
$580$458 -
$520$411 -
$980$833 -
$580$458 -
$680$537 -
$850$723 -
$590$502 -
$490$382 -
$420$332 -
$590$502 -
$520$411
相關主題
商品描述
Description
Moving to Excel 2007 is not a routine upgrade. Microsoft's radical redesign of the application's user interface has led to confusion among many who people who have relied on Excel for years. Our new edition of the Excel 2007 Pocket Guide has been written from the ground up to help newcomers and longtime users alike find their way around without getting lost.
With this book in hand, you'll be able to find your favorite Excel tools quickly. It's packed with information to guide beginners through the basics of creating spreadsheets and entering data, while providing advanced users with information on formulas, pivot tables, and more. Inside, you'll find:This edition also includes an extensive reference on commonly used formulas, which reveal at a glance the many possibilities Excel 2007 provides for easy calculation. Tasks in the book are presented as answers to "How do I..." questions -- such as "How do I change the formatting of part of a cell's contents?" -- followed by concise instructions for performing the task. You'll learn ways to customize Excel to fit your needs, and how to share workbooks and collaborate with others. And much more.
- A visual guide to the new "Ribbon" interface that helps users find familiar tools
- A section designed to give beginners enough information to dive right in and start creating rich Excel workbooks immediately
- Quick answers about how to perform specific tasks in Excel, such as working with files, editing data, formatting, summarizing and displaying data
- Convenient techniques for connecting data across worksheets and projects
- Help for moving from the basics of spreadsheet construction to more advanced features
Don't let Excel 2007 baffle you. Pick up this convenient pocket guide and learn to navigate this redesigned application with ease.
Table of Contents
Understanding Excel
What's New in Excel 2007
The Excel 2007 Interface
The Anatomy of an Excel File
Formatting
Shortcut Menus and the Mini Toolbar
How Excel Tries to HelpExcel Tasks
Working with Files
Printing
Moving Around in a Workbook or Worksheet
Manipulating Workbooks and Worksheets
Manipulating Rows, Columns, and Cells
Entering and Editing Data
Formatting
Working with Hyperlinks
Working with Headers and Footers
Summarizing Data
Using Named Ranges
Defining Alternative Data Sets
Controlling How Data Is Displayed
Protecting All or Part of a Workbook
Spelling and Other Tools
Customizing Excel
Collaborating
Working with the Web
Summarizing Data with Charts
Analyzing Data with PivotTables and PivotCharts
Formula Reference
New Formulas in Excel 2007
Math Formulas
Date and Time Formulas
Financial Formulas
Lookup and Reference Formulas
Logical Formulas
Text Formulas
Statistical Formulas
Chapter 4:. Excel Reference
Command Reference
Native Formats
Startup Switches
Wildcards in Filters and Searches
Default File Locations
Keyboard Shortcuts
Chapter 5:. Excel Resources
Internet Sites
Books
Excel Utilities
Index
商品描述(中文翻譯)
**描述**
升級到 Excel 2007 並不是一個例行的升級。微軟對應用程式使用者介面的徹底重新設計,讓許多依賴 Excel 多年的使用者感到困惑。我們的新版本《Excel 2007 口袋指南》是從頭開始撰寫的,旨在幫助新手和長期使用者找到方向,而不會迷失在其中。
有了這本書,您將能夠快速找到您最喜愛的 Excel 工具。它包含了指導初學者創建電子表格和輸入數據的基本資訊,同時為進階使用者提供有關公式、樞紐分析表等的資訊。書中包含:
- 一個視覺指南,介紹新的「功能區」介面,幫助使用者找到熟悉的工具
- 一個專為初學者設計的部分,提供足夠的資訊讓他們立即開始創建豐富的 Excel 工作簿
- 有關如何在 Excel 中執行特定任務的快速答案,例如處理檔案、編輯數據、格式化、彙總和顯示數據
- 方便的技巧,用於在工作表和專案之間連接數據
- 從電子表格建構的基本知識轉向更高級功能的幫助
本版本還包括一個廣泛的常用公式參考,讓您一目了然地了解 Excel 2007 提供的多種簡易計算可能性。書中的任務以「我該如何...」問題的形式呈現,例如「我該如何更改單元格內容的一部分格式?」隨後是執行該任務的簡明指示。您將學會如何自訂 Excel 以符合您的需求,以及如何共享工作簿並與他人協作。還有更多內容。
不要讓 Excel 2007 讓您感到困惑。拿起這本方便的口袋指南,學習如何輕鬆導航這個重新設計的應用程式。
**目錄**
**理解 Excel**
- Excel 2007 的新功能
- Excel 2007 介面
- Excel 檔案的結構
- 格式化
- 快捷選單和迷你工具列
- Excel 如何提供幫助
**Excel 任務**
- 處理檔案
- 列印
- 在工作簿或工作表中移動
- 操作工作簿和工作表
- 操作行、列和單元格
- 輸入和編輯數據
- 格式化
- 處理超連結
- 處理頁首和頁尾
- 數據彙總
- 使用命名範圍
- 定義替代數據集
- 控制數據顯示方式
- 保護整個或部分工作簿
- 拼寫和其他工具
- 自訂 Excel
- 協作
- 與網路合作
- 使用圖表彙總數據
- 使用樞紐分析表和樞紐分析圖分析數據
**公式參考**
- Excel 2007 中的新公式
- 數學公式
- 日期和時間公式
- 財務公式
- 查找和參考公式
- 邏輯公式
- 文本公式
- 統計公式
**第 4 章:Excel 參考**
- 命令參考
- 原生格式
- 啟動開關
- 過濾器和搜尋中的通配符
- 預設檔案位置
- 鍵盤快捷鍵
**第 5 章:Excel 資源**
- 網站
- 書籍
- Excel 工具
**索引**