Microsoft has recently added a new feature to excel in the form of the extremely useful Scan Function. This guide aims to provide a quick overview of how you can get the most from this new function ...

If you are looking to improve your financial modelling skills when using Microsoft Excel spreadsheets you might be interested in this quick overview guide that provides an in-depth exploration of the ...

Q. Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the difference between it and the traditional PivotTable? With the PIVOTBY function, ...