Green Tip ~ Online Business Tip ~ Excel Tip
May you live in interesting times is an ancient Chinese curse. Well we certainly are living in such times with climate change becoming a reality, which is impacting many areas of our lives. Most of South Africa is currently experiencing a severe drought. On the invention side of things, toilets are being revolutionised by making them waterless and able to compost all waste without requiring a biodigester.
Delaying in sending out was caused by Judith requiring a hip replacement.
See note on the toilets above! This is a truly exciting development.
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. Prices are in Euros but they are perpetual licences, not annual.
Please contact Judith for more information and quotes.
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 firstname.lastname@example.org and she will make sure that the technical people sort you out ASAP!
Autodesk Knowledge Network (AKN)
AKN is the community content site providing tech support, training materials, product knowledge, and interactive discussion forums for you as customers. Please make use of it.
This link takes you http://gems.autodesk.com/d/jgq6kw?RefID=5070001711 to obtain the information on the weekly seminars being run on the Collections. Here you will be guided through, interactively, on how they can be used effectively in your business.
You can book on this page to take part. Please encourage your staff to register and hone their skills for an exciting new year.
Last month and the previous month we suggested that you create or claim a listing of your business on Google My Business.
Now, fill in your business's details: You need the name, address (make sure it appears on Google Maps), phone number, web address, and opening hours. You find these under the Info tab, as shown in the picture of the main menu on the right.
Other items (not shown in the picture) are:
Reviews, Photos, Website, Users,
Create an ad, Add new location,
Manage locations, Linked accounts,
Settings, and Support.
[This tip first appeared in the Megaplex newsletter, "Doing Business in Sandton" (September 2018). Sign up here for monthly business tips.]
Please contact Judith for a full overview and pricing.
We can honestly say that running our business has become smoother and easier. The support offered by Intuit is also very good.
Still working on my exam as I have been overwhelmed by the amount of learning that I am doing!
Also look at the QuickPerks site for connections to your desktop.
To give the pros and cons, just stop to read this:
I downloaded the app onto my Tablet and had great fun using it to demonstrate the product!
Please note that Standard Bank's new format is extremely difficult and we still have to be able to test it on the QuickBooks Cloud option.
Recently, we were asked for a CM1 form by SARS in order to continue to use eFiling. I went onto the CIPC site to find this with no luck. So I sent out a Messenger to friends, whom I know are involved in accounting. Richard Armour came back with the solution within hours. He has just launched his own accountancy business and I can highly recommend him. Here are his details:
Richard Armour CA(SA) :
Cell: 073 724 3371. Website : www.armourandco.co.za email address: email@example.com and firstname.lastname@example.org
I am a chartered accountant - performing tax / accounting / advisory and I can do secretarial stuff as you see.
I am also a Commissioner of oaths
I want to help entrepreneurs understand what is happening n their businesses.
How to maximise cash from their sales.
I was group accountant at a listed Chemical company, and then was head-hunted for the chemical company beneath them on the JSE board to do IFRS conversion.
I have recently worked for smaller companies as FD, most recently at a laboratory supply company, that was going through the motions of growing into a medium sized company, not just selling enough to subsist.
This product is being upgraded to make it even more powerful for your sales team, please click this link to find out more from Mark.
Just a great way to keep your customers in sight.
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 modified it to look like this:
|Sum of Amount||Column Labels|
|Row Labels||East||North||South||West||Grand Total|
Last time, we created (among others) a 3-D Stacked Column Pivot Chart. Let us now apply a filter to the table, and see the chart changes, Notice the drop-down arrows on the right of "Column Labels" and "Row Labels". Pull down the former and untick the checkbox next to "West" (the last one). Notice how "West" disappears from both the pivot table and the pivot chart.
Now go to the 3-D Stacked Column Pivot Chart. Notice the drop-down arrow on the right of "Destination". Pull it down and untick the checkbox next to "Pretoria" (the last one). Notice how the bar for "Pretoria" disappears from the pivot chart, and that row from the pivot table. Your table and chart should now look like this:
Notice the little "Filter" (funnel) symbols next to "Column Labels" and "Row Labels" on the pivot table, and next to "Division" and "Destination" on the Pivot Chart. Thus, filtering the pivot table alters the pivot chart, and vice versa.
Next time, we will look at the how reorganising the pivot table alters the pivot chart.
Computer addiction, you might have, when you name your children "Mac" and "Apple".
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: email@example.com
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.