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 IFS function gives you an efficient alternative to the tedious task of creating a nested IF function. The IFS function checks conditions sequentially, and as soon as a condition is found to be true, the function stops and returns the specified value. You can take advantage of this logic to define a default result […]
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 […]
Do you need to know how many customers you have invoiced this month? When creating a Pivot Table and adding your customers to both the row labels and again in the value area, each transaction is totaled for each customer. This does not give a true reflection of how many customers you have invoiced. In […]
Have you ever distributed reports containing PivotTables and found that your recipients aren’t able to interact with them, only having a snapshot of the data? Wouldn’t it be great if they could have some of the same functionality you do, like the ability to filter, drill down, or add other fields that may be of […]
Sage Intelligence recently launched an exciting online course for Microsoft® Excel® 2013 which will help you not only move to the next level of financial reporting, but also improve inefficiencies in your company. There are many useful features covered in this course, but in this article, we focus on three particular functions that highlight the […]
You have taken time to create a product sales PivotTable and now you would like to analyze the data. You want to analyze the sales per branch by quickly generating PivotTables for each branch to be placed on separate worksheets. In this week’s tip, we take you through a few easy steps as we show you […]
The PivotTable is an effective tool for working with large volumes of data, it allows you to summarize, organize and view the same data in many different ways quickly and easily. By using the PivotTable multiple consolidation ranges option you can create a PivotTable that consolidates data from more than one worksheet. This can greatly […]
New in Microsoft® Excel® 2010, and later versions, a sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. For more impact, a sparkline […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.