An asset register is pivotal to asset management. No matter what size your asset portfolio is, you need to keep a record of your asset information for asset planning, accounting and legislative compliance, and performance monitoring. To make things easier for you we’ve created an asset register template that you can freely download, customize and […]
- Solutions
All Solutions
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50 U.S Intelligence Reporting
- 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
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50 U.S Intelligence Reporting
- 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.- Learning
- Support
All Solutions
- Sage Intelligence for Accounting
- Sage 300cloud Intelligence
- Sage 50 U.S Intelligence Reporting
- 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.Get Support Assistance
Can’t find the solution to the challenge you’re facing in the resource library? No problem! Our highly-trained support team are here to help you out.Knowledgebase
Did you know that you also have access to the same knowledgebase articles our colleagues use here at Sage Intelligence? Available 24/7, the Sage Intelligence Knowledgebase gives you access to articles written and updated by Sage support analysts.Report Writers
Having some trouble creating or customizing the exact report you need to suit your business’s requirements? Contact one of the expert report writers recommended by Sage Intelligence.- Sage City
- University
- About Us
- Contact Us
Home Archives for Excel Tips Page 5
Looking up multiple fields with a single formula
Did you know that you can populate an entire data table using only on VLOOKUP formula? This can be done using VLOOKUP in an array formula. You benefit by saving loads of time which leads to efficiency and a quicker turn around of the work. Other benefits of Array formulas includes improved formula integrity and […]
A Quick Way of Looking Up Data with the Vlookup and Match Function
In our previous tip, we shared an Income and Expenditure template for you to download and customize as needed. Now we’ll show you how you can quickly look up and retrieve data from the transactions worksheet to the Income and Expenditure Statement worksheet using the VLOOKUP and MATCH functions. Identifying the column index number in […]
Income and Expenditure Statement report template
This week you are getting something different! We’ve created a template for an Income and Expenditure Statement that you can customise with your own information to save you from agonising over how to use Microsoft® Excel® formulae to look up data. We have also provided step by step instructions on how to use it. You […]
How to Forecast Quickly using Trendlines
Forecasting is integral to business success but it can be frustrating when you don’t have the right tools. Fortunately Microsoft® Excel® gives you the ability to forecast quickly without cracking your head with complex mathematical models using trendlines. When you have existing data for which you want to forecast a trend, you can create a […]
Using Slicers to View Different Scenarios for Forecasting
Forecasting the outcome of a financial model can lead to better planning and positive results for an organization. You can use scenarios to forecast the outcome of a financial model. A scenario is a set of values that Microsoft® Excel® saves and can substitute automatically in your worksheet. You can create and save different groups […]
Using Slicers with Non Pivot Data
Sometimes you may want to present your data simply as a range, but would like to make use of Slicers (available in Microsoft® Excel® 2010 and 2013) to be able to quickly filter data. Commonly, slicers are applied only to data that is presented in Tables, Pivot Tables and Pivot Charts – not non Pivot […]
How to Ensure that Only Text Values are Entered in a Spreadsheet
Manually entering client names into a worksheet can be a time-consuming task and unless you’re a data capturing guru, mistakes can happen. The ISTEXT function in Microsoft® Excel® can help eliminate some of those mistakes. Although it cannot correct any misspelled names, it can ensure that no numeric characters are entered where only text should […]
How to Calculate the Invoice Due Date with Custom Weekend Days
In last week’s tip we explained how invoice due dates could quickly be calculated by using the WORKDAY function. But, suppose your weekend falls on Friday and Saturday, then how do you calculate the invoice due date? In that case you will have to use the WORKDAY.INTL function because the WORKDAY function uses standard weekend […]
How to Quickly Calculate Invoice Due Dates
Calculating invoice due dates in Microsoft® Excel® is easy. If you have struggled to calculate invoice due dates before, your worries are over – in this tip we’ll show you how to do this quickly using the WORKDAY function. The WORKDAY function returns a number that represents a date, before or after a specified number […]
Return to topLearning
Sage South Africa© Sage South Africa Pty Ltd 2020 . All Rights Reserved.