Keyhole visibility is a concept that is familiar to many Small & Medium Businesses (SMBs). This type of business visibility is equivalent to trying to see what’s happening in a room by looking through the keyhole of a door. Likewise, with a narrow view of your business, you are forced to make critical decisions with […]
- 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.- Learning
- Support
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.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 excel-based Page 3
Understanding your Cash Flow
Understanding cash flow is a vital component of any business. According to Eric T. Wagner, contributor for Forbes, “At surface level, the primary reason businesses fail is that they simply run out of cash.” Knowing how much money is coming into and going out of your business means you can determine your net cash flow […]
How to prevent objects from distorting in Excel
When an object has been placed in the same row as your data and you delete some of your rows, you may find that your object will either be compressed or deleted completely. This can easily be avoided by changing a setting in your object properties, thus preventing your object from distorting in Excel. In […]
Learn how to grant or restrict access to reports in the Sage Intelligence Report Viewer
Did you know that you can grant or restrict access to reports in the Sage Intelligence Report Viewer? Sage Intelligence makes this easy to do. Perhaps you’re busy developing a new report and you don’t want users to be able to run it from the Viewer until you’re happy with it. In this tip, I’m […]
Conveniently remove blank item rows in your PivotTable reports
When creating reports, it’s usually preferred that rows with irrelevant data are excluded—as this results in a tidier, more readable report. When it comes to PivotTable reports, this can include rows with blank items. Below is an example of a report with them shown. To get rid of them, we have an add-in specifically for […]
Easily recover an unsaved workbook in Microsoft Excel
If you’ve experienced the mishap of mistakenly closing a file while working on it, or losing it due to a power failure or gremlin in your computer, you’ll know how frustrating it can be. Fortunately, changes were made in Microsoft® Excel® 2010 and 2013 which make the process to recover an unsaved workbook much simpler. […]
A new year’s resolution for SMBs
As small to mid-sized businesses enter 2012, many owners and executives may be considering technology-related strategies to streamline processes, gain competitive advantage and generally make their lives easier in the year ahead. Erik Kaas, Vice President of Product Management for Mid-market ERP products, Sage North America, discusses here why it’s time for companies to get […]
Why Mid-Sized Businesses should invest in an integrated Excel-based Business Intelligence solution: Reason No. 3
Reason 3: Get immediate ROI Typically the barriers to adoption of BI are cost and complexity. An integrated BI solution makes deployment rapid without any IT hurdles, allowing for an immediate return on investment. Because it is a module of your existing accounting package, no new relationships or extensive IT investments are required. It can […]
Why Mid-Sized Businesses should invest in an integrated Excel-based Business Intelligence solution: Reason No. 2
Reason 2: Make insightful decisions The ability to make better decisions and proactively solve issues is crucial to success at every level of an organization, every day. And as companies grow or face stiffer competition, the need to make these decisions based on meaningful information quickly becomes an imperative. Most businesses need to be agile […]
Why Small Businesses should invest in an integrated Excel-based Business Intelligence solution: Reason No. 5
Typically the barriers to adoption of BI are cost and complexity. Small businesses face tighter budgets, less sophistication and fewer people. An integrated BI solution makes deployment rapid without any IT hurdles, allowing for an immediate return on investment. Because it is a module of your existing accounting package, no new relationships or extensive IT […]
Return to topLearning
Sage South Africa© Sage South Africa Pty Ltd 2020 . All Rights Reserved.