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

Creating an Excel Dashboard for data visualization is one of the key skills analysts in vast majority of organizations require. The good news is that Microsoft Excel has continued to make improvements that allow the process and available visualizations (charts) easy [...]

By |2017-12-15T16:44:27+00:00June 2nd, 2016|

4 steps: How to Create Waterfall Charts in Excel 2013

Safaricom, the most admired brand in the telecommunication industry in Kenya has seen yet a more profitable year 2015 with total revenue having a YoY growth of +12.9% to 163.4bn, whereas Free Cash Flow (FCF) grew by +21.3% to 27.5bn (Source: Safaricom Financial [...]

By |2017-12-15T16:50:27+00:00May 13th, 2016|

Download FREE chart book

You also give consent to receive the latest news and marketing materials about our products. You can unsubscribe anytime.
Download Now