Green Tip ~ Online Business Tip ~ Excel Tip
So 2018 comes to an end and what a year it has been. The Rand is slightly stronger but it is rumoured that the USA could be heading for recession.
May you all have a wonderful break over the next few weeks, travel safely and return refreshed.
Start a group in your area to collect rubbish and keep your streets clean. Clean streets make people feel proud and they put off rodent invasions.
CONTACT US FOR A FREE CONSULTATION
IRIS: Trusted by CIPC to implement the iXBRL filing platform for South Africa
www.softwareafrica.co.za Email : info@softwareafrica.co.za Contact : +27 (O) 82 389 3481
Three productivity studies were conducted by Autodesk to highlight the dramatic time-savings and productivity gains of performing common design tasks using the Architecture, Mechanical and Electrical toolsets versus using basic AutoCAD alone. A few highlights from the studies:
This is a real improvement in the quality of this solution. Want to move your platform here?
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 nathalie@worldsview.co.za 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 https://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.
Following on from last
month, we are looking at how to use the free listing of your
business on Google My Business. We enter via www.google.co.za
and then [1] click the "grid" icon near the top right. Click "My
Business" at top right to go into Google My Business.
[2] Click the "Main Menu" (three bars) icon (shown near top left of
the picture below), to reveal the menu. [3] Click Photos, the 6th
menu item. As shown in the picture below, you can (should!) add a
cover photo, perhaps a video about your business, and possibly other
photos. Since we live in a visual culture, businesses with visuals
get more business!
[This tip first appeared in the Megaplex newsletter, "Doing Business in Sandton" (November 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: enquiries@armourandco.co.za and armourandco@yahoo.co.za
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.
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 |
| 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 |
Last time, we applied a filter to the table, and saw the chart change. Then we applied a filter to the 3-D Stacked Column Pivot Chart "Destination" and saw the pivot chart and the pivot table change. We will now be more radical.
At present, as shown above, the pivot table has Row Labels as the Destination cities, which form the bars in the chart. Meanwhile the Column Labels are the divisions (East, North, South, West) represented by the Legend colours in the chart.
Click on the pivot chart. On the right of the window, the "Pivot Chart Fields" window pane appears. At the bottom (the "drag fields" area), we see Destination at bottom left under Axis (Categories) and Division in the upper right quadrant under Legend (Series).
Now drag Division from the upper right quadrant under Legend (Series) to the bottom left quadrant under Axis (Categories). Drag Destination in the opposite direction from the bottom left quadrant under Axis (Categories) to the upper right quadrant under Legend (Series). This swap is shown by the blue arrows in the picture below.
Your results will look like the picture below: The pivot table now has Row Labels as the Divisions (East, North, South, West) and they form the bars in the chart. Meanwhile the Column Labels are the Destination cities, represented by the Legend colours in the chart.
Thus, reorganising the pivot table also reorganises the pivot chart (and vice versa).
Device addiction, you might have, when you turn off your cell phone and get this awful empty feeling, like you just pulled the plug on a loved one.
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: info@softwareafrica.co.za
|
This entire newsletter is Copyright ©
2023 Communication in Action
cc t/a Software Africa. All rights reserved. Information may be reproduced in full context as long as credit is given. |