Menu
Close
Whichever industry you work in, the chances are you have to report back in some form or another. Whether it’s a sales report, showing who reached their weekly/monthly targets, or something like what I have to do—marketing reports, showing feedback and progress on campaigns. My role consists of managing and creating marketing campaigns, and so […]
When using Microsoft Excel, you may encounter a few common Excel errors while creating or working with formulas. It’s important to learn how to correct these errors, otherwise you may risk the chance of unintended results being displayed on your spreadsheet. In this week’s tip, we take a look at a few of the common Excel […]
When we started our business 15 years ago, it was based on the premise that Microsoft® Excel® is the lifeblood software application for businesses and accountants around the world. A decade and a half on, it was very interesting and enlightening for me to read the opinions of all these experts: 27 Excel Experts Predict The […]
In the past month, I received numerous questions on how to display the difference between dates in years, months and days. Recently an HR consultant asked how she could show the time served by employees in years, months and days. She currently only displays the time served in years and wanted to be more specific. […]
To summarize and report results from data on separate worksheets, you can consolidate the data from each separate worksheet into one worksheet (or master worksheet). The worksheets you consolidate can be in the same workbook as the master worksheet or in other workbooks. When you consolidate data in one worksheet, you can easily update and […]
You can easily represent your data from a PivotTable into a PivotChart. PivotCharts allow you to graphically represent your data which can help you to easily see comparisons, patterns and trends. For example, a Sales Manager can use PivotCharts to analyse the performance of his or her sales staff. A PivotTable is an interactive table […]
Working with time values comes with its own challenges. One of the issues is how to round off time values from seconds to minutes or minutes to hours. You can use the MROUND function to round off time values. The MROUND function returns a number rounded to the nearest instance of a specified multiple. It’s […]
Anyone who works with figures in Microsoft® Excel® knows the importance of quickly rounding off numbers. Luckily Excel has an easy function that allows you to round off numbers without any hassle. Instead of clicking the increase or decrease decimal options on the ribbon, you can use the ROUND function to round off numbers to […]
In last week’s tip, I showed you how to extract more than one column of data with a single Vlookup formula. However, if you want to lookup data with multiple criteria then you can use the INDEX and MATCH functions. You can lookup data that meets multiple criteria and overcome the limitations of the Vlookup, thus […]
Purchasing a car or a house is usually a pleasant experience for the buyer. However, most financial institutions require a deposit or down payment to be made towards the total purchase price. In this week’s tip, we share how to calculate the deposit or down payment for a car. For instance, the cost of the […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.