In 2015 we shared a total of 40 Microsoft® Excel® tips with you. We’ve collated the best performing tips, and put together your top 5 tips. These top 5 Excel tips were viewed and revisited the most by our subscribers throughout the year. 1. How to create a waterfall chart in Excel A waterfall chart […]
- 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
Use the Flash Fill function in Excel to change text
Manipulating data in Microsoft® Excel® may involve changing the text case from lower to upper case. Luckily, there is an easier way of doing this without using complicated formulas. A new feature in Excel 2013 and 2016 is the Flash Fill option. This can be used to change the case of consistent text. It can […]
How to create a waterfall chart
In last week’s tip, we shared a financial dashboard with you. In the dashboard, one of the charts that we used to present data was a waterfall chart. A waterfall chart is a special type of column chart used for understanding how an initial value is affected by a series of intermediate positive or […]
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 […]
Our top 5 Microsoft Excel tips shared in 2014
Here’s a roundup of the top 5 tips, based on how many of you clicked on the links to view them: How to quickly delete blank rows in a worksheet When working in Excel you probably have had to deal with removing blank rows. This, you may agree, is annoying and time consuming, especially if […]
How to set the Sum function as the default in a PivotTable
In this tip, we want to take this opportunity to address a very important issue faced by many people that use Microsoft® Excel®. Sometimes when working with PivotTables, the Count function is set as the default instead of the Sum function. This can be frustrating as you then have to set each column value to […]
How to set up custom subtotals in a PivotTable
PivotTables are a very useful tool for business reporting especially when you have a lot of data to report on, that’s why they are our topic of focus lately. PivotTables help you quickly summarize, analyze, explore, and present large volumes of data. Did you know that you can summarize or analyze your data with more […]
Set up a PivotTable using the PowerPivot add-on module
Last week we showed you how to install the PowerPivot add-on module in Microsoft Excel 2010 and 2013, and how you can use it to process immense volumes of data that cannot be efficiently handled by PivotTables. Today, we want to show you how to set up a PivotTable using PowerPivot to enable you to […]
How to Install Power Pivots for Microsoft® Excel®
In the past two weeks we have shared tips on Pivot Tables and this week we continue on how to install the Power Pivots add-on module. Power Pivot is an Excel add-on that is available for free in Excel 2010 and 2013. Power Pivots enables you to process immense volumes of data that cannot be efficiently handled […]
How to create custom PivotTable Groups
The PivotTable grouping option in Microsoft® Excel® allows you to see summaries of data by grouping it together so that less detail is shown. Grouping can be done automatically on date fields and the data summarised by days, months, quarters or years. However, you can also create your own custom groups. For instance, you can […]
Return to topLearning
Sage South Africa© Sage South Africa Pty Ltd 2020 . All Rights Reserved.