Menu
Close
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 […]
My parents are remarkable. They have just celebrated their 48-year wedding anniversary, and during this time period, they raised 5 children. They have lived in seven countries and worked in numerous others. Probably most remarkable was that as part of their honeymoon in 1969, they drove a red MGB from Cape Town to rural Zambia […]
Do you want to consolidate, bring together and analyze different kinds of data in one report? You may want to view your financial, payroll and payments information in a single dashboard. Currently, you may be spending a large amount of time reviewing these different reports to be able to draw a final conclusion. In Sage […]
Keyhole visibility is a concept that is familiar to many Small & Medium Businesses (SMBs). This type of business visibility is equivalent to trying to see what’s happening in a room by looking through the keyhole of a door. Likewise, with a narrow view of your business, you are forced to make critical decisions with […]
Do you want to be able to conveniently update your Sage Intelligence reports? Some of your reports may appear outdated or may require a change in branding based on new company policies. You may also want to add new functionality based on later versions of Excel. This is quick and easy to do with the […]
If cash flow is the lifeblood of a business, being able to understand sales trends must be the heart. In this article, you’ll discover the value of sales trends and how you can use them to better run your business. If you enjoy this post, you can discover more financial tips for small business owners […]
Currently, there’s no function that will convert dates into quarters in Microsoft® Excel®. However, using the CHOOSE function, we can easily convert dates into quarters in Excel. The CHOOSE function returns a value from a list of items based on a position number. For example, if we had a function =CHOOSE(3,”Apples”,”Bananas”,”Peaches”,”Pineapples”) the function would return […]
Starting a small business is almost like leaping out of a plane without a backup parachute. It’s exciting, but at the same time, quite risky. There are several reasons why 80% of small businesses in South Africa fail within the first three years, the greatest reason being cash flow. Check out this e-book which attempts […]
If you’ve experienced the mishap of mistakenly closing a file while working on it, or losing it due to a power failure or gremlin in your computer, you’ll know how frustrating it can be. Fortunately, changes were made in Microsoft® Excel® 2010 and 2013 which make the process to recover an unsaved workbook much simpler. […]
In December I was very privileged to take a break with my family and enjoy a week’s holiday in the beautiful snowy mountains of British Columbia, Canada. At the same time a colleague and good friend of mine was driving with his family through a beautiful part of South Africa known as the Karoo, heading […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.