X

Blog Article

Excel tips and techniques bought to you from the experts!

Thursday 14 February 2019

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!

Formulas 

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.

Read more

If you’re keen to know a bit more about formulas, this article covers everything from =TRIM to =CONCATENATE.

Read more

Timesaving Tips

Robert Half identifies some great time saving tips shortcuts that help with formatting and also talks through manipulation of data with PivotTables.

Read more

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.

Read more

TreeMap Chart

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.

Read more

Spreadsheet Design

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’!

Read more  

About the Author

Related Articles

Take your accountancy career up a notch

In any career it’s easy to get stuck in a rut and wonder what you can do to progress to the next le...

Read More >

New Year, A New Better You

January is certainly the time to think ahead for the rest of the year and all of us are full of good...

Read More >

Online learning: is it for you?

Maybe you’ve tried an online training course in the past or are completely new to the concept? Work...

Read More >

Have you set your personal and professional development goals for 2018 yet?

Over the past two or three years so much has changed in the accounting profession. For many of us it...

Read More >

From Bean Counter to Trusted Business Partner

Are you a management accountant who is stuck in the back office? You want to get out of the number c...

Read More >

Stay Updated with IASeminars

Join 20,000+ other professionals on our global mailing list.

Settings