買這商品的人也買了...
-
$550$435 -
$350$277 -
$880$695 -
$650$514 -
$680$578 -
$520$442 -
$550$468 -
$980$774 -
$650$514 -
$550$468 -
$750$593 -
$600$480 -
$720$612 -
$450$356 -
$620$490 -
$1,440$1,368 -
$680$537 -
$820$648 -
$890$703 -
$490$323 -
$490$387 -
$399CompTIA Project+ Study Guide: Exam PK0-003 (Paperback)
-
$450$351 -
$980$833 -
$580$458
相關主題
商品描述
Description
Fast-paced and easy to use, this new book teaches you the basics of Excel 2007 so you can start using the program right away. This concise guide shows readers how to work with Excel's most useful features and its completely redesigned interface. With clear explanations, step-by-step instructions, lots of illustrations, and plenty of timesaving advice, Excel 2007 for Starters: The Missing Manual will quickly teach you to:
- Build spreadsheets
- Add and format information
- Print reports
- Create charts and graphics
- Use basic formulas and functions
- and more
The new Excel is radically different from previous versions. Over the years, Excel has grown in power, sophistication and capability, but its once-simple toolbar has been packed with so many features that not even the pros could find them all. For Excel 2007, Microsoft redesigned the user interface completely, adding a tabbed toolbar that makes every feature easy to locate.
Unfortunately, Microsoft's documentation is as scant as ever, so even if you find the features you need, you still may not know what to do with them. But with this book, you can breeze through the new user interface and its timesaving features in no time. Excel 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.
Table of Contents
The Missing Credits
Introduction
Part One: Worksheet Basics
Chapter 1. Creating and Navigating Worksheets
Creating a Basic Worksheet
Starting a New Workbook
Adding the Column Titles
Adding Data
Editing Data
Navigating in Excel
The Tabs of the Ribbon
The Formula Bar
The Status Bar
Excel Options
Saving Files
The Excel 2007 File Format
Saving Your Spreadsheet in Older Formats
Saving Your Spreadsheet As a PDF
Disaster Recovery
Opening Files
Opening Multiple Spreadsheets at Once
Chapter 2. Adding Information to Worksheets
Adding Different Types of Data
Controlling Your Data Types
Quick Ways to Add Data
AutoComplete
AutoCorrect
AutoFill
AutoFit
Undo and Redo
Chapter 3. Moving Data Around a Worksheet
Selecting Cells
Making Continuous Range Selections
Making Non-Contiguous Selections
Automatically Selecting Your Data
Making Selections with the Keyboard
Moving Cells Around
A Simple Cut-and-Paste or Copy-and-Paste
A Fancy Cut-and-Paste or Copy-and-Paste
The Clipboard
Special Pasting
Adding and Moving Columns or Rows
Inserting Columns
Inserting Rows
Inserting Copied or Cut Cells
Deleting Columns and Rows
Chapter 4. Managing Worksheets and Workbooks
Worksheets and Workbooks
Adding, Removing, and Hiding Worksheets
Naming and Rearranging Worksheets
Find and Replace
The Basic Find
Find All
More Advanced Searches
Finding Formatted Cells
Finding and Replacing Values
Spell Check
Spell Checking Options
Chapter 5. Formatting Cells
Formatting Cell Values
Formatting Numbers
Formatting Dates and Times
Special Formats for Special Numbers
Formatting Cell Appearance
Alignment and Orientation
Fonts and Color
Borders and Fills
Drawing Borders by Hand
Smart Ways to Apply Formatting
The Format Painter
Styles and Themes
Chapter 6. Viewing and Printing Worksheets
Controlling Your View
Zooming
Viewing Distant Parts of a Spreadsheet at Once
Freezing Columns or Rows
Hiding Data
Saving View Settings
Printing
How to Print an Excel File
Quick Printing
Previewing Your Printout
Creating Headers and Footers
Customizing Print Settings
Controlling Pagination
Page Breaks
Scaling
Page Break Preview: A Bird's-Eye View of Your Worksheet
Part Two: Worksheet power
Chapter 7. Building Basic Formulas
Creating a Basic Formula
Excel's Order of Operations
Cell References
How Excel Formats Cells That Contain Cell References
Functions
Formula Errors
Logical Operators
Formula Shortcuts
Point-and-Click Formula Creation
Point-and-Click Formula Editing
The Formulas Tab
Using the Insert Function Button to Quickly Find and Insert Functions
Copying Formulas
Absolute Cell References
Partially Fixed References
Chapter 8. Tables: List Management Made Easy
The Basics of Tables
Creating a Table
Formatting a Table
Editing a Table
Selecting Parts of a Table
Sorting and Filtering a Table
Applying a Simple Sort Order
Sorting with Multiple Criteria
Filtering with the List of Values
Creating Smarter Filters
Chapter 9. Creating Basic Charts
Charting 101
Embedded and Standalone Charts
Creating a Chart with the Ribbon
The Chart Tools Ribbon Tabs
Basic Tasks with Charts
Moving and Resizing a Chart
Creating a Standalone Chart
Editing and Adding to Chart Data
Changing the Chart Type
Printing Charts
Practical Charting
Charts with Multiple Series of Numbers
Controlling the Data Excel Plots on the X-Axis
Non-Contiguous Chart Ranges
Changing the Order of Your Data Series
Changing the Way Excel Plots Blank Values
Chart Types
Column
Bar
Line
Pie
Area
Appendix. Customizing the Quick Access Toolbar
Index
商品描述(中文翻譯)
**描述**
這本快速且易於使用的新書教您 Excel 2007 的基本知識,讓您能立即開始使用該程式。這本簡明的指南向讀者展示如何使用 Excel 最有用的功能及其全新設計的介面。透過清晰的解釋、逐步的指導、豐富的插圖以及大量節省時間的建議,《Excel 2007 for Starters: The Missing Manual》將迅速教會您:
- 建立電子表格
- 添加和格式化資訊
- 列印報告
- 創建圖表和圖形
- 使用基本公式和函數
- 以及更多
新的 Excel 與之前的版本有著根本的不同。多年來,Excel 的功能、複雜性和能力不斷增強,但其曾經簡單的工具列已經擁有如此多的功能,以至於即使是專業人士也無法找到所有功能。對於 Excel 2007,微軟完全重新設計了使用者介面,新增了分頁工具列,使每個功能都易於找到。
不幸的是,微軟的文檔一如既往地稀少,因此即使您找到了所需的功能,您仍然可能不知道該如何使用它們。但有了這本書,您可以迅速掌握新的使用者介面及其節省時間的功能。《Excel 2007 for Starters: The Missing Manual》是小型企業的完美入門書,特別是那些沒有技術人員可依賴的企業,以及希望整理家庭和辦公室資訊的人。
**目錄**
**缺失的致謝**
**導言**
**第一部分:工作表基礎**
**第1章. 創建和導航工作表**
- 創建基本工作表
- 開始新的工作簿
- 添加列標題
- 添加數據
- 編輯數據
- 在 Excel 中導航
- 功能區的標籤
- 公式欄
- 狀態欄
- Excel 選項
- 儲存檔案
- Excel 2007 檔案格式
- 以舊格式儲存電子表格
- 將電子表格儲存為 PDF
- 災難恢復
- 開啟檔案
- 同時開啟多個電子表格
**第2章. 向工作表添加資訊**
- 添加不同類型的數據
- 控制數據類型
- 快速添加數據
- 自動完成
- 自動更正
- 自動填充
- 自動調整
- 撤銷和重做
**第3章. 在工作表中移動數據**
- 選擇儲存格
- 進行連續範圍選擇
- 進行不連續選擇
- 自動選擇數據
- 使用鍵盤進行選擇
- 移動儲存格
- 簡單的剪切和粘貼或複製和粘貼
- 高級的剪切和粘貼或複製和粘貼
- 剪貼簿
- 特殊粘貼
- 添加和移動列或行
- 插入列
- 插入行
- 插入複製或剪切的儲存格
- 刪除列和行
**第4章. 管理工作表和工作簿**
- 工作表和工作簿
- 添加、刪除和隱藏工作表
- 命名和重新排列工作表
- 查找和替換
- 基本查找
- 查找所有
- 更高級的搜索
- 查找格式化的儲存格
- 查找和替換值
- 拼寫檢查
- 拼寫檢查選項
**第5章. 格式化儲存格**
- 格式化儲存格值
- 格式化數字
- 格式化日期和時間
- 特殊數字的特殊格式
- 格式化儲存格外觀
- 對齊和方向
- 字體和顏色
- 邊框和填充
- 手動繪製邊框
- 智能應用格式化
- 格式刷
- 樣式和主題
**第6章. 查看和列印工作表**
- 控制您的視圖
- 縮放
- 同時查看電子表格的遙遠部分
- 冻結列或行
- 隱藏數據
- 儲存視圖設置
- 列印
- 如何列印 Excel 檔案
- 快速列印
- 預覽您的列印輸出
- 創建頁眉和頁腳
- 自定義列印設置
- 控制分頁
- 分頁符
- 縮放
- 分頁預覽:工作表的鳥瞰圖
**第二部分:工作表的力量**
**第7章. 建立基本公式**
- 創建基本公式
- Excel 的運算順序
- 儲存格參考
- Excel 如何格式化包含儲存格參考的儲存格
- 函數
- 公式錯誤
- 邏輯運算符
- 公式快捷鍵
- 點擊創建公式
- 點擊編輯公式
- 公式標籤
- 使用插入函數按鈕快速查找和插入函數
- 複製公式
- 絕對儲存格參考
- 部分固定參考