Ebook: Excel 2010 for dummies quick reference
Author: Banfield Colin, Walkenbach John
- Tags: Business--Computer software, COMPUTERS--Desktop Applications--Spreadsheets, Spreadsheet software, Business--Computer programs, Electronic spreadsheets, Electronic books, Microsoft Excel (Computer file), Business -- Computer programs, COMPUTERS -- Desktop Applications -- Spreadsheets, Microsoft Excel (Computer software), Business -- Computer software
- Series: For dummies
- Year: 2010
- Publisher: Wiley Pub
- City: Hoboken;NJ
- Language: English
- pdf
Furnishes answers to frequently asked questions about Excel 2010, encompassing information on building workbook files; adding, copying, and deleting worksheets; entering and editing data; creating formulas and functions; and formatting spreadsheets.;Front Matter -- Introduction -- Basic Information. Excel in a Nutshell -- Basic Facts about Formulas -- Working with Names -- Using Functions in Your Formulas. Introducing Worksheet Functions -- Manipulating Text -- Working with Dates and Times -- Counting and Summing Techniques -- Using Lookup Functions -- Tables and Worksheet Databases -- Miscellaneous Calculations -- Financial Formulas. Borrowing and Investing Formulas -- Discounting and Depreciation Formulas -- Financial Schedules -- Array Formulas. Introducing Arrays -- Performing Magic with Array Formulas -- Miscellaneous Formula Techniques. Intentional Circular References -- Charting Techniques -- Pivot Tables -- Conditional Formatting and Data Validation -- Creating Megaformulas -- Tools and Methods for Debugging Formulas -- Developing Custom Worksheet Functions. Introducing VBA -- Function Procedure Basics -- VBA Programming Concepts -- VBA Custom Function Examples -- Appendixes. Appendix A: Excel Function Reference -- Appendix B: Using Custom Number Formats -- Appendix C: Additional Excel Resources -- Appendix D: What's on the CD-ROM? -- Index -- Wiley Publishing, Inc. End-User License Agreement -- Power Utility Pak v7.
Download the book Excel 2010 for dummies quick reference for free or read online
Continue reading on any device:
Last viewed books
Related books
{related-news}
Comments (0)