Inserting multiple rows in a table can be very time consuming.  In this Excel tip, rows will be inserted based on the specified number in a column. This…

Sometimes when importing data from another program into Microsoft® Excel®, the numbers are stored as text which causes havoc in your report. In some instances…

Sometimes when working in Excel, you may want to change the colour in multiple cells without having to do each one separately. For our example below, we…

In an Excel chart, the series is in a particular order, and the legend entries are listed in their own particular order based on certain criteria.  Sometimes…

It's not always possible to get a slicer to display in the order that you need it to. In our example, the sample displays in an alphabetical order…

Using Excel, have you tried to add a bullet point within a field to stack numbers, sentences or phrases?  Adding a bullet point helps the reader to see…

You don’t have to create complicated formulas to combine text from multiple columns to a single column. In this Excel tip, we will show you how to quickly…

We've created this handy eBook which contains 6 tips and tricks that will help you make the most of Microsoft® Excel® charts. Download Now…

Have you ever wanted to personalize your chart headings to further enhance the user’s report experience?  In this tip we will show you how to customize…

Most people who view financial reports prefer to look at the highest account level first then open the detail when needed.  In this tip, we will show you…

It is sometimes not always easy to trace which data point relates to which series in a chart, especially when it comes to a line chart.  To overcome this…

Named ranges are an essential feature in Microsoft® Excel®.  They are easy to use in formulas and can be used anywhere in a workbook. The trick…

When viewing numerical data in Excel, you may at some point want to represent this data visually. This gives you the ability to easily analyze large amounts…

When using a data validation list, only one column of data is displayed, but sometimes there is a requirement for additional columns to be displayed simultaneously…

Have you ever experienced your Excel charts disappearing when you hide the columns showing the data? By default, Microsoft  Excel  shows only visible data…

This Microsoft  Excel  tip will come in handy when you want to create a chart that will populate your data and highlight only specific parts of that data…

 A step chart shows changes that occur over irregular intervals. For example, it can show stock movement changes, interest rates, etc. A step chart  is the…

Data visualisation is fast becoming the norm for effective business intelligence. Having visuals that tell the right story at a glance go a long way in…

These Microsoft   Excel   tips and tricks are the top performing tips of 2018, and have raked up a combined viewership of over 200 000. Without further ado…

In a previous tip, we explained how you can easily remove duplicate rows from your data using the Remove Duplicates function.   You can find it here.   At…

Have you ever had the pleasure (or displeasure) of working with an extra large Excel workbook with many, many different sheets? This happens frequently…

In our example workbook, we're working with Date, Value In and Value Out fields. We need to create a Pivot Table that will also display the variance per…

This tip is useful when you want to replace or find text using Wildcards, e.g. if you have a column where you would like to replace everything after the…

Sorting data in alphabetical order or numerical order is helpful when you have large amounts of data in the PivotTable you created. Sorting lets you organize…

This tip may seem basic, but with Microsoft continually adding value to its products—we just had to mention it. It's lead by a repository of every icon…