The IT Girl’s Guide to Becoming an Excel Diva IT女孩如何成为Excel高手
点此进入淘宝搜索页搜索分類: 图书,进口原版书,计算机 Computers & Internet ,
作者： Ani Babaian 著
出 版 社：
出版时间： 2008-4-1字数：版次： 1页数： 318印刷时间： 2008/04/01开本： 16开印次： 1纸张： 胶版纸I S B N ： 9780470149164包装： 平装内容简介
Who knew a spreadsheet could do as much for you as your favorite moisturizer? Become a Microsoft Excel Diva with this sassy guide and discover what hip IT Girls already know: smart is beautiful. Impress the heck out of everyone at work with your stylish reports. Do a budget and see exactly what you can spend on shoes. Get better organized. Who has time for dull technical manuals? Learn all of Microsoft Excel's secrets in this girl-talk guide.
Welcome to the party!
Relax, refresh, and reward yourself at the end of each chapter with fun, stress-reducing chats, like why soy Chai lattes are better than regular lattes. Don't miss these gems!
Meet Microsoft® Excel® 2007, the Louis Vuitton of spreadsheets
Join the conversation with these basic Excel terms
Learn the fine art of Excel formulas and functions
Dress up Excel data with SmartArt, WordArt, and other chic accessories
Build a shopping spree budget from scratch
Show off by adding Excel data into Word and PowerPoint.
目录
Introduction
PART I: Learn IT
Chapter 1: The F0ur-0ne-0ne of Excel
Excel 2007: The Louis Vuitton of Spreadsheets
What Excel Can Do for You
Excel Can Beautify Your Data
Excel Formulas: It All Adds Up!
File Formats and How to Share with Your Friends
Review Before You Print
Online Help
Chapter 2: Excel Diva: Where to Begin with Excel
Technology Smarts
Do You Need to Register?
Waiter, I Think There's a Bug in My Software
Excel Lingo
What a Worksheet Is; What a Workbook Is
Inside a Cell
Shortcuts Aren't for Everybody
This Ribbon Isn't for Your Hair: Introducing the
Excel Ribbon
Using the Office 2007 Ribbon for Formatting
Finding the Special Tools
A Quick Save Tip
Creating a New Workbook
Chapter 3: Make Minor Alterations to Your Data
It's/Sill about the Data
Entering and Editing Data-opy and Paste Is Our Friend
Copy (and Paste) Is Key
Cut and Paste
Paste, But Not Paste-y White
Special Pasting
Introducing Cut's Best Friends, Undo and Redo
Painting Isn't Just for Fingernails: Meet the
Format Painter
Inserting and Deleting Rows and Columns
Formatting Cells
Chapter 4: Worksheet Presentation: Data Meets Intuition and Utility
Appreciate Your Selection
Waltz the Regions
Filling the Cells
Making the Information Fit
Getting Symbolic: Entering Symbols in Your Worksheet...
So You're Not Perfect: Editing Your Input
Worksheets Are Like Purses
Inserting and Deleting Worksheets
Rename Your Worksheets
Copy and Move Your Worksheets
It's All In How You Look At It: Worksheet Presentation .
Splitting into Panes
Freezing Panes (and Thawing Them Too)
Zooming
Chapter 5: The Fine Art of Using Formulas
Persuading Data with Formulas
Cell Referencing
The Order of Operations
Inserting Formulas into a Worksheet
Copy and Paste Meet Formulas
Cross Referencing Cells Across Worksheets
Paste Special
Common Errors
Chapter 6: Put Excel Functions to Work for You
What Is a Function?
The SUM Function
The AVERAGE Function
The MEDIAN Function
The DOLLAR ($) Function or Monetary Display Format .
Adding Decimals
The Count Numbers, MAX, and MIN Functions
The Standard Deviation (STDV) Function
Other Functions
……
