Are you constantly battling with the task of having to manually remove leading spaces between data? Now you can easily remove spaces from your data, except for single spaces between words, using the TRIM function from Microsoft® Excel®. Assuming you have imported data with irregular spacing into Excel an worksheet, in this tip we’ll show you how your […]
- 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.
Use the MID and FIND functions in Excel to easily link a worksheet to a cell
Some businesses use Microsoft® Excel® to prepare and present their business reports. Report headings often contain worksheet names, and to make your reports more efficient, you can link these worksheet names to a specific cell. So, instead of retyping the worksheet names in your report headings, you can easily apply the MID and FIND functions in […]
5 easy steps to stop PivotTables from returning deleted data in Excel
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 […]
Use the Sampling Analysis tool in Excel to easily select random numbers.
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 […]
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 […]
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 […]
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. […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.