Microsoft Excel tips and tricks

• A great function for scenario analysis in Excel

  It might not be the first option you think of, if you think of it at all, but OFFSET can prove very helpful managing ‘what if?’ scenarios in spreadsheet models.

• Tips from a 15-year-old Excel spreadsheet champion

  A young prodigy offers advice on how to sharpen your Excel skills.

• CHOOSE carefully with this Excel function

  Among the many functions for finding data in a spreadsheet, CHOOSE is a viable option but not always the best choice.

• How not to make a mess with VLOOKUP

  Learn the mistakes to avoid while using this popular Excel function to look up data in a table or list.

• Things are looking up with this Excel function

  What’s the best choice when faced with an array of choices for finding specific data in a financial model? Consider this vector analysis.

• In Excel, INDEX MATCH is a winning combination

  When you need to look up data in a spreadsheet and HLOOKUP and VLOOKUP won’t work, another approach might do the job.

• How to not make a mess with VLOOKUP

  Turns out that a favourite Excel function is not as simple to use as many accountants believe.

• Functional beauty: Laying out a proper Excel model

  Learn how to create Excel spreadsheet models that are easy to use and easy on the eye.

• Crafting the best Excel models

  This article explores the four key elements to building exceptional spreadsheet structures.

• New features coming to Excel

  Stock price and geographic data are becoming more readily available in Microsoft Excel. Excel expert Liam Bastick introduces us to the new data types and explains a new function.

• Page 1 of 2
• Next 7 Results