About William Kiarie

I am a numbers enthusiast who helps working professionals to work efficiently in MS Excel and MS Power BI. I've trained thousands of corporate professionals across Kenya. I've a degree in Applied Statistics with Computing and a certificate in Data Visualization with Power BI

Highlight High and Low Points in an Excel Chart [The Right Way]

Highlight High and Low Points in an Excel Chart Dynamically Creating a chart is an easy task. Effective communication however, is an art. This technique will help you create professional charts in Excel by showing you how [...]

By |2019-04-04T19:29:35+03:00April 4th, 2019|

Creating Interactive Charts in Excel Using Dropdown Lists

Creating Interactive Charts in Excel Using Dropdown Lists Charts are very central when it comes to communicating information. Whether you’re doing it in MS Excel, Power BI or Tableau, the principles are the same. Interactive charts are a common feature [...]

By |2018-09-27T04:37:33+03:00September 27th, 2018|

Using Excel Power Query to Unpivot Data [Extremely Easy That It Will Shock You]

Most times when data is organized in Excel, it is done in a report format (cross tabulation) since it is easy to understand. Working with this format for further analysis can be an uphill task. It is therefore paramount for [...]

By |2018-09-14T15:33:44+03:00September 13th, 2018|

4 ways to calculate the duration between two dates

In any working environment, there are various instances where you would be required to calculate the duration between two dates. A human resource officer would need to know how long a given employee has worked with the company or the [...]

By |2018-05-01T19:45:55+03:00March 17th, 2018|

8 cool ways to identify and remove duplicates in Excel

When working with data in Excel, it is very likely you will encounter duplication. How do you deal with duplicates in Excel? Dealing with duplicates in Excel is 2-stage process –first identify if you have duplicates, and secondly remove the [...]

By |2018-05-01T20:03:14+03:00March 11th, 2017|

How to Combine Data from Multiple Worksheets into One Master Worksheet

One of the common headaches I have come across in the course of my career as a Trainer in Excel Dashboards is the question of how to combine data from multiple worksheets into one master worksheet, so that you can [...]

By |2018-11-27T11:44:23+03:00November 6th, 2016|

How to Consolidate Data from Multiple Worksheets in Excel

Do you have data in multiple worksheets that you wish to aggregate into a single sheet? Then this article is primarily written to address just that -how to consolidate data from multiple worksheets to a summary worksheets in Excel. [...]

By |2018-11-27T11:15:55+03:00November 6th, 2016|

Using Excel Macros to Combine Multiple Sheets

Using Excel macros to combine multiple sheets is one of the ways to greatly enhance productivity by automating and speeding up the process, especially where the number of worksheets are many. This article is part of the 3 approaches we’re exploring. If [...]

By |2018-11-27T12:12:38+03:00November 6th, 2016|
Grow your career with this FREE ONLINE video course

Zero to Pro with Excel Pivot Tables

  1. Pivot table fundamentals
  2. Save time with advanced hidden concepts
  3. Interactive Pivot-driven dashboard
  4. Intro to Power Pivot & Power Query
  5. Over 10 video lessons