See how Excel can protect your life!
Could you protect your IP within Excel? Recently a client came to me and wanted to create a spreadsheet which they then wants to send out to a thousand people. And the obvious question is, how can he or she protect their IP? The short answer is Excel does not really give you lots of protection. What do […]
Racing Excel – When Every Second Counts
Racing Excel – When Every Second Counts Recently a client asked for help with his Excel model. He’d created a very complex and integrated set of sheets within one Workbook. His problem was, that each calculation took between ten and fifteen seconds. It does not sound much – ten seconds… Just imagine yourself entering a simple […]
Do you neglect your Dashboards?
Do you neglect your Dashboards? Do you know, how important dashboards can be in your organisation? You want to see and steer your organisation by looking at just one sheet. One Excel sheet where you have different dashboards showing you the progress, the development, the statistics, and the forecast for your organisation. You want to steer you […]
Lego
Lego Excel has a lot in common with Lego. I compare Excel often to Lego. You’re getting building blocks and it all depends on what you build from them…Is it’s stable? Is it sustainable? Is it functional? Sometimes it might be just that you still have the building blocks, and it’s all crumbled, and you are not quite sure what […]
The use of excel in your HR Department
The use of Excel in your HR Department Are you working in HR?If you are working in HR, you are coming across a lot of Excel Spreadsheets – probably more than you did expect.There are bonus forms, overtime- & training-forms, and even the contracts are built using Excel.The interesting part is, you can actually automate these things.A lot of people don’t […]
What’s most important for you in your workflow?
What’s most important for you in your workflow? Recently I conducted a poll on LinkedIn – asking my over 2,000 connections for their opinion on the question “What is most important?” There were four options to choose from… Accuracy Speed Transparency Functionality The responses from over 30 people were really eye opening. But before you read any […]
Working with your data from your ERP System
How to Efficiently Use Data From Your ERP-System? Are you using an ERP System in your business and constantly downloading data into Excel? If you are downloading data from your ERP system like SAP, Oracle, JD Edwards everyday, every week, every fortnight, you are not alone. I recently spoke with a lady who is installing SAP […]
Why Excel
Why Excel? Every now and then I’ve been asked “why are you such a fan of Excel.” There are so many other good software tools around. Why would you favourite this dinosaur over modern SaaS tools? I think this is a very valid question – given that Excel is around for over 30 years. Here are […]
7 Steps on how to trust your spreadsheets – again…
7 Steps On How To Trust Your Spreadsheets – Again… You probably have Excel spreadsheets at every corner of your business. Some of your teams are working on calculations all day every day. And it does not surprise you that over 80% of all spreadsheets contain errors or are not capable of producing the correct result. […]
How to extract the gold from your data?
How to extract the gold from your data? …It’s actually a bit like making coffee. You want to use the right beans. In other words – you want to use the right data. Next you want to get to the essence – therefore you grind your coffee beans. You can do this manually or using […]