Does your project hit a road block? What would you do, when you’ve spent $60,000 on a project and you get stuck without even being near your project goal? Watch the video below to find out, why it is often times better to start again, instead of trying to forcefully bring a stalled project toRead more about $60,000 spent on a project with little to show for…?[…]
Problem: Lack of productivity & transparency Task at hand: 150 spreadsheets to be automated Facts: 150 spreadsheets were monthly created and updated. Containing data about product distribution by – state – channel – product category Issues: 3 days of update work lack of transparency lack of comparability lack of usability What I did: Condensed the 150Read more about 151:: Higher Productivity, Deeper Insights[…]
Watch the video below to find out about the dog, the door, the beach and the empty mind, which all helps in solving problems.
You’ve finally finished your Excel model. It looks good, there are even dashboards included and you reckon your financial model or workflow is good to go. Think again. There is a thought lingering in your head: is the model sound? Is it sustainable? And most of all: are the results correct? Well, can’t be thatRead more about 547:: Auditing your financial models[…]
In my library there is a book called Knowledge is Beautiful and in there you have pages and pages of data. All presented in a beautiful way, very nicely illustrated. Some are dashboards, some are mind-maps and some are bubble graphs. They all look pretty and some just spectacular. Still the title of the bookRead more about 4:: From Data to Decision![…]
Using a dashboard in a data model is a fantastic idea. It brings your data to life. If you make the dashboard your centre piece you can win the audience on their first glance. Remember with your data model you want to tell a story, and nothing tells a story better than a dashboard with aRead more about 7:: Using Dashboards in Your Data Model…[…]
Are we still using Excel in 2020?
The answer is: absolutely! Without a doubt! There is no other piece of software in the world, which can do what Excel can. There is no other product as versatile as Excel on the market. You can build your workflow, your quote templates, your financial models, your CRM, your sales analytics, your monthly reporting, your bonus system and your dashboards all with the same software tool – Excel. And the above list could go on for another few pages.