Menu
Close
Selecting data from a drop-down list is a convenient and accurate way of entering data into a range. It helps in ensuring that the correct data is entered quickly in Microsoft Excel. However, a slicer provides a quicker, better and easier way of selecting data from a list. In this tip, we explain how to use […]
Do you have a workbook that could do with some neatening up? Being able to hide rows and columns in a report that contains data you don’t need to view is a great way to do this. An example of a report like this is a financial statement, which has account level detail and monthly […]
In order to effectively analyze data, custom number formatting can be applied to your Microsoft Excel spreadsheet. Custom number formatting is used to easily identify values based on a set criteria. In a large Excel spreadsheet, you can easily highlight all negative or positive values by using custom number formatting. In this example, we are going to […]
Sometimes when working in Excel and collaborating with your colleagues on a single document, you may wonder to yourself; how can I compare and merge a shared workbook? The answer is simple! You can do this by using the Compare and Merge Workbooks command (this command will have to be added to the quick access […]
As an accountant, my most valuable commodity is time. Being responsible for daily capturing, month end procedures and group reporting, I often don’t have time to breathe! Fortunately, a lot of my responsibilities are hastened because I use business intelligence (BI), which helps me extract key information from large volumes of data directly from our […]
If you ever need to split data from one column in your Microsoft Excel worksheet into two or more columns, you can use the LEFT, MID and RIGHT Text functions. The LEFT function returns the first character or characters in a text string, based on the number of characters you specify. The MID function returns a specific […]
Conditional formatting is an effective Microsoft Excel feature that allows you to highlight important information, for example; the ability to find duplicate values within your spreadsheet. You can create your own rule by applying conditional formatting to individual cells or a range of cells. When you have selected the data you want to format, you […]
Well-prepared financial statements contain an incredible amount of timely and revealing information about your business’ financial position. What are its strengths? Where are the vulnerabilities and challenges? Is the business making money? Savvy executives use the information on financial statements—most notably the balance sheet, income statement, and statement of cash flows—to drive decisions and chart […]
For quick access to related information in another file, workbook or on a web page, you can insert a hyperlink in a Microsoft® Excel® worksheet cell. You can also insert hyperlinks in specific chart elements or images. If you struggle to navigate to various worksheets in a large workbook, then hyperlinks may be your solution. […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.
