How to improve sales and forecasting with Excel and Access - a tutorial
David Carter's tutorial uses a sample database enabling companies to learn how to improve their sales orders and stock control which runs through an accounts package written in Access by live-linking Excel direct to their Access database. His analysis also utilises pivot tables. This is an introduction to a series of four tutorials.
The fact is that companies are still reliant on Excel to run sales and forecasting. The finance director would love to pull all these elements of business technology together and make the system work for him.
To read the rest of the article you'll need to log in below
If you've forgotten your details click here for a reminder.
If you haven't got an account, it's free and it only takes a minute to set one up,
click here to register
- login or register to post comments
- Add to a social bookmarking site
The Bottom Line:If Mr Cable has his way...
"If Mr Cable had his way, all the big banks would be broken up and bonuses would be virtually eliminated - a sure-fire way in my view of guaranteeing an end to the UK’s ability to compete as an international financial centre. Let’s not forget that this is a man who is on record as saying that everyone who works in a bank has an ‘aristocratic lifestyle’ clearly demonstrating his lack of understanding of the sector." A tough line on bankers’ bonuses could make a brain drain of financial talent a distinct possibility, warns Paul Marsden. Read more