About Me

Meet the MS Excel & Power BI Enthusiast

Hi, I’m William Kiarie.

DSC_1993

Over the past 5 years, I’ve empowered over 500 employees from various organizations with both Dashboard Reporting in Excel and Advanced Excel skills resulting into a rewarding warm feedback with respect to significant amount of time saved while generating management reports.

I’ve made it my mission to avail the techniques that will make you splendid and smart while utilizing Microsoft Excel and Power BI in reporting. No more having to leave work late generating reports!

One common question I get is: “How long would it take me to master MS Excel like you?” Well, the answer is simple –follow these steps -and give yourself time to practice.

This is about you taking charge of your report production process!

Brands that have benefited from my expertise: Safaricom, Airtel, GM (Kenya), Pernod Ricard, Toyota Kenya, Chai Trading, Gulf Energy, Base Titanium,,,

In this blog, you will find useful answers on how to:

  • prep and model using Advanced Excel formulas,
  • analyze and present insights using compelling visuals (creating Management Dashboards in MS Excel and Power BI)

If you cannot get an answer from this blog send me a direct message on Twitter (@BillWilliamsK). I will definitely respond! You can also submit your questions here.

Start your journey to hone your Excel skills with this simple trick that will definitely compress filling blanks in Excel from a 4-hours activity to 1 minute!

How Can I Help?

If you have come this far, you must be an Excel user. In fact almost all management reports are prepared using this tool. And I like it because of its flexibility in laying out reports the way managers want. BUT I reckon this can be a headache for those with meager skills. You can benefit from my skills in the following ways:

Training in Advanced Excel & Dashboards

I will show you real business scenarios that will allow you to apply the formulas in your work scenario. And what more, I can integrate your actual files during the training! The results? Save loads of time spent generating reports, reduce delays caused by staff dependencies, generate reports management feel comfortable looking at!

Do you have 5 or more staff? We would like to connect with you. Register your interests here

Implementing Dashboard Solutions

Do you have data but you do not the Excel skills needed to create a report? Do you want to automate a certain task using Excel macros? Do you want a dashboard where you just paste your raw data and click refresh, and your reports are ready? Or may be you want dashboards that you can share online! I can help you create these reports and dashboards both in MS Excel and MS Power BI.

Take a look at a sample Power BI Dashboard here. Feel free to interact with the visuals