買這商品的人也買了...
-
VHDL 數位電路實習與專題設計(修訂版)$550$435 -
AutoCAD 2006 實力養成暨評量$350$277 -
深入淺出設計模式 (Head First Design Patterns)$880$695 -
Java 認證 SCJP 5.0 猛虎出閘$650$514 -
Microsoft SQL Server 2005 設計實務$680$578 -
CSS Layout 達人的階梯$520$442 -
SQL 語法範例辭典$550$468 -
Linux 驅動程式, 3/e (Linux Device Drivers, 3/e)$980$774 -
C++ Primer Plus, 5/e 中文豪華版$650$514 -
ActionScript 3.0 精緻範例辭典$550$468 -
ASP.NET AJAX 經典範例 100─使用 VB$750$593 -
現代嵌入式系統開發專案實務－菜鳥成長日誌與專案經理的私房菜$600$480 -
Embedded Linux 開發實務徹底研究 (Embedded Linux Primer: A Practical Real-World Approach)$720$612 -
XNA PC / Xbox 360 C# 遊戲程式設計$450$356 -
大話設計模式$620$527 -
Access 2007: The Missing Manual (Paperback)$1,420$1,349 -
精通 Objective-C 2.0 程式設計 (Programming in Objective-C 2.0, 2/e)$680$537 -
鳥哥的 Linux 私房菜－基礎學習篇, 3/e$820$648 -
Google Android SDK 開發範例大全 2$890$757 -
巧用 jQuery$490$417 -
約耳趣談軟體－來自專案管理的現場實錄 (Joel on Software: And on Diverse and Occasionally Related Matters That Will Prove of Interest to Software Developers)$490$417 -
$399CompTIA Project+ Study Guide: Exam PK0-003 (Paperback) -
深入淺出 Android 系統原理及開發要點$450$351 -
王者歸來 Java Web 整合開發─ JSP + Servlet + Struts + Hibernate + Spring$980$833 -
Android 案例開發完全講義$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
