Goal: Ledger shading is formatting in which rows alternate cell shading between a light color and a slightly darker color.
DSUMGoal: Use the DSum function sums the numbers in a column or database that meets a given criteria. Attachments DSUM (14 KB)
Goal: To compile a list of the differences between a customer list and an new customer list, resulting in a list of old customers.
Goal: Formulas in Excel can be very long. By using Alt+Enter, you can make your formulas easier to understand and less overwhelming.
This model is designed to value the equity in a stable firm on the basis of free cashflows to equity, especially when they are different from dividends paid. Attachments Free_Cash_Flow_to_Equity (28 KB)
Goal: learn how to lookup more than one occurrence of specified value.
Goal: learn the Excel Hlookup formula learn the Excel Hlookup formula .
Goal: Examining the formulas developed by others, it can often be beneficial to look at the results of a particular portion of a formula.
Goal: Adding the value 666, 6+6+6 adds up to 18!
Sort_Cell_by_ColorExcel allows you to sort the data in your worksheets by any number of attributes. One of the things that you cannot intrinsically sort by, however, is the color of cells. Attachments Sort_Cell_by_Color (26 KB)