This follow-up article on the use of Excel AGGREGATE SUM introduces the added complexity of error cells, text cells or other erroneous cells that would cause errors with a standard Excel SUM function.
Using Excel Styles for Dynamic Color Formatting
The use of Excel Styles to create dynamic color coding in business planning, is a great way to achieve uniform, robust and seamless color formatting. Once implemented, the spreadsheet user can quickly modify the Style (i.e. fill color), as opposed to cycling through the entire workbook and changing each instance of the color format.
Excel AGGREGATE, not Excel aggravate!
The simple SUM function is an adequate tool to aggregate a data array in a financial model. However there are some financial spreadsheets that will require a more robust Excel function, in order to provision for hidden rows, error values, and nested SUBTOTAL and AGGREGATE function cells.
The use of Excel AGGREGATE with SUM as the function syntax, depending on the Option selected, in terms of which values to disregard in the evaluation range for the function, will overcome certain problems with aggregating a data range.
Excel Fill Handle with Various Data Series
The Excel Fill Handle can increase accuracy, efficiency and speed of a data input series across integer, date and other cell formats.
Can You Handle It?
The Excel Fill Handle, along with the drag-and-drop editing, are helpful apparatus for seasoned financial professionals. By hovering the mouse over a cell or range of cells, a financial modeller can copy a cell or range of cells in a few time-saving ways. Additionally the fill handle can fill adjacent cells with a series of data, not to mention cell styles or cell formats.
Applying Conditional Cell Formatting in Financial Modelling
The Excel Conditional Cell Formatting tool is a powerful, yet often underutilised tool in financial modelling. The following blog and two videos will outline its value in a financial model.