Excel 2010 Financials Cookbook
Format: PDF / Kindle (mobi) / ePub
The Cookbook format means each technique is explained with step-by-step instructions, and you can jump straight to the techniques you need. You won't need to read this book from start to finish in order to get value out of it. This book is for anybody who wants to use Excel to manage their revenues, budgets, and other financials. It's especially suitable for small businesses that already use Excel and want to get more from it.
information is being entered by a user, providing messages dependant on the information becomes extremely useful. In this recipe, you will learn to use IF statements to provide messages to users depending on presented information. This recipe will utilize a worksheet with three input fields. When a field entry is below a set threshold, conditional messages will warn the user that the field value must be greater. How to do it... To begin, we will create an entry message for Input 1: 1. Select
intRate As String strPass = "changerate" strUser = InputBox("Please enter your password:", "Password") If strUser = strPass Then 87 Moving Beyond the Grid—Financial Data Via an Interface intRate = InputBox("Enter new interest rate:", "Rate") ActiveWorkbook.Sheets("Sheet1").Activate Range("B8").Select ActiveCell.Value = intRate Else MsgBox "You do not have rights to change the rate", vbOKOnly, _ "Incorrect Password" Exit Sub End If End Sub 3. While still within the VBE, from the toolbar choose
filters in the column headers, you are able to filter the information and find specific pieces of information within the large data set. 170 Chapter 5 There's more... The visual template that has been applied to Excel can be changed by selecting a new table template, which appears under the Design tab in the ribbon after selecting the table. Data tables created in Excel 2010 will work within earlier versions of Excel; however, the visual template will not be available, and a less-advanced
correct. What went wrong? This recipe will show you how two of the same formulas can provide different answers, and how to "correct" Excel to display the same answer as shown on your calculator. Getting ready In Excel, we will start with a spreadsheet with two-value columns and a formula column. Column C, the formula column, uses conditional formatting that highlights the cells with a yellow color whenever they equal 0.007. Conditional formatting allows the use of conditions such as cell value,
the cell position or delete that row. 39 Analyzing Financial Data—Staying in the Grid Value if true: "Bad" If the comparison from the logical test is true, Excel displays the word Bad. Bad is enclosed in quotation marks to make Excel treat the word as text. Value if false: "Good" If the comparison from the logical test is false, Excel displays the word Good. Again, Good is enclosed in quotation marks to ensure the word is treated as text. The comma separates the different parts of the