Excel

• Excel unveils two new functions

  They aren’t yet generally available, but they look like an X-cellent matched set.

• Meet this year’s teenage Excel champion

  The winner of a global student competition offers simple tips for the average user to get the most out of Microsoft’s spreadsheet application.

• How to reference formulas in the same Excel worksheet

  When it comes to crafting the most effective spreadsheets, modellers are wise to remember that less can be more.

• How to properly date an Excel model

  A formula-based approach can allow spreadsheet modellers to build a full financial time series from just three lines of data.

• MOD-elling periodic transactions in Excel

  Spreadsheet modellers can use the MOD function to obtain residuals and handle calculations at regular time intervals.

• Find the real value with this Excel technique

  Learn the spreadsheet skills necessary to determine pre-tax cost of equity and net present value for assets, businesses, and more.

• 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.

• Page 1 of 5
• Next 10 Results