Menu
Close
If your data has a column of dates, you may want to subtotal dates by month and year. However, when using the Subtotal command, the desired result is not being achieved as it creates a subtotal for each day. You are welcome to download the workbook to practice. Applies To: Microsoft® Excel® for Windows 2010, […]
If you need to round a number off to a specified multiple, for example; rounding a selling price to the nearest 5cents or rounding a time to the nearest 15 minutes—then MROUND is the function to use. Below we explain how that can be done. Applies To: Microsoft® Excel® for Windows 2010,2013,2016 If you want to […]
It is very easy to create a large list of named ranges but to manage those ranges can be confusing, especially if you receive the workbook from somebody else. Having a list of the named ranges in your workbook could be helpful. To get a list, follow these steps: Applies To: Microsoft® Excel® for Windows […]
If you’ve created a Microsoft® Excel® report that needs to be printed double-sided (e.g. booklet form), you may want to have your headers or footers printed on different sides of the paper—left hand side for odd pages, and right hand side for even pages. To achieve this effect, follow this tip and use the Page […]
Using the correct medium to display your financial results is important. As an accountant, you may want to display the YTD receipts and payments on a chart. For example, selecting a pie chart will not be useful as too many values will be displayed; making your data visualization difficult to interpret. In this week’s tip […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.