Excel

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

• Things are looking up with this Excel function

  When it comes to searching for dates in a spreadsheet, LOOKUP may be the best choice.

• Use this Excel tool to guide spreadsheet users

  Data validation can help set the proper parameters for Excel models to deliver the desired results.

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

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

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

• Page 1 of 3
• Next 10 Results