Menu
Close
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 […]
Do you need to future-proof your business? The Excel Forecast sheet may be the right tool for you! The Forecast sheet allows you to take your historical business data (sales, cash flow, etc.) and create more accurate forecasts for the future. You are welcome to download the workbook to practice! 1. To create a Forecast […]
“When are you introducing user-defined functions for Excel?” This was the big question we had for Microsoft back in the middle of this year (2017). Specifically for us, this meant user-defined functions that were defined in Javascript, and made available through our web-based Excel add-in for the cloud version of Sage Intelligence. We’d asked this […]
With a good business management solution that manages your finances and operations all in one system, you can gain company-wide visibility into your business so you know where you’ve been, where you are currently and where you will end up in terms of cash spent, time and schedule commitments met. In addition, you can keep […]
Numbers containing more than 15 digits in Excel are not often used, however some users might use them when recording credit card numbers, account numbers, stock codes, etc. Applies To: Microsoft® Excel® for Windows 2013 and 2016. Excel can’t handle more than 15 digits per cell, and so when these numbers are entered, Excel stores […]
When creating Pivot Charts from PivotTables, the PivotTable fields will be displayed on the chart. In this tip, you’ll learn how to quickly hide them so that your report looks neater. Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016. You are welcome to download the workbook to practice this short, helpful tip. To remove […]
Do you want to create your own operational report and analyze it according to your specific reporting needs from Accounting International? Sage Intelligence Reporting & Microsoft Excel make this easy and quick to do. Applies to: Accounting International, Microsoft Excel 2013 & 2016 How do I do this? 1. Download one of the standard Intelligence […]
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 […]
With a 3D Map, you can plot geographical data and view it on a 3D globe or custom map. If your data is time-stamped, you can even use a 3D Map to get a geographical tour of how your data changes over time. To create a 3D Map, your data must be in table format, […]
When an object has been placed in the same row as your data and you delete some of your rows, you may find that your object will either be compressed or deleted completely. This can easily be avoided by changing a setting in your object properties, thus preventing your object from distorting in Excel. In […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.