Get the most out of Excel with these how-to articles, videos and sample spreadsheets
Power Query is an underutilised Excel tool. Here are a few user interaction tips to add flexibility to your queries.
A variance chart plots both monthly and year-to-date variances for two metrics over time. Here's how to create a variance chart in Excel.
Excel is known for the power of its numeric calculations, but it can also perform calculations based on dates and times.
Capturing logic in a row, then referring to it in a formula, can halve the length of your formulas and stop you getting head spins.
Excel has become a powerful data manipulation and reporting package, and as its functionality has grown, so have the number of shortcuts that enable users to save time. Read on for some handy Excel shortcuts.
Scanning across information is much easier when you can quickly highlight a row. Here’s how.
New features have transformed Excel into a business intelligence tool with some surprising and very powerful applications.
Validation tasks are simpler when you use a centralised validation sheet and formulas that account for rounding errors.
Excel remains popular because it is continually being updated but it can be difficult to stay on stop of all the updates and how they might work best for you. There are some Excel functions that I believe all accountants should know and the following updates will be ones they want to use:
You can create sentences, codes, and more in Excel 2016 using two text functions, CONCAT and TEXTJOIN.