Excel

Improve your reporting skills with self-teach tutorials.

A good way to improve your skills with a package is by working your way through a practical example on the keyboard.

Time for accountants to break up the BI party. By David Carter

After attending his latest BI demonstration, David Carter has finally lost patience. This nonsense has got to stop.

Webcast on financial presentations in Excel and other aids

If ever you are stuck for things to do for an hour or two, you can always rely on the Microsoft Office website

Microsoft issues Office file blocking and disinfection tools

Microsoft has released two utilities to designed to make it easier for Windows users to protect themselves from Office files that may contain malicious software.John Stokdyk reports

Excel compendium - importing and exporting. By Simon Hurst

Importing

Microsoft exec announces a new era in business intelligence. Again

Earlier this month, Microsoft hosted a conference on business intelligence in Seattle to reinforce the message that it is going to provoke a major shake-out.

Test version launched for new Excel reconciliation tool

Former management accountant Jim Johnson has turned his hand to programming to create Isolist, an Excel-based reconciliation tool for accountants. John Stokdyk reports.

Northwind Traders Tutorial #4 : Add cost prices and margins. By David Carter

In the earlier parts of this series you extracted data from Northwind's Access data by live linking it to Excel.

Excel 2min Tip #6. Add up rows and columns quickly with Autosum

Just finished putting together a budget and want to add up the rows and columns?

Suppose your budget fills cells A1 to L10.

Northwind Traders Tutorial #3: Create sales reports with pivot tables. By David Carter

With the new Daybook worksheet set up via MS Query, David Carter now uses Excel pivot tables to create reports on sales by customer, by area, and by product group.

Excel

Pages