This week’s tip is especially handy when running competitions for your business, so please share it with your promotions and marketing teams. The Sampling Analysis Tool is great for when you need to randomly select a number from a given range of values. An example of this is the following; say your marketing team is […]
- Solutions
All Solutions
- Standalone Reporting Tool
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
- Resources
All Solutions
- Standalone Reporting Tool
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage VIP Intelligence Reporting
Additional Reports
Download our latest Report Utility tool, giving you the ability to access a library of continually updated reports. You don’t need to waste time manually importing new reports, they are automatically imported into the Report Manager module for you to start using.Sage Intelligence Tips & Tricks
Our Sage Intelligence Tips and Tricks will help you make the most of your favorite reporting solution.Excel Tips & Tricks
Our Excel Tips and Tricks will help you improve your business reporting knowledge and skills.Tips & Tricks
Easy steps on how to calculate multiple results in Excel using a data table
When you examine business data in Microsoft® Excel®, you may want to discover the result of formulas if you provide different inputs. You can calculate the results of those changes by using a data table. Using data tables makes it easy to examine a range of possibilities at a glance. You can create one or two […]
Use the solver command in Excel to get a preferred result with multiple values
In our previous tip, we showed you how to get a preferred result by using Goal Seek with a single input value. The solver command is also commonly known as the what-if analysis tool. In this week’s exercise we’ll use the example of an accountant using the solver command to determine how much revenue should […]
Our top 5 Microsoft Excel tips of 2015
In 2015 we shared a total of 40 Microsoft® Excel® tips with you. We’ve collated the best performing tips, and put together your top 5 tips. These top 5 Excel tips were viewed and revisited the most by our subscribers throughout the year. 1. How to create a waterfall chart in Excel A waterfall chart […]
Learn how to use the Goal Seek feature in Microsoft Excel to get a preferred result.
If you know the result you want from a formula, but you are unsure of what input value the formula requires to get that result, you can use the Goal Seek feature in Microsoft® Excel®. Goal Seek takes a result and determines possible input values that produce the result you are looking for. Data analysis […]
Make your reports stand out with Excel PivotTables and PivotCharts
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 […]
How to Trap Error Messages in Excel using the IF Error Function
In last week’s tip we had a look at some common Excel errors such as #VALUE! or #DIV/0! and how to correct them. If you work with formulas, you’ve probably encountered a formula error; this means you need to track down the source of the error and fix it. But sometimes a formula error simply […]
Let’s take a look at a few common Excel errors and learn how to correct them
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 […]
3 easy steps to display the date difference in years, months and days in Excel
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. […]
How to consolidate data in Excel using Data Consolidation
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 […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.