In a nutshell, I have only 3 goals;
⭐ Teach you how to be more data literate and automate your work.
⭐ Build and design awesome websites to make your presence online unforgettable.
⭐ Explore together new technologies, books, skills, philosophies e.t.c
What I Can Do For You
Data Management, Analytics & Reporting Training
Are you or your employees drowning in the sea of data illiteracy?
Do you spend too much unnecessary time doing manual monotonous boring tasks?
Do you need Excel, Acess, SSRS, Powerapps & PowerAutomate training and integration?
I would love to come to assist.
Let me know when.
Web Design, Email Hosting, Branding & Marketing
Are you tired of hiding in the shadows?
Watching your life pass you by or your business dying a slow death?
All this can change by having an online presence
Having an online presence (business or personal) is no longer a luxury but a requirement.
Let me help you have an unforgettable presence.
Search Engine Optimization (SEO) & Content Creation
For your website to attract thousands of visitors you need two things;
⭐ To rank on top when different kinds of searches are done on Google.
⭐ To have evergreen entertaining or educating content.
If you need help on any of the above issues, let me know!
I would love to help 😊
automate business and data analytics using the Office 365
Did you know Office365 has over 25 productivity apps?
Apps to help you automate tasks, organize your life, work & collaborate remotely.
Are you spending millions of dollars buying off-shelf applications while you could be building them yourself?
I can help you map your business process using Office365
What I am Known For
Money-Back Return Solutions
Customer Follow up & Support
Procurement Specialist || Marine Engineer
I met Crispo when I was a jackleg in data management and analytics.
Within a few weeks of dedicated coaching, my set of skills had tremendously improved, his willingness to share knowledge made a whole difference in my work.
I did not become an IT pundit, However, I must say I got my current role courtesy of what I learned from him.
Manager, Warehouse & Logistics Operations at Tristar Global Logistics – Somalia
A well-rounded trainer in Advanced Excel with a very positive attitude towards empowering staff in solving daily technical database management for efficient service delivery.
Crispo, I really appreciate the MS Excel training you offered years ago and this has enabled me efficiently manage the tough humanitarian and military logistics role I am currently involved in.
Keep on providing technical and tangible solutions in your profession and you will always reap big rewards.
Nick Mwaura , MCIPS
Direct Sourcing Manager–International Procurement & Logistics
It is always a pleasure working with Crispo on projects that required ‘out of the box’ thinking as he is incredibly generous with his expertise and skills.
Tools Of Trade
In the Book of Five Rings, a 17th Century Japanese general advised his warriors, “Never have a favorite Weapon”.
Never fall in love with your tools of trade!
Over the years I have managed to acquire a number of tools of trade.
Sadly, against Miyamoto Musashi advice, I have fallen in love with some of them 🙈
Here are my favorites!
Data cleaning takes up to 80% of the time for a data analyst. To save time use the below tricks to clean mixed digits and letters in a string Find and Replace ALL Numbers in Excel Given below data, find and replace all number digits NB: the Trick is using the...
Assume you have below data and you need to get the last name as Surname & the rest as Other Names. If only One name exists extract it as the Surname. Here are the Steps to follow: Find the position of the last word in the name.To do this you need to count the...
This post is inspired by Dave Bruns's post on Two-way approximate match multiple criteria. Having read Dave's article I thought... "Is there an easy way of doing this using XLOOKUP instead of INDEX/MATCH?" 🤔 Option 1: Using IF Function filter exact data Option 2:...
NEVER has there been so much noise (fuss) in the Excel Community as it was during the introduction of the XLOOKUP FUNCTION. Excel experts called it "Functions Killer", "Ultimate Lookup Function", "Single Most Important function", "Excel Chicken Soup of the Soul"...
"Excel Flash Fill Is A Brilliant Time Saver," writes Life hacker Australia. "In fact, it’s so good it feels like magic," says Tech Radar "Flash Fill brings the power of text manipulation to the hands of common, non-technical, everyday users. Even people who aren’t...
There are times when you want to look up and retrieve values based on a list. Normal filtering can only take up a maximum of two items and limited criteria conditions. In this article, you shall learn 4 ways to look up items not matching a list. For example, below...
Duplicates can be a pain in data analysis leading to the wrong conclusion. This is why knowing how to lookup unique values is very important. This article shows 5 ways to tackle duplicate data menace and create a dynamic lookup table with unique values. The task is...
Every organization requires weekly summaries to monitor peak and off-peak periods. This is mostly so when you are in the production section. Excel has a beautiful but overlooked function (WEEKNUM) that returns an integer representing the week in the year (1 to 53)....
In the year 1882, a German philosopher, Friedrich Nietzsche made a claim that has revolutionized Philosophical and Theological discussions since then. His Claim--God is Dead. There has been a similar discussion in the Excel world, not about God, but about...
When was the last time you used excel tables? Do you know how powerful excel tables are? If you have never or not recently used excel tables, it could be because you have not realized how powerful they are in data analysis. By reading below 7 excel table’s secrets,...