Index
A
- add-in, in Excel
- creating / How to do it...
- working / How it works...
- example / There's more...
- Alt + F11 / How to do it..., How to do it..., How to do it..., How to do it...
- animations, Excel graphs
- adding to, steps / Getting ready, How to do it...
- working / How it works...
- assest depreciation
- Partial-Period Declining Balance method / Introduction
- calculating / Calculating the depreciation of assets
- Excel worksheet, setting up / How to do it...
- working / How it works...
B
- box and whisker plot
- about / Creating a box and whisker plot
- creating / How to do it...
- working / How it works...
- data, formatting / There's more...
C
- cells, locking
- in grid / See also...
- extra data series, adding / There's more...
- Change Chart Type window / How to do it...
- chart overlay
- creating / Creating a graph overlay for profit and expenses, How to do it...
- working / How it works...
- color-counting functionality
- using, in Excel / Counting by colors instead of numbers, How to do it...
- working / How it works...
- conditional messages
- about / Directing entry with conditional messages
- entry message, creating / How to do it...
- working / How it works...
- CSV / Introduction
- Ctrl + F11 / How to do it...
- Ctrl + Shift + Enter / How to do it..., How to do it...
D
- dashboard, for VBA financial functions
- creating / Creating a dashboard for financial functions while minimizing Excel, How to do it...
- UserForm, working / How it works...
- CommandButton, using / Different buttons
- data format
- redefining / How to do it...
- working / How it works...
- data list
- blanks, highlighting / Highlighting the blanks in a list of data, How to do it..., How it works...
- data list, importing from Web
- steps / Introduction, How to do it...
- about / Importing data lists from the Web
- working / How it works..., There's more...
- suggestion / A helpful suggestion
- Data Validation window / How to do it...
- data visual representation
- about / Introduction
- date conversion, code used
- about / Converting dates with code
- steps / How to do it...
- working / How it works...
- Design tab / There's more...
- discount proration
- calculating, from payment date / Discounting proration by payment date, How to do it...
- working / How it works...
E
- Excel
- print visibility, increasing / Making printing easier to read
- financial data, splitting / Splitting financial data
- data format, redefining / Redefining the data format
- in-worksheet functionality / Introduction
- IF statement, analyzing with / Getting ready
- DATEDIF function / There's more...
- invoice, emailing / E-mailing an invoice from Excel, How to do it..., There's more...
- payment functions, analyzing / How to do it...
- functionalities / Introduction
- add-in, creating / Highlighting user edits and storing the versions
- Excel calculations
- about / Correcting Excel calculations
- correcting / Getting ready
- correcting, steps / How to do it...
- working / How it works...
- Excel formula
- creating / Getting ready, How to do it...
- Excel graphs
- animations, adding to / Adding animations to Excel graphs
- Excel ribbon
- created enhancements, adding to / How to do it...
- working / How it works...
- Excel spreadsheet
- requirements / Introduction
- about / Setting up an Excel spreadsheet
- setting up / How to do it...
- working / How it works…
- print visibility, enhancing / Making printing easier to read
F
- financial data
- about / Splitting financial data
- splitting / Getting ready, How to do it..., How it works...
- combining / Combining financial data, How to do it...
- working / How it works...
- analyzing, pop up tools used / Analyzing financial data with pop-up tools, How to do it...
- pop up tools, working / How it works...
- financial functions security
- username options, adding / Introduction, Adding username and password options for securing financial functions, How to do it...
- working / How it works...
- financial information table
- creating / Creating a table of financial information
- information, viewing with data tables / Getting ready, How to do it...
- data table, working / How it works...
- financial summary formulas
- displaying / Displaying financial summary formulas within their cells, How to do it...
- working / How it works...
- five-number summary
- creating / How to do it...
- working / How it works...
- Font property / How to do it...
- Format graph options / How to do it…
- Formatting window / How to do it...
- formulas, removing
- from, data rows / Removing formulas from a list of numbers, How to do it..., How it works...
- FREQUENCY function / How it works...
G
- graph, adding to e -mail
- automatically, steps / Adding a graph to e-mail automatically, How to do it...
- working / There's more...
- graphing
- about / Introduction
- Graph Merge wizard / Creating a graph overlay for profit and expenses
- grid
- cells, locking / Locking cells in the grid, How to do it...
- working / How it works...
H
- Help button / How it works...
- histogram frequency chart
- requirements / Getting ready
- data, adding to Excel worksheet / How to do it…
- working / How it works...
- uses / There's more...
I
- IF statement
- about / Analyzing with an IF statement, There's more...
- requirements / Getting ready
- analyzing with / How to do it...
- working / How it works...
- invoice
- emailing, from Excel / E-mailing an invoice from Excel
L
- Loan-calculation information
- Excel, using / Calculating loan terms using Excel, How to do it...
- UserForm, working / How it works...
- loan amount with interest
- payment count, calculating / Calculating the number of payments in a loan
- NPER function, working / How it works...
- loan principle
- about / Graphing the principal of a loan automatically
- VBA code, using / Getting started, How to do it...
M
- mini graphs
- adding, to data / Adding mini graphs within the data, How to do it...
- working / How it works...
- gradient colors, using / There's more...
N
- nested-IF statement
- creating / How to do it...
- working / How it works...
- Original Logical test / How it works...
P
- payment functions
- analyzing / Analyzing benefits between interest and payment investments
- working / How it works...
- print visibility
- enhancing / How to do it...
- MOD function / How it works...
- Properties panel / How to do it...
- Protect Sheet window / There's more...
- Protect Worksheet / How to do it...
R
- repetition scale
- adding, directly, within worksheet / How to do it…
- REPT function
- about / How it works…
- using, in Excel / There's more…
- ROW() function / How it works...
S
- sales information, across multiple sheets
- gathering / Collecting user sales data across multiple sheets
- working / How it works...
- mistakes, preventing / Preventing mistakes from an unknown
- Shift + Ctrl + Enter / How to do it…
- splash screen
- personalizing / Personalizing your splash screen
- splash screen personalization
- requirements / Personalizing your splash screen
- steps / How to do it...
- splash.show code, working / How it works...
- UserForm / There's more...
- UserForm images / Images in the UserForm
- standard deviation
- using, for stock determination / Determining standard deviation for assessing risk, How to do it...
- working / How it works...
- calculating / There's more...
- combining, with five-number summary / See also
- stem and leaf plot
- about / Creating a stem and leaf plot
- creating / How to do it...
- working / How it works…
- similarity, with histogram / There's more...
- SUM formula-VLOOKUP formulas combination
- using / How to do it...
T
- ThisWorkbook / How to do it...
- total list payments
- calculating / Getting ready, How to do it...
- user information, collecting / How to do it...
- working / How it works...
- SEARCH function, using / There's more...
- transaction detail
- grouping, in statement of accounts / Grouping transaction details in a statement of accounts, Getting ready, How to do it..., How it works...
- Primary Account / How to do it...
U
- UserForm
- using, for customer help / How to do it...
- working / How it works...
- advantages / There's more...
- multiple options / Multiple userforms
- user information
- about / Entering data via a form
- collecting, code-based UserForm used / Getting ready, How to do it...
- UserForm, working / How it works...
- user interaction validation
- in Excel worksheet / Validating user interaction
- starting with / Getting ready...
- steps / How to do it...
- working / How it works...
- data validation / There's more...
V
- VBA
- using / Introduction
- VB macros
- using, for customer help / Providing customers with on-demand help by using VB macros and a user form
- visible property
- CommandButton, using / Different buttons
- Visual Basic Editor (VBE) / How to do it..., How to do it...
- visual timesheet
- hours, calculating / Calculating hours with a visual timesheet, Getting started, How to do it...
- working / How it works...
- VLOOKUP function / There's more…
W
- web-based forms completion
- requirements / Getting ready
- steps / How to do it...
- working / How it works…
- use, expanding / Expanding the use
- WEEKDAY function
- using, for sales calculation / Calculating total sales by day of the week, How to do it...
- working / How it works..., There's more...
- worksheet-based calendar
- creating, for payment date visual representation / Visualizing payments with a graphical calendar, How to do it...
- working / How it works…, There's more…