Get the most out of Excel with these how-to articles, videos and sample spreadsheets
Fine-tuning your date tables with public and school holidays could help improve forecasting accuracy and add an extra level of useful information.
Flexibility and constant updating lie at the heart of Excel’s success, says Neale Blackwood CPA, who in October 2017 marked 15 years of writing Excel Yourself columns for INTHEBLACK.
The SUBTOTAL function is the smarter option when it comes to calculating grand totals in Excel.
Upgrade your skills and use Excel’s visualisation capabilities to add bling to your presentations and make them more effective.
Charts are a fast way to visualise data, and with Excel 2016 creating a waterfall chart is easy.
Handling multiple data sets can often be a complex task, but with a few simple steps using Excel’s Power Query, importing and organising your data couldn’t be simpler.
This solution formula combines advanced techniques to summarise values from a reasonably common layout.
The little used but versatile MOD function in Excel can be used to specify end-of-quarter dates and even handle periodic payments.
Take the time to learn new Excel skills and functions. Not only will it cut your workload, it might earn you a promotion, says a management accountant-turned Excel expert.
Excel’s CurrentRegion command can be used to create dynamic ranges in a macro for an advanced filter, making your code more useful and flexible.
Get a handle on Relationships with Excel 2013's Data Model feature and create PivotTable reports with ease.
When you need to filter out unwanted items in an Excel spreadsheet, the versatile solution is to bring out the Slicer.
The VLOOKUP function is an extremely useful tool, so ensure you know how to avoid common pitfalls.
Common reasons for the #N/A error - and the way to deal with this problem when it arises.
A series of formulas can help solve the problem of working out pay levels or salaries for various job classifications.
Make it easier to see where data belongs - or is missing - by setting up and using consistent Styles throughout your Excel files.
Helpful and easy to use, Flash Fill is an Excel superhero that often flies under the radar.