This week we’ll show you how to quickly rank items from smallest to largest using a feature that already exists in PivotTables. Let’s say you’re analyzing your products or even expenses and need to rank them from the smallest to the largest value, instead of writing your own formulas in calculated fields, you can use […]
- 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
How to sort your data using a customized list
If you would like to sort your data differently, and not in ascending or descending order using the Sort feature in Microsoft® Excel®, you can customize it! The Custom Lists feature allows you to define your own order. For example, if a Sales Manager wants to sort product categories in a specific order instead of […]
Calculating the age of an employee
Last week I was presenting a workshop on the date and time functions in Microsoft® Excel®. One of the delegates, a Human Resource professional, asked me how they can calculate the age of an employee in Excel. I suggested they use the DATEDIF or the DAYS360 functions. For the sake of other HR professionals who […]
Enjoy greater flexibility in filtering dates with Timelines in Microsoft® Excel® 2013
To make it easier for you to drill down on data, Microsoft has provided a more flexible way of filtering PivotTables by dates in Microsoft® Excel® 2013 with the addition of Timelines. Timelines are a visual filter for dates, which make it easy for you to see what date range has been filtered, plus they […]
How to prevent edits to the final version of a workbook
If you want to share the final version of a workbook and ensure that changes aren’t made to it, you can use the Mark as Final command. This command communicates that you are sharing a completed version of the workbook and helps prevent reviewers or readers from editing it. When a file is marked as […]
How to save workbooks to the Cloud
Cloud storage provides greater accessibility and rapid deployment of data, strong protection for data backup, and lower storage costs, making it an ideal storage platform. Saving workbooks to a file hosting service in the cloud, like OneDrive, allows you to access it from any computer as long as you have internet connection. It also makes […]
How to remove hidden data and personal information from an Excel workbook
Before you share an electronic copy of a Microsoft® Excel® workbook, it’s a good idea to review the workbook for hidden data or personal information that might be stored in it, or in its document properties. This could be information about your organization or about the workbook itself that you do not want to share […]
How to quickly delete blank rows in a worksheet [revisited]
Two weeks ago we shared a tip on how to quickly delete blank rows in a worksheet. Thank you for the comments we received on this tip, they didn’t go unnoticed. A lot of you have requested that we show you how to delete blank rows in a worksheet without deleting rows which have data […]
How to maintain data integrity by identifying blank cells in a worksheet
To maintain data integrity in your worksheet you can start by identifying cells that are blank, possibly due to data capturing error or because they have been left as place holders for vital information and forgotten. This gives you the opportunity to complete capturing and have a complete data set which is vital for data […]
How To Quickly Delete Blank Rows in a Worksheet
When working in Microsoft® Excel® you probably have had to deal with removing blank rows. This, you may agree, is annoying and time consuming, especially if you have a large worksheet with thousands of rows. Well, instead of deleting the blank rows painstakingly one after the other, we’ll show you how you can delete them […]
Return to topLearning
Sage South Africa© Sage South Africa Pty Ltd 2020 . All Rights Reserved.