MS Excel – My Personal Assistant


When I was about 14 years old, I started playing around with Microsoft Excel 97. I was amazed with it’s functionality – the next year when I started my first job, I began making spreadsheets to forecast my earnings over the next 12 months based on average hours worked (I still have these spreadsheets to this day). Now, I am utilizing Excel on a much higher level. As explained in my last posting, I am working towards creating a “module” within Microsoft Excel 2010 using ODBC technology. What I have learned is that if there is data, you can import it into Excel and make it sing and dance. In many accounting processes, data from a subsidiary ledger is being used to create reports, to calculate accruals and to be reconciled to a General Ledger. I would urge any accountant out there to stop printing out details of these transactions and find a way to use Excel to link to the data source. This way you can setup recurring Journal Entries, Reconciliations, Allocations, and Accruals – making Excel your own personal assistant.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s