Newsletter - June 2014


The 30th June is our financial year end.  We are looking back at everything that has happened during the past year.  We have had two major highlights - a stunning October sales achievement and the Autodesk Performance Award for Top Bronze Partner by % Growth Year-on-Year FY2014.  We could not have done this without you, our customers and partners.

Currently we are amongst the top five QuickBooks resellers in South Africa - again because of your support.  Somehow we have grown year on year in "difficult times" by close on 20%.  Our team, which has to include our customers, is working well.

Imagine, if our government worked inclusively with everyone, what South Africa could achieve?  When Judith goes out into the field looking at environmental problems, she feels the lack of team work in this area.  Possibly, just possibly, if every company challenged government to create Team South Africa, we could prosper for everyone.  Just suggesting.

Neotel Update

Finally, we migrated onto Neotel fibre Broadband today (from Telkom ADSL).  So much faster response - everything refreshes super quick.  However, make sure that your project has everything in place for a smooth transition. Ours didn't and that caused delays and gobsmacking surprises, financial and technical. Still a few teething problems on the lines, however Shawn has been supportive in liaising with us once the gaps opened.  We will keep you posted on this.

QuickBooks update

We have really been neglecting our accounting product recently.  Yet, in terms of product delivered, it is our highest unit turnover.  Are you aware that QuickBooks Accountant enables your accountant to correct your books and then update your data file with the corrections?

QuickBooks Enterprise does multi-warehouses and many other useful additions, including running branches within the same company.  Both packages can support 30 users.

Adobe Creative Cloud

Adobe is the first major software supplier to go fully cloud-based with a wide range of products.  It's farewell to Creative Suite in the box and hello to software licence management and access from the Cloud.  For an annual licence fee, companies have full access to all the creative products they require to run their business!  Updates are rolled out remotely; users who leave can be signed off the access list and replaced by new employees.  Best of all, the collateral cannot be lost or stolen.

Please ask Judith or Willy for quotes.

PC Tip: Stay Organised in Outlook

You have an inbox with 5000+ items, this tip is for you. Using the "Rules" button on the "Home" ribbon, you can set up rules that will move messages into specified folders. Typically you might have separate folders for major customers, or for different categories.  Create the folders first, by right-clicking in the navigator tree and choosing "New Folder".

Autodesk Specials for Q2 2015 ending 20th July 2014

There are three specials running in this period:

The first is a lovely surprise for owners of pre-2009 products - you can upgrade during this period with a 30% discount!  Please grab the opportunity now!

The second is for owners of product 2009 and later - the discount here is 20% - lower than last quarter's but still a good opportunity for getting current.

The third is an AutoCAD LT special for R10 828.86 inc VAT and, from us, delivery included to major centres.  If you buy with subscription, it is R1934.01 inc VAT in addition.  We suggest that you purchase the subscription and keep it current to avoid having to pay full price to be current in the future.

Please contact Judith or Willy for quotes.

Autodesk Subscription Changes

From 1 February 2015, upgrades of Autodesk products will no longer be available and all products will have to be bought new.

So keeping your subscriptions up to date now gives real value to your Autodesk product users.  They include the following:

For more information go to and

Why does keeping a subscription current pay out for you?

Well, in fact Autodesk is not the first to go this route.  The various CRM providers and also major ERP providers have done this for years.  In order to keep their software at a level which meets your changing needs, the renewing of subscriptions gives them the base for ongoing development.  Companies can address your wish lists and the requirements of changing standards (government and professional associations).  In addition, your keeping your subscriptions current means that you do not have to pay a huge amount of money to become current two years down the line.

Think of it as the fee you pay to your security company or the premium you pay to your insurance company.

Green Tip

July hosts Mandela Day on the 18th.  In Joburg and in other cities and towns rubbish is a major problem - it dirties our streets and rivers.  Why not get together with your neighbours and do a clean up?

Excel Tip #123 - The Data tab (XIX): Analysis Group - Adding Add-Ins: Solver

We are looking at the "Data" tab on Excel 2010's Ribbon. We now look at the last group, "Analysis", where we will be looking at Solver.  We may see anything or nothing in this group, because it contains add-ins that may --or may not-- be loaded.

If Solver is not there, we need to add it first.

To add a Microsoft Add-In to Excel 2010, use File > Options > Add-ins. Choose the type (at the bottom) and click Go. From the dialog box select the add-ins of your choice and click the OK button. For another type of add-in, start over.

The add-ins included with Microsoft Excel will be available if (and only if!) they were installed during Excel Setup.

To see what an add-in does, click on it and look at the Description near the bottom of the dialog box.

The behaviour of add-ins is influenced by the Trust Centre Settings, found in File > Options > Trust Center > Trust Center Settings > Add-ins.

Some add-ins are built in to Excel, such as Solver and the Analysis ToolPak. Other add-ins are available from the “Download Center” at, and must first be downloaded and installed. Finally, there are add-ins that are created by third parties, such as a programmer in your organization or a software solution provider. These can be Component Object Model (COM) add-ins, Visual Basic for Applications (VBA) add-ins, and DLL add-ins. These add-ins must also be installed in order to use them.

The Analysis ToolPak adds a new item, Data Analysis, to the Data tab (in the Analysis group). This gives you a large number of tools for complex statistical or engineering analyses. Solver adds a new item, Solver, to the Data tab (in the Analysis group). Solver lets you solve a formula for the Maximum, Minimum, or a specific value of the function, with given constraints.

Solver is an "Excel Add-In". To load it, click File > Options > Add-Ins. In the "Manage" list, choose the top item, "Excel Add-Ins" and click Go. In the Add-Ins dialog box illustrated, tick "Solver" and click the OK button. You should now have a "Solver" icon on the Data ribbon, in the "Analysis" group.

In the next issue, we look at Solver.

Computius Say:

Guide to Computer Terms:
"Keyboard" - The standard way to generate computer errors.
"Mouse" - An advanced input device to make computer errors easier to generate.

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 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/1 ~ Fax: 011 802-4576 and 086-635-7902/3 ~ Cell: 082 389-3481/2 ~ e-mail:

This entire newsletter is Copyright © 2014 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 | < 2011 October – December | 2012 January | January 2013 | October 2013 | November | December 2013 | < January 2014 | < March | < April 2014 |
< May | July 2014 > | Back to top | Updated 21 July 2014 | e-mail Webmaster.