Du kanske gillar
Excel 2010: The Missing Manual
Fri frakt inom Sverige för privatpersoner.
Laddas ned direkt379
- Navigate with ease. Master Excel's tabbed toolbar and its new backstage view
- Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more
- Organize your data. Search, sort, and filter huge amounts of information
- Illustrate trends. Bring your data to life with charts and graphics -- including miniature charts called Sparklines
- Examine your data. Summarize information and find hidden patterns with pivot tables and slicers
- Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online
- Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save
Passar bra ihop
De som köpt den här boken har ofta också köpt Pro WPF 4.5 in C#: Windows Presentation Foundat... av Matthew MacDonald (häftad).Köp båda 2 för 900 kr
Fler böcker av Matthew MacDonald
Bloggat om Excel 2010: The Missing Manual
Matthew MacDonald is a developer, author, and educator in all things Visual Basic and .NET. He's worked with Visual Basic and ASP since their initial versions, and written over a dozen books on the subject, including The Book of VB .NET (No Starch Press) and Visual Basic 2005: A Developer's Notebook (O'Reilly). He has also written Excel 2007:The Missing Manual, Excel 2007 for Starters: The Missing Manual, Access 2007:The Missing Manual, and Access 2007 for Starters: The Missing Manual, all from O'Reilly. His web site is http://www.prosetech.com.
The Missing Credits; About the Author; About the Creative Team; Acknowledgements; The Missing Manual Series; Introduction; What You Can Do with Excel; The Modern Face of Excel; Excel's New Features; About This Book; Part One: Worksheet Basics; Chapter 1: Creating Your First Spreadsheet; 1.1 Creating a Basic Worksheet; 1.2 Moving Around the Grid; 1.3 A Tour of the Excel Window; 1.4 Saving Files; 1.5 Opening Files; Chapter 2: Adding Information to Worksheets; 2.1 Adding Different Types of Data; 2.2 Handy Timesavers; 2.3 Dealing with Change: Undo, Redo, and AutoRecover; 2.4 Spell Check; 2.5 Adding Hyperlinks; Chapter 3: Moving Data; 3.1 Selecting Cells; 3.2 Making Continuous Range Selections; 3.3 Making Noncontiguous Selections; 3.4 Automatically Selecting Your Data; 3.5 Making Selections with the Keyboard; 3.6 Moving Cells Around; 3.7 A Simple Cut-and-Paste or Copy-and-Paste; 3.8 A Quicker Cut-and-Paste or Copy-and-Paste; 3.9 Fancy Pasting Tricks; 3.10 Paste Special; 3.11 Copying Multiple Items with the Clipboard; 3.12 Adding and Moving Columns or Rows; 3.13 Inserting Columns and Rows; 3.14 Inserting Rows; 3.15 Inserting Copied or Cut Cells; 3.16 Deleting Columns and Rows; Chapter 4: Managing Worksheets; 4.1 Worksheets and Workbooks; 4.2 Find and Replace; Chapter 5: Formatting Cells; 5.1 Formatting Cell Values; 5.2 Formatting Cell Appearance; Chapter 6: Smart Formatting Tricks; 6.1 The Format Painter; 6.2 Styles and Themes; 6.3 Conditional Formatting; Chapter 7: Viewing and Printing Worksheets; 7.1 Controlling Your View; 7.2 Printing; 7.3 Controlling Pagination; Part Two: Formulas and Functions; Chapter 8: Building Basic Formulas; 8.1 Creating a Basic Formula; 8.2 Functions; 8.3 Formula Errors; 8.4 Logical Operators; 8.5 Formula Shortcuts; 8.6 Copying Formulas; Chapter 9: Math and Statistical Functions; 9.1 Rounding Numbers; 9.2 Groups of Numbers; 9.3 General Math Functions; 9.4 Trigonometry and Advanced Math; 9.5 Advanced Statistics; Chapter 10: Financial Functions; 10.1 The World of Finance; 10.2 Financial Functions; 10.3 Depreciation; 10.4 Other Financial Functions; Chapter 11: Manipulating Dates, Times, and Text; 11.1 Manipulating Text; 11.2 Manipulating Dates and Times; 11.3 Math with Dates and Times; 11.4 Date and Time Functions; Chapter 12: Lookup, Reference, and Information Functions; 12.1 The Basic Lookup; 12.2 Advanced Lookups; 12.3 Information Functions; 12.4 Tutorial: Generating Invoices from a Product Catalog; Chapter 13: Advanced Formula Writing and Troubleshooting; 13.1 Conditions in Formulas; 13.2 Descriptive Names for Cell References; 13.3 Variable Data Tables; 13.4 Controlling Recalculation; 13.5 Solving Formula Errors; Part Three: Organi...