- ホーム
- > 洋書
- > 英文書
- > Computer / Spreadsheets
Full Description
Learn Excel 2010 your way and remember more! * Already have experience with using Excel? No Problem! With this book you can build upon your knowledge * In a rush? No Problem! For a quick path, you can choose to read only the highlighted text for just what you need to know * Prefer to take notes while you learn? No Problem! We've sprinkled loads of notes and quick tips throughout the book, and left you plenty of room to take your own * Need a detailed step-by-step guide to Excel 2010? No Problem! Combine all the learning paths for a comprehensive workshop
Contents
How to use this book xiii Learn your way xivThis book is like a recipe xivActive learning helps you remember xvLink new knowledge to what you already know xviMysteries are memorable xviiWhy `take a break' before the end of each chapter? xviiiLearn. Review. Repeat. xixReview xix1 Get your information in there fast! 1It's like Excel 2010 received an extreme makeover 2Comfortable . . . like your favorite pair of jeans 4Why type it twice when you could do it just once? 5Make quick work of lists 6It's time to do some math 9Common calculations everyone should know 13Review 16Experiment 182 Filter and sort your data 21Organize lots of data 22Does your list follow the rules? 22Convert your list into a table 24AutoFilter your table data 25Have lots of info? Organize it! 28Sort your data 28Filter your data 29Review 34Experiment 353 Get your Excel file show-ready, fast 37Save time with a style guide 38Dress up your plain text 39Format a whole row 39Format part of a cell 40Format non-adjacent cells 41It's all about the symbols 41Make room for the unexpected 42Deal with long column entries manually 43Deal with long column entries automatically 44Set a fixed column width 44That's a wrap 46Give your worksheet a title 48Delete it, hide it, or show it? 49Hide non-essential rows 50Add a single cell 52Cut and paste information into a new workbook 53Last-minute changes 53Find and Replace 54Format Painter 55Share your workbook 56Perfectly printed 57PDF everybody's doing it 57Send an Excel file by e-mail 59Review 60Experiment 624 Take a walk on the 3D side 65There's no need to reinvent the wheel 66Follow the strictest company guidelines 67Create custom number formats 68Custom number symbol cheat sheet 69Create a custom number format from scratch 74It's 3D without the big glasses 77Set it up, then lock it up 80Keep a copy for reference 82Review 83Experiment 855 Create the perfect invoice 87Put it all together and see what you've got 88Indent to impress 91Excel 2010 No Problem!Interactive invoicing 92Add hyperlinks to your invoice 92Create a template 94Digital signatures 97Review 100Experiment 1016 If you had to grade 133 students 103Make your text fit another way 104A special kind of paste 106Watch for trends or problems 107Add comments 108Calculate the final grade 110Can IF help you work out the final grades? 114Review 118Experiment 1197 Create a project status report 121Highlight key information 122Borders and shading make cells stand out 123Say it anywhere 125Enhance your visual perception 128Show it with a picture 131Review 134Experiment 1358 Track customer billable hours by company 139Bring in data stored elsewhere 140Import .csv files 141Import data from other Excel files 144Import data from text files 147Color makes tabs easier to find 151View more than one worksheet at the same time 152Create totals for billing 155Automatic subtotals help you bill regularly 155Review 158Experiment 1609 Create an interactive data view 163Share and share alike 164Share it as a different file type 164Change the Print options 166Make it interactive for even a novice Excel user 171Validate your data 172Create PivotTables first 173Review 180Experiment 18110 Fix someone else's worksheet 185You can't calculate what isn't there 186Two ways to print a selection 191What's that? You need a mailing list? 192Find your page breaks 195Add, then save a theme 199Review 202Experiment 20411 Determine sales commissions 207Absolute cell references 208Get a handle on the view 211DSUM 214Review 219Experiment 22112 Cut a list down to size 223Garbage in, garbage out 224Find and remove duplicates 224Grab what you need and leave the rest 226Use an Advanced Filter 227What if there are multiple criteria? 229Pull out specific data with a condition and the right operator 230Your results are as pretty as a picture 235Review 236Experiment 237Excel 2010 No Problem!13 Chart your data 239A picture's worth a thousand words 240Add a pie chart 240Get it print ready 246Review 249Experiment 25014 It's all about the sales 253"What if . . .?" 254Use the Scenario Manager to track scenarios 255Create a PivotChart 257Keep an eye on things 261Look it up, vertically 262Review 269Experiment 27015 Create a client proposal 273Bring all the data together 274Hold it! 277Give your workbooks some style 280Add a flow chart 283Make it available for all to see 286Review 289Experiment 29016 Track expenses across a team 293Do you validate? 294Prevent errors before they have the chance to happen 297Shared files let team members enter their own updates 299See who did what and where 301Review 305Experiment 306Answers from chapter 1 (page 19) 307Answers from chapter 2 (page 35) 307Answers from chapter 10 (page 195) 308Index 309
