Microsoft Excel tips and tricks

• An Excel approach to calculate depreciation

  The OFFSET function can assist accountants with creating a spreadsheet-based schedule of depreciation.

• Will Dynamic Arrays kill Data Tables, PivotTables?

  In the final instalment of a seven-part series, Excel MVP Liam Bastick wraps up his examination of Excel’s new Dynamic Arrays capabilities by assessing how they could affect Excel features Data Tables and PivotTables.

• Focus on 2 new Excel functions: UNIQUE and FILTER

  In Part 5 of a seven-part series, Excel MVP Liam Bastick takes a look at two of the seven new functions Microsoft has created to go with its spreadsheet program’s new Dynamic Arrays capabilities.

• Excel new function focus: SEQUENCE and RANDARRAY

  In Part 6 of a seven-article series, Excel MVP Liam Bastick explores two of the seven new functions Microsoft has created to go with its spreadsheet program’s new Dynamic Arrays capabilities.

• This Excel change is more than SORT of a big deal

  In Part 4 of a seven-part series, Excel MVP Liam Bastick takes a look at two of the seven new functions Microsoft has created to go with its spreadsheet program’s new Dynamic Arrays capabilities.

• Excel: 2 new errors and a SINGLE function

  What happens when something goes wrong related to Excel’s new Dynamic Arrays capabilities? Excel MVP Liam Bastick takes a look in this instalment of a seven-part series.

• Excel: Arrays, Tables, and ‘The Twilight Zone’

  In this instalment of a seven-part series, Excel MVP Liam Bastick explains how the new Dynamic Arrays capabilities work and how they interrelate with the application’s Tables functionality.

• Excel: Microsoft unveils Dynamic upgrades

  In the first instalment of a seven-part series, Excel MVP Liam Bastick introduces the first major leap forward to spill from Microsoft’s partial rewrite of its spreadsheet application’s “calculation engine”.

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

• Page 1 of 3
• Next 10 Results