Search Not Just Numbers


Saturday, 1 August 2009

Excel Resources for Accountants

by Glen Feechan

Now that Not Just Numbers has been running for a while, I thought that it might be useful to pull together a number of the Excel resources available on the blog and from the Feechan Consulting Group.

Regular readers will know that I am a big fan of Pivot Tables and you can learn how to set one up with the following videos:

Free Excel 2003 Pivot Tables Video
Free Excel 2007 Pivot Tables Video

If you want to learn about Pivot Tables in more depth, there are two video training courses available from Feechan Consulting:

Introduction to Pivot Tables course
Advanced Pivot Tables Course

Sometimes a pivot table is great for doing the number crunching, but you wish to use the results in a more flexible layout - for example, a management accounts format. To do this you will need the GETPIVOTDATA function:

Excel Tip: Using GETPIVOTDATA (part 1)
Excel Tip: Using GETPIVOTDATA (part 2)

Pivot tables come into their own when analysing large amounts of data, which can come from existing software packages:

Why all finance directors need to know about ODBC

Or be keyed in:

Using Excel Pivot Tables with manual records

Often you need to look up data from elsewhere within a spreadsheet, maybe to add new data to the source data for a pivot table. To do this you use the VLOOKUP function:

Excel Tip: Using VLOOKUP
Learn VLOOKUP with this short, free video tutorial

A couple of other useful tips with many applications are given below:

Excel Tip: Dropdown boxes in Microsoft Excel
Excel Tip: Reporting by year or month

Although I try to avoid macros where possible, sometimes you just need to automate a repetitive task:

Free Video: Record a Macro in Excel

A number of useful functions are discussed above, but here is a useful way to get to grips with an Excel function:

Excel Tip: Use any Excel function in seconds

For a useful application that ties many of these techniques together, have a read of:

Do your management accounts take weeks, days, hours, minutes…or seconds to prepare?

If you still don’t feel you are able to produce the spreadsheet you want, or you don’t have the time, why not get us to do it for you – quickly and cost-effectively with Spreadsheets by Email?

Or if your requirements are more complex, including reporting from your own systems, call Feechan Consulting.

If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates, our monthly ezine and your free report.

1 comment:

  1. This unique developed jewel bearings somewhat more inexpensive at the beginning, and then the design changes through framing fake chanel ways finished this period found suggested construct y are nowadays potential even on a grander dimensions. Increasingly watchmakers began to employ them throughout their activity, not to mention the sheer number of bearings have got to always be 'jewelled' through every different calibre even raised. One match up was basically frequently omega replica sale endorsed turn out to be 18 jewelry, and / or twenty one should capstones are used with typically the 3 top to bottom bearings. But, for the reason that follow clarity raised during the 20th one particular hundred year, it again had become more demanding for the purpose of follow stores towards promise features finished his or her's rivalry. Typically the painstaking, and yet sophisticated breitling replica uk give good results who attended towards the end shifts even on a circulation are more demanding to showcase as opposed to awesome sounding 'jewelled bearings' filled with rubies not to mention sapphires, because of this follow organisations began to obtain attention to the sheer number of jewelry typically the calibre enclosed. as an alternative definitely, this unique trigger spiralling variety of jewel bearings using them through follow systems. Looking for a purpose, i doubt any from gucci replica such bearings delivered any sort of proper characteristic, a lot of would not genuinely reach any sort of moving forward regions. Typically the fashion come to her stature in your 1960s, with the most famous increasingly being typically the Waltham 100 jewel follow, of which believe it or not enclosed an average 18 jewel circulation, with the help of 83 hour synthetic rubies inserted decoratively in your mechanical rotor.