Microsoft Excel tips and tricks

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.

Automating in Excel: a worksheet display tip

Excel expert Liam Bastick derives a formula to display the name of the workbook automatically.

How to craft the best Excel spreadsheet models

Build exceptional spreadsheet structures by keeping these 4 key attributes in mind.

How to make prettier, more readable Excel spreadsheets

Excel expert Liam Bastick looks at the difference between Formats and Styles.

A methodical approach to budget

Use Microsoft Excel’s built-in regression capabilities to turn historical data into an initial rough-draft budget.

How to use Excel for practical debt repayment calculations

Excel expert Liam Bastick shares quick and easy formulas for modelling credit card and other debts.

How to make better use of Excel’s IF function

Excel expert Liam Bastick has details on valuable ways to use IF, a key function when creating financial models.

Quiz: How well do you know Excel PivotTables?

The PivotTable is one of the most powerful tools in Excel. Take this quiz to find out how well you know this feature.

Previous 10 Results
Page 5 of 5

Microsoft Excel tips and tricks

Most Read