Skip to content
Microsoft Excel tips and tricks
When you need to look up data in a spreadsheet and HLOOKUP and VLOOKUP won’t work, another approach might do the job.
Turns out that a favourite Excel function is not as simple to use as many accountants believe.
Learn how to create Excel spreadsheet models that are easy to use and easy on the eye.
This article explores the four key elements to building exceptional spreadsheet structures.
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.
Excel expert Liam Bastick derives a formula to display the name of the workbook automatically.
Build exceptional spreadsheet structures by keeping these 4 key attributes in mind.
Excel expert Liam Bastick looks at the difference between Formats and Styles.
Use Microsoft Excel’s built-in regression capabilities to turn historical data into an initial rough-draft budget.
Excel expert Liam Bastick shares quick and easy formulas for modelling credit card and other debts.
Excel expert Liam Bastick has details on valuable ways to use IF, a key function when creating financial models.
The PivotTable is one of the most powerful tools in Excel. Take this quiz to find out how well you know this feature.
