Menu
Close
In a previous tip, we showed you how to set up a PivotTable using PowerPivot. You’re now going to learn how you can easily calculate Sales Tax/ VAT using the Measures feature in the PowerPivot tab. If you’re the business’s accountant, you may want to analyze the Sales Tax/ VAT that will be paid on the products […]
The PivotTable is one of the easiest tools used to transform huge amounts of data into meaningful reports. Excel didn’t disappoint with the improvements that have been made to PivotTables in their 2016 version. These include the following; Field List search, Automatic Time Grouping, and Multi-select Slicers. In this tip, we explore some improvements made […]
When creating reports, it’s usually preferred that rows with irrelevant data are excluded—as this results in a tidier, more readable report. When it comes to PivotTable reports, this can include rows with blank items. Below is an example of a report with them shown. To get rid of them, we have an add-in specifically for […]
Sage Intelligence – a division of Sage, the global leader in integrated accounting, payroll and payment systems – has launched Excel on Steroids 2013 Online. The course aims to help you build advanced reporting skills so that you can save time and streamline your business reporting and analysis. It is the latest offering from the rapidly […]
In some cases you might find yourself deleting data, and when applying a PivotTable that deleted data may resurface and cause a number of inaccuracies in your PivotTable. In this week’s tip we use 5 easy steps to ensure that when you apply PivotTables to your data, it will automatically refresh using only the applicable […]
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 […]
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 […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.