Menu
Close
Did you know that you can use the Paste Link command to quickly consolidate data from multiple Microsoft Excel worksheets into one? The consolidated data can be more easily analyzed and combined on a regular or ad-hoc basis. Furthermore, the consolidated data will be updated whenever changes are made in the source worksheets. Let’s check this out […]
We continue our series on financial templates and in this week’s tip we share the balance sheet statement. The balance sheet statement summarizes a company’s assets, liabilities and capital at a particular point in time. These three balance sheet segments give business owners an idea as to what the company owns and owes. It also […]
A dynamic drop down list in Microsoft® Excel® is a convenient way of selecting data without making changes to the source. Let’s say you have a list where you are likely to add or remove values, a dynamic drop down would be the best option to select data. With a dynamic drop down list, when […]
Ever wondered how to create an interactive Scroll Bar in Microsoft Excel? Instead of manually typing in a particular month or value, you can use the Scroll Bar control to select the months or values from a list, thus saving you time. In this week’s tip, we’ll show you how by using the Offset function […]
In this week’s tip we’ll show you how to look up unit prices in your workbook using the LOOKUP function in Excel. The LOOKUP function is an alternative method to the more commonly used VLOOKUP function in Microsoft® Excel®. Manually entering data in your workbook can lead to inaccuracies with your information, you can apply […]
Microsoft® Excel® provides an easy way to find similar values between multiple lists using the Exact function in Excel. By applying this function you will be able to find out the exact match between two strings of data. When you are working in Excel, text differences within a cell can often be troublesome, that’s why […]
By adding a custom formula to a range of cells, you can create a date, without having to manually format each cell (This also known as suffixing numbers with text strings). Let’s say, you have numbers in a spreadsheet and you wish to display them in a particular date format, you can apply a custom […]
Formatting cells allows you to change the way data is presented, without affecting the contents of the cell. Say for example you need to create a sales report to display the value of sales in various countries in each country’s currency, you can apply the CONCATENATION formula, instead of having to manually change each cell […]
Charts are used in dashboards to provide graphical representations of data which give you at-a-glance views into key performance indicators. It’s important to choose the right charts for what you want to see. If you want to see trends over time, use Line Charts. Using the financial dashboard template, we’re going to display how the […]
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 […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.