Excel 2010 Financials Cookbook -- Table of Contents -- Excel 2010 Financials Cookbook -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 1. Normalizing Financial Data within Excel -- Introduction -- Setting up an Excel spreadsheet -- Getting ready -- How to do it... -- How it works… -- There's more... -- Correcting Excel calculations -- Getting ready -- How to do it... -- How it works... -- Removing formulas from a list of numbers -- Getting ready -- How to do it... -- How it works... -- There's more... -- Highlighting the blanks in a list of data -- How to do it... -- How it works... -- There's more... -- See also -- Making printing easier to read -- How to do it... -- How it works... -- There's more... -- Splitting financial data -- Getting ready -- How to do it... -- How it works... -- There's more... -- Combining financial data -- How to do it... -- How it works... -- There's more... -- See also -- Redefining the data format -- How to do it... -- How it works... -- There's more... -- Grouping transaction details in a statement of accounts -- Getting ready -- How to do it... -- How it works... -- There's more... -- Displaying financial summary formulas within their cells -- How to do it... -- How it works... -- There's more... -- 2. Analyzing Financial Data-Staying in the Grid -- Introduction -- Analyzing with an IF statement -- Getting ready -- How to do it... -- How it works... -- There's more... -- Advancing what IF analysis scenarios -- How to do it... -- How it works... -- There's more... -- Discounting proration by payment date.

Getting ready -- How to do it... -- How it works... -- There's more... -- Collecting user sales data across multiple sheets -- How to do it... -- How it works... -- There's more… -- Preventing mistakes from an unknown -- Calculating total sales by day of the week -- Getting ready -- How to do it... -- How it works... -- There's more... -- Directing entry with conditional messages -- How to do it... -- How it works... -- There's more... -- Validating user interaction -- Getting ready... -- How to do it... -- How it works... -- There's more... -- See also... -- Locking cells in the grid -- How to do it... -- How it works... -- There's more... -- Calculating total number of payments in a list by an individual -- Getting ready -- How to do it... -- How it works... -- There's more... -- 3. Moving Beyond the Grid-Financial Data Via an Interface -- Introduction -- Personalizing your splash screen -- Getting ready -- How to do it... -- How it works... -- There's more... -- Images in the UserForm -- Entering data via a form -- Getting ready -- How to do it... -- How it works... -- There's more... -- E-mailing an invoice from Excel -- Getting started -- How to do it... -- How it works... -- There's more... -- Adding username and password options for securing financial functions -- Getting ready -- How to do it... -- How it works... -- There's more... -- Providing customers with on-demand help by using VB macros and a user form -- How to do it... -- How it works... -- There's more... -- Multiple userforms -- Calculating loan terms using Excel -- How to do it... -- How it works... -- There's more... -- Creating a dashboard for financial functions while minimizing Excel -- Getting ready -- How to do it... -- How it works... -- There's more... -- Different buttons -- 4. Using Graphs for Financial and Statistical Analysis -- Introduction.

Charting financial frequency trending with a histogram -- Getting ready -- How to do it… -- How it works... -- There's more... -- Creating a stem and leaf plot -- How to do it... -- How it works… -- There's more... -- Creating a box and whisker plot -- How to do it... -- How it works... -- There's more... -- See also -- Creating a graph overlay for profit and expenses -- How to do it... -- How it works... -- There's more... -- Even more... -- Graphing the principal of a loan automatically -- Getting started -- How to do it... -- Adding animations to Excel graphs -- Getting ready -- How to do it... -- How it works... -- There's more... -- Adding a graph to e-mail automatically -- Getting ready -- How to do it... -- How it works... -- There's more... -- 5. Representing Data without Graphs -- Introduction -- Visualizing payments with a graphical calendar -- How to do it... -- How it works… -- There's more… -- Creating a five-number summary for analysis -- How to do it... -- How it works... -- There's more... -- See also -- Calculating hours with a visual timesheet -- Getting started -- How to do it... -- How it works... -- There's more… -- Analyzing financial data via repetition -- How to do it… -- How it works… -- There's more… -- Adding mini graphs within the data -- How to do it... -- How it works... -- There's more... -- Creating a table of financial information -- Getting ready -- How to do it... -- How it works... -- There's more... -- See also... -- 6. Building Financial Functions into Excel -- Introduction -- Determining standard deviation for assessing risk -- How to do it... -- How it works... -- There's more... -- See also -- Analyzing benefits between interest and payment investments -- How to do it... -- How it works... -- There's more... -- Calculating the number of payments in a loan -- How do it... -- How it works... -- There's more...

Calculating the depreciation of assets -- Getting ready -- How to do it... -- How it works... -- There's more... -- Calculating the future versus current value of your money -- How to do it... -- How it works... -- There's more... -- Determining the difference between effective and nominal interest rates -- How to do it... -- How it works... -- There's more... -- Identifying the profitability of an investment -- How to do it... -- How it works... -- There's more... -- See also -- Calculating and planning for inventory requirements -- Getting ready -- How to do it... -- How it works... -- There's more... -- 7. Augmenting Excel Functions with Customized Data Mining -- Introduction -- Highlighting user edits and storing the versions -- How to do it... -- How it works... -- There's more... -- Adding financial tools to the Excel ribbon -- How to do it... -- How it works... -- There's more... -- Letting others use the add-in -- Completing web forms -- Getting ready -- How to do it... -- How it works… -- There's more… -- Expanding the use -- Importing data lists from the Web -- How to do it... -- How it works... -- There's more... -- A helpful suggestion -- Counting by colors instead of numbers -- How to do it... -- How it works... -- There's more... -- Converting dates with code -- How to do it... -- How it works... -- There's more... -- Analyzing financial data with pop-up tools -- How to do it... -- How it works... -- There's more... -- Index.