Based on a series of user case studies and interviews, Rod Newing puts the case for using data analysis to improve commercial decision-making.
Hello Excel experts.
We've recently bought TAS Accounts for our small company in Shepherds Bush, but looking for some training as the TAS doesn't have courses available.
When I export in csv file from either Sage or TAS, Excel swaps the month and day for any day up to 12 eg 03/04/2012 becomes 04/03/2012 but 15/04/2012 will not change.
I have a spreadsheet on Excel, a sort of time sheet. If I put in a client reference it fills in the client name using VLOOKUP. However, later when I need to find what I did for a certain client I
This is a relatively straight forward concept but I've been going round and round in circles!!!
Client has purchased a van for 5,754
Interest amount is 1,517.72
A Surgeon friend of mine has been attending medical conferences overseas to deliver his expert knowledge to his audience (part of his CPD). He had to fund the travel himself since his employer ref
I only recently started my practice (September 2012), it has been a struggle to get new clients and despite my efforts getting a little frustrated
- New Range Name features in Excel 2007. By Simon Hurst 463,278 6
- Want to learn about Excel pivot tables? Start here. By David Carter 116,707 6
- Exporting data from Sage Line 50 into Excel #1. By David Carter 96,404 11
- ExcelZone's Five Minute Pivot Table Tips - Index 91,132
- Tutorial:.... Budgeting with Pivot Tables #1 [Excel 5 to 97] 73,376 2