This post follows on from an earlier one, 5 Lessons I didn't learn until I ran my own business where I listed the top lessons I have learned since starting my own business nearly 10 years ago. I promised I would revisit them in more detail later, so here goes with Lesson 1.
Lesson 1: The salesmen and women were right. Sales must come first.
This is a tough one to swallow from a financial background. I am sure we've all at times thought that salesmen are so full of themselves, thinking that the whole business should revolve around them. They would always think that they are key to the business and we financial people are just overheads. Well, although I wouldn't go that far, there was a lot of truth in what they said.
No matter how fantastic our back-office systems and processes are, they are still a cost. By making them better, we can reduce that cost, but not eliminate it.
As accountants we should know better than anyone,
Profit = Sales - Costs
If we are being paid our wages, then costs must be positive and it doesn't matter how much we reduce costs, profits will be negative unless sales exceed them.
Like many of us from an accounting background, I followed my instincts and set up all of the back office processes straight away. Thereby creating overheads before sales and guaranteeing early losses.
Starting over I would do it differently. Believe me, it's a lot nicer problem to have sales flooding in and a need to set up processes to account for them, than to have overheads to pay and a need for sales to meet them.
If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates and your free report.
Search Not Just Numbers
Wednesday, 13 October 2010
Tuesday, 5 October 2010
An Introduction to working with dates in Excel
I find that many clients are quite comfortable working with financial figures in Excel, but don't know how useful Excel can be when manipulating dates.
I thought that it might be useful to provide a short post on some of the most useful functions for handling dates in Excel.
One of the simplest functions is the TODAY function, which can be used on its own or within another formula to return today's date. It has no arguments and is essentially a variable (Excel still requires empty brackets after it so that it has the same format as other functions)..
Example:
=TODAY() will display today's date in the cell
I covered YEAR, MONTH and DAY in an earlier post. These allow you to return the year, month or day respectively (as a number).
Examples:
Where cell A1 contains the date 5th October 2010,
=YEAR(A1) returns 2010
=MONTH(A1) returns 10
=DAY(A1) returns 5
WEEKDAY allows you to identify the day of the week (as a number) of any date. It has two arguments, the first being the date you wish to use and the second (optional) argument being the number 1,2 or 3 depending on how you want to number your days.
1: Sunday=1 through to Saturday=7
2: Monday=1 through to Sunday=7
3: Monday=0 through to Sunday=6
If this argument is not entered then it defaults to setting 1.
Examples:
Where cell A1 contains 5th October 2010 again (a Tuesday),
=WEEKDAY(A1) returns 3
=WEEKDAY(A1,1) returns 3
=WEEKDAY(A1,2) returns 2
=WEEKDAY(A1,3) returns 1
I hope this has made you feel a little more comfortable when working with dates in Excel.
Don't forget if you want to take the even easier route, we can build your spreadsheet for you at Spreadsheets by Email.
If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates and your free report.
I thought that it might be useful to provide a short post on some of the most useful functions for handling dates in Excel.
One of the simplest functions is the TODAY function, which can be used on its own or within another formula to return today's date. It has no arguments and is essentially a variable (Excel still requires empty brackets after it so that it has the same format as other functions)..
Example:
=TODAY() will display today's date in the cell
I covered YEAR, MONTH and DAY in an earlier post. These allow you to return the year, month or day respectively (as a number).
Examples:
Where cell A1 contains the date 5th October 2010,
=YEAR(A1) returns 2010
=MONTH(A1) returns 10
=DAY(A1) returns 5
WEEKDAY allows you to identify the day of the week (as a number) of any date. It has two arguments, the first being the date you wish to use and the second (optional) argument being the number 1,2 or 3 depending on how you want to number your days.
1: Sunday=1 through to Saturday=7
2: Monday=1 through to Sunday=7
3: Monday=0 through to Sunday=6
If this argument is not entered then it defaults to setting 1.
Examples:
Where cell A1 contains 5th October 2010 again (a Tuesday),
=WEEKDAY(A1) returns 3
=WEEKDAY(A1,1) returns 3
=WEEKDAY(A1,2) returns 2
=WEEKDAY(A1,3) returns 1
I hope this has made you feel a little more comfortable when working with dates in Excel.
Don't forget if you want to take the even easier route, we can build your spreadsheet for you at Spreadsheets by Email.
If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates and your free report.
Wednesday, 29 September 2010
5 Lessons I didn't learn until I ran my own business
When I worked in other people's finance departments I thought I knew everything about business. When I set up my own consultancy business nearly 10 years ago, there was no stopping me. Some lessons can only be learned the hard way. I thought it might be worth picking out the areas where my thinking has changed dramatically in the last 10 years.
All of the lessons below have been learned since I set out into the wild world of business as that fresh-faced, and incredibly naive, 30 year-old. Education can be very expensive!
I will elaborate on some of them in future posts but for now I just want to put them out there and see what others think - particularly those still working in finance departments.
Lessons I didn't learn until I ran my own business:
If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates and your free report.
All of the lessons below have been learned since I set out into the wild world of business as that fresh-faced, and incredibly naive, 30 year-old. Education can be very expensive!
I will elaborate on some of them in future posts but for now I just want to put them out there and see what others think - particularly those still working in finance departments.
Lessons I didn't learn until I ran my own business:
- The salesmen and women were right. Sales must come first.
- Flexibility is far more valuable than you think.
- It's not about how you look - it's about what you do.
- Cash flow and profitability must come before any other ambition you have for the business.
- Never mistake an overhead for a sign of success.
Please comment below whether you agree or disagree. It would also be interesting to know which perspective you are coming from - i.e. whether you are running your own business or not.
If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates and your free report.
Wednesday, 1 September 2010
Where and when are you at your most creative?
As "number-crunchers", it is easy to fall into the trap of thinking that what we do is not creative. However, to do our jobs well, we need to regularly come up with new approaches to doing things and creative solutions to business or financial challenges - whether that be a creative spreadsheet solution or an innovative structure for an acquisition.
I often find that my best moments of creative inspiration happen when I am out of the work environment altogether. I have had many a flash of genius while lying in the bath!
Recently I have taken to an early morning walk before work that takes in a quiet hillside not far from my house (I took this photo just the other morning). I find that the combination of the quiet (apart from the birds singing), the beautiful views and the exercise really help me to put whatever challenges I might have into perspective and allow me to come at them from a different angle.
I'd love to hear where and when you feel at your most creative.
If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates and your free report.
I often find that my best moments of creative inspiration happen when I am out of the work environment altogether. I have had many a flash of genius while lying in the bath!
Recently I have taken to an early morning walk before work that takes in a quiet hillside not far from my house (I took this photo just the other morning). I find that the combination of the quiet (apart from the birds singing), the beautiful views and the exercise really help me to put whatever challenges I might have into perspective and allow me to come at them from a different angle.
I'd love to hear where and when you feel at your most creative.
If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates and your free report.
Subscribe to:
Posts (Atom)

