Software Africa Newsletter - July 2018

Green Tip ~ Excel Tip


Going through the chill of Winter and knowing that next month and September can be colder, we're trusting you are all keeping warm and cosy.

Green Tip

Given the high levels of radiation in Japan, why are we going ahead with letting them run the Tokyo Olympics? Athletes and horses will be put at risk.

ArCADia Software

Unhappy with constantly having to renew subscriptions and wanting a permanent subscription again for your design and engineering development software? Well this might be your solution. The product is priced in Euros, so we have to get the buying rate to give you an accurate price.

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 log on 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!

AutoCAD major change

All full AutoCAD products (Mac and Windows) now come with special tools. To quote Marcus O'Brien of Autodesk:

"Increase Productivity With Specialized Toolsets

"With access to 7 specialized toolsets, subscribers have more than 750,000 intelligent objects, styles, parts, features, and symbols to choose from when drawing. Designers can automate floor plans; quickly draw piping, plant equipment, or electrical panel layouts; incorporate GIS data into the planning process; edit scanned drawings and convert raster images into DWG objects all while working in a familiar AutoCAD interface.

"The toolsets now included in AutoCAD offer intelligent features that will help users work faster and be more efficient. For example, by using the Architecture toolset to model a design, you’ll save a significant amount of time incorporating real architectural elements such as doors, walls, and windows, instead of starting from lines and circles; creating a wall in AutoCAD requires 5 steps, whereas the same outcome in the Architecture toolset requires only 3 steps.

"Now imagine how productive you could be with all of the industry-specific toolsets at your fingertips.

"When you subscribe to AutoCAD 2019, you will gain access to the following toolsets:

"Architecture Toolset: Use specialized building design features and 8,000+ intelligent architectural objects and styles to speed architectural drawing and documentation.

"Mechanical Toolset: Use specialized mechanical design features and 700,000+ intelligent manufacturing parts, features, and symbols to speed product design.

"Electrical Toolset: Use specialized electrical design features and 65,000+ intelligent electrical symbols to boost productivity for creating, modifying, and documenting electrical controls systems.

"MEP Toolset: Use specialized MEP engineering features and 10,500+ intelligent mechanical, electrical, and plumbing objects to draft, design, and document building systems.

"Plant 3D Toolset: Use the specialized plant design and engineering toolset to efficiently produce P&IDs and then integrate them into a 3D plant design model.

"Map 3D Toolset: Use specialized mapping features to incorporate GIS and CAD data to support planning, design, and data management. Access spatial data stored in files, databases, and web services, and aggregate it with your AutoCAD design data.

"Raster Design Toolset: Use raster to vector tools to help you edit scanned drawings and convert raster images into DWG objects."

For the full story, go to this link. The solution will also include mobile apps to use with AutoCAD. This makes it very powerful.

Autodesk Developments

For this month users can change from Suites to Collections. The latter are very powerful and offer Cloud apps as well.

QuickBooks in the Cloud

Please contact Judith for a full overview and pricing. The solution means that you can access your data from anywhere at anytime, giving you far better control. In addition, your data is backed up daily and updated speedily whenever new releases are made available. The really good news is that you can access low-cost solutions for self-employed business people up to the more sophisticated ones for more complex businesses.

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.

Customers who upgrade in July save big and, can win big too!

There is an upgrade drive in July to all customers on versions older than 2018. Customers who upgrade during the month will not only receive a 30% discount, they’ll also be entered into a draw to win one of 5 JBL Wireless Bluetooth Headphones worth R899 each.

No further activations of QBDT 2014 serial numbers.

Some of you may already be aware that the 2014 and earlier versions of QuickBooks Desktop have been sunsetted and we are no longer able to activate serial numbers for these packages. This presents a great opportunity to upgrade to the latest version of QuickBooks (taking advantage of the special offer!) which includes QuickPerks for the first year. Remember, no QuickPerks pin, no support.

Quick Payroll

Please contact Judith for the new KeyPlayer software. This Payroll complies with all statutory regulations and is simple to use and update.

Excel Tip #167 -- What's New in Excel 2016 for Windows?  New Pivot Chart (III) -- Modifying a Pivot Table

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.  Before we get into that, are looking at Pivot Tables.

Last time we created a Pivot Table as a useful way of summarising data. Now we will modify it. At present, it looks like this:

Sum of Amount Column Labels        
Row Labels East North South West Grand Total
Cape Town 116000   166600   282600
East London     244000 261100 505100
Kimberly   152400 95800   248200
Pretoria 373500       373500
Grand Total 489500 152400 506400 261100 1409400

The sums of the amounts would look better if right-aligned as currency.

To do this, start by selecting the pivot table.  The "Pivot Table Fields" pane will appear on the right of the Excel window. In the block "Σ Values", click the "down arrow" next to "Sum of Amount...".  From the drop-down menu, choose "Value Field Settings...". In the "Value Field Settings" dialog box, click the button at bottom left, "Number Format".  Format cells as Currency, with zero decimals, as shown below:

Your PivotTable will then 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

We might also want something other than a Sum. As we saw above, in the "Value Field Settings" dialog box, in the list under "Summarise value field by", we can choose Count, Average, Max, Min, Product, Standard Deviations, and Variances.  By doing a Count instead, we could get the number of invoices to a destination. Using a Max of the Date column, we could find the most recent invoice date per Destination and Division.

Now that we know how to create and modify a Pivot Table, next time we will start on Pivot Charts.

Computius Say:

Artificial intelligence, it no match for natural stupidity.

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 | August > |
Back to top | Updated 14 August 2018 | e-mail Webmaster.