Microsoft Excel tips and tricks

• Ideas for data analysis in Excel

  The AI-powered tool lives up to its name by generating visualisation options from data.

• Top 5 Excel functions you might not know

  Our Excel MVP unveils a fistful of functions that pack a real punch.

• Converting dates to and from US format in Excel

  Working with a spreadsheet from a country where the date format differs from yours can cause real problems. Here’s how to solve them.

• Prorating over time in Excel

  Avoid building a complicated formula in your model with a ‘step it out’ approach.

• Excel adds new argument to XLOOKUP

  Though not yet generally available, the new function gets a rare syntax shakeup.

• How to build an Excel model for revising forecasts

  With a little algebra and a lot of flexibility, spreadsheet builders can set up a forecasting model that handles simultaneous changes in multiple parameters.

• Excel unveils function that improves on VLOOKUP

  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.

• Page 1 of 5
• Next 10 Results