Software Africa Newsletter - August 2018

Green Tip ~ Online Business Tip ~ Excel Tip


Unusual weather in August, although we do have the wind stripping the last leaves from the trees that are too lazy to let go of them! We have the prospect of an El Nino, which means another drought  How can we start thinking about new solutions, changing how our economy works, creating jobs and educating people whom the education system has let down?

Green Tip

We are in crisis as the poles melt releasing methane and diseases into the world in greater and greater amounts. Earth Titanic is about to sink.

ArCADia Software

There are three products available - ArCADia LT, ArCADia 10 and ArCADia 10 Plus. They also have a full BIM solution and we can supply you with the brochure setting out exactly how it operates. Getting down to specifics, you can look at ArCADia for Architects, Distribution Boards, Electrical installations and so on. For more about them use this link.

Please contact Judith for more information and quotes.

Activating your Autodesk Software

Please note that your new Autodesk software has to be activated using your account logon within 30 days. Thereafter, please log onto your account monthly to receive the latest updates, so that your software stays current. You can use your account to access training videos and support via AVA as well. If AVA can't solve your problem, it can be escalated to Autodesk Support who will phone you to sort it out. This is an exceptional development as it makes problem solving so much faster than previously.

As an Autodesk customer, you matter to them as well as to your reseller. More and more solutions are sitting on your customer account - please explore them!

You can also now receive support from the Distributor, contact Nathalie for this. Her email is and she will make sure that the technical people sort you out asap!

Autodesk Developments

Starting August 7, everyone who has made an investment in Autodesk solutions can take advantage of additional value and workflow benefits available through the Collections.

From August 7 to October 25, if you have a current subscription of a standalone product like AutoCAD, Revit or Inventor Pro you can, at any point in your subscription term, move to a Collection and save 20% off the price for the remaining months of your existing term.

On-Line Business Tip #19: Create a Google Account

We know Google as the most popular search engine on the planet, but Google is now much more than searches. A lot of Google’s services are available without signing up, for example Google Search, watching YouTube, Google Books, Google Finance and Google Maps.

However, an account is needed for uploading videos to YouTube and for making edits in Google Maps, and using Gmail, Google+, Google Hangouts, Blogger and others.

Apart from the above, Wikipedia, the free encyclopaedia, lists the following services from Google: Activity tracking, AdWords, AdSense, Google+, Google Drive, Google Calendar, Google Hangouts, Google Wallet, Google Groups, Google News, Google Alerts, Google Sites, Picasa, and Google Photos.

Many of them require an account. We will introduce you to various of these in subsequent newsletters. For now, we suggest you start by creating a Google account: To create an account on Google (or find out if you have an existing account) click here. If you are signed in, you have an account.  If not, click "Sign In" and see if there is an account.  If not, use the option to create your Google Account.

[This tip first appeared in the Megaplex newsletter, "Doing Business in Sandton" (June 2018). Sign up here for monthly business tips.]

QuickBooks in the Cloud

Please contact Judith for a full overview and pricing. Having just done month-end using the direct download from FNB into QBO (QuickBooks Online), I can only state that it made it so much easier to complete.

I am loving working on the Cloud version and looking forward to passing my exam very soon.

To give the pros and cons, just stop to read this:

QuickBooks Online vs. QuickBooks Desktop

So what’s the big fuss about QuickBooks Online and how does it compare to its desktop counterparts? Well first off, QuickBooks Online makes daily tasks easier, meaning less work for small businesses.

Maximizer CRM in the Cloud!

Maximizer has been our customer relationship management for over twenty years. It has been a source of staying on the ball and creating increasing sales.  Maximizer is now in the Cloud! If you would like to obtain more information, please click this link.

  • Most Subscribers ………………
  • Best Customer Success Story

Excel Tip #168 -- What's New in Excel 2016 for Windows?  New Pivot Chart (IV) -- Introducing Pivot Charts

We are looking at what is new in Excel 2016 for Windows Desktop, compared with Excel 2010.  On the Insert ribbon, in the Charts group, there is a new button for PivotCharts.  Earlier, we created a Pivot Table, and last time we modified it to look like this:

Sum of Amount Column Labels      
Row Labels East North South West Grand Total
Cape Town R116,000   R166,600   R282,600
East London     R244,000 R261,100 R505,100
Kimberley   R152,400 R95,800   R248,200
Pretoria R373,500       R373,500
Grand Total R489,500 R152,400 R506,400 R261,100 R1,409,400

To create a Pivot Chart from the Pivot Table, start by selecting the Pivot Table. The right-hand sidebar will appear. Ignore it. On the Insert ribbon, click the Pivot Chart button (shown in green on the picture). The "Insert Chart" dialog will pop up:

On the left, the Column type of chart is selected.

Across the top we see seven variations of column charts: Clustered Column, Stacked Column, 100% Stacked Column, 3-D Clustered Column, 3-D Stacked Column, 3-D 100% Stacked Column, and 3-D Column. Click on each one to see a larger representation of that one below.

  1. Clustered Column, 3-D Clustered Column, and 3-D Column all show a freestanding bar for each Sum cell in the Pivot Table. This allows us to compare individual sums with each other.
  2. Stacked Column and 3-D Stacked Column stack the values of the table's rows together giving, in total, the Grand Total column. This allows us to compare totals for each destination city with each other, while seeing how they are made up from each division.
  3. 100% Stacked Column, and 3-D 100% Stacked Column are stacked like the previous types, but scaled to 100% in all cases.  This allows us to see percentage-wise how the total for each destination city is made up from each division.

Next time we will look at these Pivot Charts in more detail.

Computius Say:

Definition of "Upgrade": Take old bugs out, put new ones in.

Remember:  We can make your business run better by:

All the Best from the team!
Judith and Rick

Members, Communication in Action cc trading as Software Africa
"Empowering African Business with standard and custom PC programs, databases, and templates using Microsoft technologies"
Reg. 2009/007863/23 ~ VAT No 4500104387 ~ 126 Kelvin Drive, Morningside Manor, Sandton, 2191 South Africa.
Tel: 011 802-2685 / 011 802-6440 ~ Fax: 086-635-7902/3 ~ Cell: 082 389-3481/2 ~ e-mail:

This entire newsletter is Copyright © 2018 Communication in Action cc t/a Software Africa. All rights reserved. Information may be reproduced in full context as long as credit is given.
Newsletter Index | < January 2015 | < January 2016 | < January 2017 | < February | < March | < April | < May | < June | < July | < August | < September | < October | < November | < December 2017 | < January 2018 | < February | < March | < April | < May | < June | < July | Sept > |
Back to top | Updated 13 September 2018 | e-mail Webmaster.