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+00: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+00: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+00: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+00:00March 11th, 2017|

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. If you have not gone through the various approaches, follow these links: [...]

By |2017-12-15T16:42:14+00:00November 6th, 2016|

Using Shapes for Stylish Excel Dashboards

One of the key skills that will set you apart as an analyst is the ability to provide management with a distilled view of the key company numbers, with the ability to have multiple views in interactive Excel Dashboards. Surprisingly, using [...]

By |2018-09-06T10:54:13+00:00June 2nd, 2016|
FREE "Zero to Pro with Excel Pivot Tables" when you enrol in November 2018.
Get Access Now