• Sage City
  • University
  • About Us
  • Contact Us
Sage
  •  Menu
     Close
Home
  • Solutions
    • All Solutions

      All Solutions

      • Standalone Reporting Tool
      • Sage Intelligence for Accounting
      • Sage 300cloud Intelligence
      • 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
      • Additional Reports
      • Sage Intelligence Tips & Tricks
      • Excel Tips & Tricks

        All Solutions

        • Standalone Reporting Tool
        • Sage Intelligence for Accounting
        • Sage 300cloud Intelligence
        • 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
        • Get Support Assistance
        • Knowledgebase
        • Report Writers

          All Solutions

          • Standalone Reporting Tool
          • Sage Intelligence for Accounting
          • Sage 300cloud Intelligence
          • 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

        Home Archives for Glynnis Boyens Page 2

        How to Subtotal Dates by Month and Year in Excel

        Jul 20, 2017 Glynnis Boyens Leave a comment Excel Tips & Tricks, Tips & Tricks

        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, […]

        Continue reading


        How to round a number off to the nearest multiple in Excel

        Jun 1, 2017 Glynnis Boyens Leave a comment Excel Tips & Tricks, Tips & Tricks

        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 […]

        Continue reading


        How to Print a List of Named Ranges in Excel

        May 18, 2017 Glynnis Boyens Leave a comment Excel Tips & Tricks, Tips & Tricks

        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 […]

        Continue reading


        How to print different headers and footers for odd and even pages

        Jan 26, 2017 Glynnis Boyens 2 Comments Excel Tips & Tricks, Tips & Tricks

        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 […]

        Continue reading


        Using a bar chart in Excel to display YTD receipts and payments

        Aug 4, 2016 Glynnis Boyens Leave a comment Excel Tips & Tricks, Tips & Tricks

        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 […]

        Continue reading


        Posts navigation

        Newer posts
        Search for:
        Return to top

        Solutions

        • All Solutions

        Resources

        • Additional Reports
        • Sage Intelligence Tips & Tricks
        • Excel Tips & Tricks

        Learning

        Support

        • Get Support Assistance
        • Knowledgebase
        • Report Writers
        Sage Sage South Africa
        Sage South Africa
        • Sitemap
        • Phishing Email Advice
        • Privacy and Cookies
        • Terms and Conditions
        Sage © Sage South Africa Pty Ltd 2020 . All Rights Reserved.
         

        Loading Comments...