Lace your customers shoes (with Excel)

Lace your customers shoes (with Excel)
Last month I had the privilege of presenting for over 6000 people at a business seminar along with some great speakers like Colin Boyd and Don Peppers – the topic was “Achieving”. The best thing about presenting at a seminar like this is you get to hear the other presenters and learn something yourself – and one thing that Don Peppers said has had me thinking ever since. It was a story he told about a shoe company that shipped their shoes with the la

The spreadsheet evolved but we didn’t

The spreadsheet evolved but we didn’t
Prior to 3000BC, there was really no need for spreadsheets.  It was a world without money where the standard practise was to barter. Humans of those days bartered anything they had at hand.  Different ones produced different things and services and swapped them for other things they needed to get through.  While this worked for a good while, the system started to outgrow the demands people where putting on it - for example, imagine this conversation:

Torn Paper Effect in PowerPoint

Torn Paper Effect in PowerPoint
First of all - this is the exact image we will be creating in this tutorial - as you can see, we have the torn paper effect applied to letters and an image: Step 1 Step 2 Step 3   Step 4   Step 5 Step 6 Step 7 Step 8 Step 9 Step 10   Repeat the process for any other items you want to apply this effect to, except you won't need to download a second copy of the image - you can reuse it as many times

Do you know your formulas? What about your brackets?

Do you know your formulas?  What about your brackets?
Like commas in sentences, (Brackets) change the meaning of an Excel formula… Lets eat Grandma... would be enough to send her running, but Lets eat, Grandma... would have the exact opposite result. In formulas: 5+2 *3 = 11 and (5+2)*3 = 21 Two very different results, and the only difference is the brackets - if you are trusting yourself or employees to use Excel without proper training, check their skills today and reduce the chances of...

The Survivalist Attitude and Microsoft Office

The Survivalist Attitude and Microsoft Office
Giving employees the right tools to do their job is often quoted as a key component of keeping them happy and retaining them in the business, but from an employee's perspective, when faced with a situation in your job where you don't have the right tools, what do you do?  Obviously for tradesmen, this is probably key and vital, but as an office worker, you really only have two options - either stall, or get into the survivalist mode. You could call it i

11 basic Excel tricks that really will change your life

11 basic Excel tricks that really will change your life
Business Insider recently published an article, which you can read here, which claims to give you 11 basic Excel tricks which will change your life - I have to disagree on some of them - here's each of the tips they gave, and what we think they should have told you about. Excel Trick 1) Jump from worksheet to worksheet with Ctrl + PgDn and Ctrl + PgUp This trick lets you move through your sheets without clicking on the sheet tabs - this is smart, but oft

Excel Art – a painting using 224 thousand colour filled cells (and a moral to the story)

Excel Art – a painting using 224 thousand colour filled cells (and a moral to the story)
This picture of an awesome Falcon is made only using the cell fill colours.  Read on to see how this is actually an important message for your business. But first, to prove it, look at these images here: This image shows column EK and row 73 enlarged to show the fill colour This image shows the fill settings for that cell Here is the Excel file you can download and check out for yourself:   But here's the catch... it to...

Goal Alignment Tool in Access

Goal Alignment Tool in Access
If you have read about the 4 Disciplines of Execution from Franklin Covey, you will fully understand the advantages of having your goals right throughout the company aligned - from the top to the bottom. Keeping track of these goals, and actually communicating the goal in a way staff members can see how their goals are aligned is made easy with this Goal Alignment Tool in Access we have made available to you free of charge.  This is how it works. Set u...

Excel Helpdesk – our support statistics

Our Microsoft Office helpdesk service is a valuable tool for busy professionals who don't have time to try and find an answer themselves - of course, people are impatient and want an answer immediately - we've been working on making it easy for you to ask a question, and doing our best to respond as fast as we can - the results?  Here they are: If you still don't have access to our helpdesk, why not subscribe today? Click here now for more information.