Microsoft Excel tips and tricks

• How to reference formulas in same Excel worksheet

  Spreadsheet modellers should take care to remove unneeded mentions of the current worksheet name.

• Talking 'dirty' about volatile functions in Excel

  To speed up Excel workbooks, modellers should plan to keep the number of volatile functions and range names to a manageable minimum.

• 100 quick technology tips

  In celebration of CIMA’s 100th anniversary, this guide provides 100 ways to more effectively use technology such as Excel.

• Smoothing capital expenditure in Excel

  This spreadsheet technique accommodates cyclical, multiyear capital spending, allowing for an accurate year-to-year calculation of cash flows.

• Calculating pre-tax cost of equity in Excel

  This spreadsheet technique could prove helpful when determining the value of an asset.

• Guide spreadsheet users with this Excel tool

  Accountants who build spreadsheet models can employ data validation techniques to improve accuracy and performance.

• Excel range names: What you need to know

  The Name Manager can make spreadsheets easier to follow, but Excel modellers must know how — and, more importantly, when — to properly use the tool.

• Microsoft makes major Dynamic Arrays modifications

  Even before releasing Excel’s new array functionality to the general public, Microsoft has improved one function and replaced another in a move that could put current spreadsheets @ risk.

• How to Excel with past, present, and future data

  With the right toolset of techniques, you can design spreadsheet models that smoothly produce forecast projections using historical and current information.

• Solve problems with linear programming and Excel

  Management accountants can help their companies determine how to make the most of limited resources in myriad situations. This article shows a way.

• Page 1 of 4
• Next 10 Results