There are a so many keyboard shortcuts available for performing very common tasks, which can save you a lot of time. For example, there are keyboard shortcuts available for formatting cells. In some instances, there is more than one shortcut combination that can be used to perform one function, like these: Ctrl + 2 and […]
- 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
How to use Sparklines to view trends in Cash Flow data
In this tip, you’ll discover how to use Sparklines to analyze your cash flow data. First introduced in Microsoft® Excel® 2010, Sparklines are small charts that fit into a single cell in a worksheet. We’ll show you how to use them to get a quick look at trends or changes in your data that may […]
How to replace a concatenation formula
In our previous tip we shared a cash flow statement template with you and showed you how to change the way your data appears to make it easier to read, using Custom Formats. This time around we want to show you how to replace a concatenation formula in the same template, still using Custom Formats. […]
How to customize number formats
Having a sufficient amount of cash is key to maintaining a healthy business, which is why it’s crucial to track where your cash comes from and where it goes. We’ve provided you with a cash flow statement template which you can customise. In this tip we show you how you can customise number formats. Conditional […]
How to install the Analysis ToolPak and use a histogram to present frequency data
In our previous tip we showed you how to present data with PivotTable groupings and then add a column chart and convert that into a histogram. This week, we’ll show you how to create a real histogram by installing the Analysis ToolPak which provides you with a host of data analysis tools. Note: Download the […]
How to use a histogram to present frequency data
Never heard of a histogram? A histogram is a column chart that shows frequency data. For example, if you’re in sales and would like to analyze how frequently you sell certain quantities of goods, you can use a histogram. Note: Download the workbook to practice this exercise Applies To: Microsoft® Excel® 2010 and 2013 Download […]
How to use Icon Sets in Excel to easily track your spend
Last week we shared a budget template to help you manage your finances. This week we want to show you how to use Icon Sets to see, at a glance, whether you’re over, below or on budget. In the template, you will see that we’ve used Icon Sets to illustrate the difference or variance between […]
Use our budget template to manage your personal finances this year
It’s never too late to draw up a budget, especially in the current global economic climate. A budget is an invaluable tool to help you prioritize your spending and manage your money – no matter how much you have. Basically, a budget is an indication of expected income and expenses for a certain time frame. […]
How to quickly format cells using Excel keyboard shortcuts
There are a so many keyboard shortcuts available for performing very common tasks, which can save you a lot of time. For example, there are keyboard shortcuts available for formatting cells. In some instances, there is more than one shortcut combination that can be used to perform one function, like these: Ctrl + 2 and […]
How to expand and collapse grouped columns using keyboard shortcuts
Grouped columns and rows (sometimes called Outline Data) are an alternative for hiding and showing data without using the Hide and Unhide function. Both options are great for organizing and de-cluttering worksheets which have a lot of data on display. Did you know that you can expand and collapse grouped columns using keyboard shortcuts? Follow […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.