Microsoft Excel 2013 Formulas

Key Features Microsoft Office Excel is the dominant spreadsheet application for the Windows platform. It is an indispensable business tool.The Mr Spreadsheet webpage contains all the templates and worksheets used in the book plus John Walkenbachs award-winning Power Utility Pak. About the Book: Microsoft Excel 2013 Formulas Microsoft Office Excel is the leading spreadsheet application. It is a key module in Microsoft Office, the number-one productivity suite. New, intermediate, and advanced users of Microsoft Office as well as users who are upgrading to Office "X" from an earlier version. Excel master John Walkenbach shows the reader how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Excel "X" Formulas is a invaluable reference for Excel beginners, intermediate users, power users, and would-be power users. Fully updated for the new Microsoft Office release, this latest edition provides comprehensive formulas coverage, Excel tips, tricks, and techniques readers wont find anywhere else. Includes valuable content online with sample files, templates and worksheets from the book. Contents: Introduction PART I: Basic Information Chapter 1: Excel in a Nutshell Chapter 2: Basic Facts about Formulas Chapter 3: Working with Names PART II: Using Functions in Your Formulas Chapter 4: Introducing Worksheet Functions Chapter 5: Manipulating Text Chapter 6: Working with Dates and Times Chapter 7: Counting and Summing Techniques Chapter 8: Using Lookup Functions Chapter 9: Working with Tables and Lists Chapter 10: Miscellaneous Calculations PART III: Financial Formulas Chapter 11: Borrowing and Investing Formulas Chapter 12: Discounting and Depreciation Formulas Chapter 13: Financial Schedules PART IV: Array Formulas Chapter 14: Introducing Arrays Chapter 15: Performing Magic with Array Formulas PART V: Miscellaneous Formula Techniques Chapter 16: Importing and Cleaning Data Chapt