Menu
Close
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 […]
Charles Teversham, MD of Sage Intelligence, considers the benefits of moving from a feudal model of sharing data to a more democratic one. In 13th century Europe, literacy was largely confined to the clergy and some elites, and few adults among the general population could read or write. But that picture changed as a result […]
As you work through a spreadsheet, you may delete a number of cells and then want Excel to shift all the cells up again so that there are no blanks. In this tip, we explain how to remove blank cells between your data in Excel so that this happens. Applies To: Microsoft® Excel® for Windows […]
Over the past year we’ve created a number of financial and sales reports, allowing you to get a handle on the financial position of your business and be able to keep track of your creditors and debtors. We’ve made these reports freely available to you through our Report Utility. Below is an example of just […]
Even though most solo-entrepreneurs understand the benefits of business intelligence, they will probably never take advantage of it. They will assume they have neither the time nor the money to make use of business intelligence. But the field of business intelligence has changed over the years. It’s now cheaper and easier than ever for freelancers, […]
There may be times when you want to run out the same report but with different parameters. For example, you may have a financial report that you want to run individually for three separate fiscal years. Typically, you would need to run out the report three times, once for each year. Did you know that […]
Learning your business intelligence solution doesn’t have to be as daunting as some may feel. Here’s the thing—you already know the benefits of business intelligence (BI). You know that good BI can provide valuable, and profitable, insights for your company. But, are you fully implementing your BI solution and taking advantage of all of its […]
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 […]
If you have ever had problems sorting, filtering, or manipulating data in a Microsoft® Excel® workbook, and realized that it was caused by stubborn leading spaces in the cells, this tip will show you how to remove spaces quickly the next time. If you’re wondering what causes the spaces, there are two possibilities: You may […]
Microsoft Excel is the universal language of business and accountants, and most decision-makers in small to mid-sized businesses use the king of spreadsheets in some way for reporting. In fact, research analyst Gartner has conceded that “Excel is still the number one reporting tool”. Why then, would you want or need to use a Business […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.