Data visualisation is fast becoming the norm for effective business intelligence. Having visuals that tell the right story at a glance go a long way in achieving this. Microsoft® Excel® provides you with a multitude of ways to enhance the visuals that you create. In this tip, I’ll show you how to format a basic bar […]
- Solutions
All Solutions
- Sage Intelligence for Accounting
- Sage Intelligence for Financials
- Sage Business Cloud Enterprise Management Intelligence (Cloud)
- Sage 50cloud Intelligence
- Sage 300cloud Intelligence
- Sage 50 Africa Intelligence Reporting
- Sage 50 U.S Intelligence Reporting
- Sage 50 Canadian Intelligence Reporting
- Sage 50 Middle East Intelligence Reporting
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 100 Contractor Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage Business Cloud Enterprise Management Intelligence Reporting (Desktop)
- Sage VIP Intelligence Reporting
- Resources
All Solutions
- Sage Intelligence for Accounting
- Sage Intelligence for Financials
- Sage Business Cloud Enterprise Management Intelligence (Cloud)
- Sage 50cloud Intelligence
- Sage 300cloud Intelligence
- Sage 50 Africa Intelligence Reporting
- Sage 50 U.S Intelligence Reporting
- Sage 50 Canadian Intelligence Reporting
- Sage 50 Middle East Intelligence Reporting
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 100 Contractor Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage Business Cloud Enterprise Management Intelligence Reporting (Desktop)
- 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.Webcasts
Want to become a Sage Intelligence whiz? We present regular webcasts of forty-five minutes to one hour on various topics to get you up to speed. Choose your product below to see what we have in store for the next few months. If you want to know more about what a webcast is, click here.Templates and Quick Guides
Check out our informative guides for advice about your business, and make use of our templates to help make your business more efficient.eBooks
Check out our informative e-books to get in-depth advice about your business. You’ll discover how to make sense of your financials, how to make the most of business intelligence, and why business visibility is the key to success.Tips & Tricks
Join over 20 000 subscribers to our popular Sage Intelligence Reporting and Excel Tips and Tricks, and get a handy tip delivered to your inbox.Customer Stories
Don’t take our word for it, hear from our customers who can’t stop raving about how Sage Intelligence Reporting has changed their lives. You might even find a solution in their story to a similar issue you’re facing.- Learning
All Solutions
- Sage Intelligence for Accounting
- Sage Intelligence for Financials
- Sage Business Cloud Enterprise Management Intelligence (Cloud)
- Sage 50cloud Intelligence
- Sage 300cloud Intelligence
- Sage 50 Africa Intelligence Reporting
- Sage 50 U.S Intelligence Reporting
- Sage 50 Canadian Intelligence Reporting
- Sage 50 Middle East Intelligence Reporting
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 100 Contractor Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage Business Cloud Enterprise Management Intelligence Reporting (Desktop)
- 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.Webcasts
Want to become a Sage Intelligence whiz? We present regular webcasts of forty-five minutes to one hour on various topics to get you up to speed. Choose your product below to see what we have in store for the next few months. If you want to know more about what a webcast is, click here.Templates and Quick Guides
Check out our informative guides for advice about your business, and make use of our templates to help make your business more efficient.eBooks
Check out our informative e-books to get in-depth advice about your business. You’ll discover how to make sense of your financials, how to make the most of business intelligence, and why business visibility is the key to success.Tips & Tricks
Join over 20 000 subscribers to our popular Sage Intelligence Reporting and Excel Tips and Tricks, and get a handy tip delivered to your inbox.Customer Stories
Don’t take our word for it, hear from our customers who can’t stop raving about how Sage Intelligence Reporting has changed their lives. You might even find a solution in their story to a similar issue you’re facing.Learning Portal
Check out our brand new Sage Intelligence learning portal! Your personal library of learning resources that suits your knowledge level, and then guides you towards mastering your solution.Sage University
Sage University, your Sage training resource. Get the most value from your Sage solution; Sage University training courses help you and your organization in many ways.Microsoft Excel Training
Discover Excel through a variety of training courses, from beginners to advanced. Improve your Microsoft® Excel® skills and learn how to produce insightful business reports.Sage Intelligence Training
From helping you get started with Sage Intelligence Reporting through to connecting to various databases to create consolidated reports, we have a range of Sage Intelligence Reporting courses designed to upskill you so that you get the most out of your reporting solution.- Support
All Solutions
- Sage Intelligence for Accounting
- Sage Intelligence for Financials
- Sage Business Cloud Enterprise Management Intelligence (Cloud)
- Sage 50cloud Intelligence
- Sage 300cloud Intelligence
- Sage 50 Africa Intelligence Reporting
- Sage 50 U.S Intelligence Reporting
- Sage 50 Canadian Intelligence Reporting
- Sage 50 Middle East Intelligence Reporting
- Sage 50cloud Pastel Intelligence Reporting
- Sage Pastel Payroll Intelligence Reporting
- Sage 100/200 Evolution Intelligence Reporting
- Sage 100 Intelligence Reporting
- Sage 100 Contractor Intelligence Reporting
- Sage 300 Intelligence Reporting
- Sage 500 Intelligence Reporting
- Sage Business Cloud Enterprise Management Intelligence Reporting (Desktop)
- 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.Webcasts
Want to become a Sage Intelligence whiz? We present regular webcasts of forty-five minutes to one hour on various topics to get you up to speed. Choose your product below to see what we have in store for the next few months. If you want to know more about what a webcast is, click here.Templates and Quick Guides
Check out our informative guides for advice about your business, and make use of our templates to help make your business more efficient.eBooks
Check out our informative e-books to get in-depth advice about your business. You’ll discover how to make sense of your financials, how to make the most of business intelligence, and why business visibility is the key to success.Tips & Tricks
Join over 20 000 subscribers to our popular Sage Intelligence Reporting and Excel Tips and Tricks, and get a handy tip delivered to your inbox.Customer Stories
Don’t take our word for it, hear from our customers who can’t stop raving about how Sage Intelligence Reporting has changed their lives. You might even find a solution in their story to a similar issue you’re facing.Learning Portal
Check out our brand new Sage Intelligence learning portal! Your personal library of learning resources that suits your knowledge level, and then guides you towards mastering your solution.Sage University
Sage University, your Sage training resource. Get the most value from your Sage solution; Sage University training courses help you and your organization in many ways.Microsoft Excel Training
Discover Excel through a variety of training courses, from beginners to advanced. Improve your Microsoft® Excel® skills and learn how to produce insightful business reports.Sage Intelligence Training
From helping you get started with Sage Intelligence Reporting through to connecting to various databases to create consolidated reports, we have a range of Sage Intelligence Reporting courses designed to upskill you so that you get the most out of your reporting solution.Quick Support Pre-checks
Performing these three quick pre-checks helps most of our customers wanting support.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.Sage Community
Engage with business partners and other like-minded customers right now on the Sage Intelligence Reporting Community.Sage City
Similar to the Sage Intelligence Reporting Community but targeted at the North American market, Sage City is your very own forum to chat to business partners and like-minded customers across the globe.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.Give Feedback
We love hearing from our customers. Do you have feedback on Sage Intelligence Reporting? Let us know, we’re all ears!Downloads
- Community
- University
- Blog
- About Us
- Contact Us
Home Blog Tips & Tricks Excel Tips & Tricks
Blog
Our Top 5 Excel tips of 2018
These Microsoft® Excel® tips and tricks are the top performing tips of 2018, and have raked up a combined viewership of over 200 000. Without further ado, here they are, the Top 5 Excel tips and tricks of 2018. How to consolidate data in Excel using Data Consolidation (66,027 views) How to get a distinct […]
Learn how to identify duplicate rows in your data
In a previous tip, we explained how you can easily remove duplicate rows from your data using the Remove Duplicates function. You can find it here. At times though, you may just want to highlight duplicate rows without actually deleting them. In this tip, we show you how you can do this using an Excel […]
How to create a linked dashboard (or landing page) for your Excel workbook
Have you ever had the pleasure (or displeasure) of working with an extra large Excel workbook with many, many different sheets? This happens frequently, especially if you are working with a large amount of data that needs to be analyzed periodically. This may be due to multiple tables, lookups, references, charts, graphs etc. This has […]
How to add a variance and running total in a Pivot Table
In our example workbook, we’re working with Date, Value In and Value Out fields. We need to create a Pivot Table that will also display the variance per month, as well as a running total of the variance for the year. In this tip, we show you how to do this. First up; select your […]
Using Wildcards to make finding or replacing data in Excel quicker and easier
This tip is useful when you want to replace or find text using Wildcards, e.g. if you have a column where you would like to replace everything after the space character with text. What are Wildcards? Wildcards are characters that are used to represent one or more characters. The following wildcard characters can be used […]
Sorting data in a PivotTable with Microsoft Excel
Sorting data in alphabetical order or numerical order is helpful when you have large amounts of data in the PivotTable you created. Sorting lets you organize the data so it is easier to find the items you want to analyze. 1. Within the PivotTable, click a field in the row or column you want to […]
How to insert icons into a spreadsheet
This tip may seem basic, but with Microsoft continually adding value to its products—we just had to mention it. It’s lead by a repository of every icon imaginable (and maybe even a few that are unimaginable) that you may find useful, especially if you’re someone who likes your Excel workbooks to look a little more […]
Discover a more detailed analysis of dates using timelines in Excel
Have you ever felt the need to effortlessly switch the date ranges within your Pivot Table in Excel? Have you ever wanted to view the data for just one specific time-frame without having to apply a logical filter all the time? When is the last time you were able to get your Pivot Table to […]
Learn how to select your data conveniently using keyboard shortcuts
In a previous tip, we showed you how you can navigate around a data list quickly using keyboard shortcuts. To view the tip, take a look here. By combining the same shortcuts with the Shift key, you can easily make selections in your data for editing purposes. Assume that you have a data list with […]
Let’s get social!
Follow us on these social channels and let’s engage in all things business, analytics and reporting related.
Join the Excel Tips & Tricks list
Our Excel Tips and Tricks will help you make the most of the business reporting features in Excel. Join over 16,000 subscribers and receive a handy Excel tip delivered monthly straight to your inbox.
Join the Sage Intelligence Tips & Tricks list
Make the most of your Sage Intelligence solution, while you learn all the ins and outs of your favourite reporting solution to improve your business’s efficiency. Join over 4,000 subscribers and receive our tips and tricks monthly straight to your inbox.
© Sage South Africa Pty Ltd 2019 . All Rights Reserved.