Stay up to date with all of our latest news, events and offers by signing up to our NewsletterSignup
Join IASeminars for an immersive 8 day in-depth learning experience
Free Sampler Course
IASeminars IPSAS and US GAAP Online
Don't Miss Out
Join us in London for
IFRS Technical Update
Excel tips and techniques bought to you from the experts!
In almost every industry Excel plays a significant part in everyday operations, none more so than the accountancy sector. It is vital for planning, budgets and forecasting.
We’re scoured the web to find all the latest excel tips to help you make the most of this excellent tool!
Want to know more about formulas? The right ones can save you hours of time and Accounting Today with Wise Owl have two functions they go into in more detail; IF and VLOOKUP.
If you’re keen to know a bit more about formulas, this article covers everything from =TRIM to =CONCATENATE.
Robert Half identifies some great time saving tips shortcuts that help with formatting and also talks through manipulation of data with PivotTables.
If you want to find out even more about PivotTables, then this great article from AccountingWeb covers all the basics you need to know and the ability they have to really open up the reporting of financial data in Excel.
Ever tried a TreeMap before? This new chart in Excel is a bit like a square pie chart but allows you to also show a hierarchy. This useful article shows you how to set one up.
It’s not all about the figures! Having an easy to read spreadsheet is vital and an excellent design will go a long way. This short video covers some ideas on how to make your spreadsheet ‘pop’!
For regular in-depth news and views from IASeminars, sign up to our fortnightly eNewsletter.