Online Business Tip ~ Excel Tip
April was an eventful month at Software Africa. On the seventh, Judith slipped and broke four metatarsals in her left foot in a Lisfranc fracture. She was in hospital for five-and-a-half days, had an operation to pin the bones, and has been mostly in bed since. On Thursday the bandages were changed for a cast: Fibreglass now, Plaster of Paris is no longer used. The prognosis is a sixteen week recovery period.
Although bedridden, Judith has her computer and is still doing her job, which is much appreciated. Please keep your orders coming!
During the month, Rick had a major database job for a top-end furniture retailer. This culminated in importing a stock list of 2,317 items with photographs from fifteen Excel spreadsheets (a total of 15,049 MB!) into a single 188 MB database -- down to 1.2% of the original size. The 9 users are now doing final testing with the live data.
We have linked up with Dax Data to take advantage of their rich offerings of this dynamic and growing range of products. We will focus on Creative cloud and Adobe Pro, whilst Judith gets up to speed on the other, very exciting products.
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!
Be warned that all products will rise by 10% on 1st May. Please make payments on 31st April and send us your POP, so that we cane place orders at the current rate.
Who thought that the VAT rate would ever change? We did!
Back in January 2007 we wrote a database, Terra Firma, for Corinna of CB Landscapes to run her landscaping business. The most recent release was in January 2011. This month Corinna emailed us to find out how to change the program to cater for 15% VAT. Unlike some other programmers, we had not hard-coded it. We sent her instructions to open the Setup page and change the VAT rate for new invoices, and also to change any invoices she might already have issued for the month. She replied:
Thank you so much!
Such a relief- it is easy as pie- was dreading a whole complicated thing like zipping up files and emailing u and then having to reinstall once u email the changes back. Ha ha ha!
Ur instructions so good and clear it took me less than a minute to get this sorted. Thank you.
And thank you also for the no cost on this work- really much appreciate it!
Yip, I still use the TF daily- it runs my whole business.
This is currently on a 90 day free trial, for accountants and bookkeepers the link is here https://quickbooks.intuit.com/za/accountants/. For Small businesses, it's here https://quickbooks.intuit.com/za/ .
Please contact Judith for the new KeyPlayer software and assistance in getting your data file to QuickBooks for conversion.
With Judith's stay in hospital and the enormous amount of waste generated, we were relived to hear that they separate and recycle their plastic waste. Well done, Mediclinic!
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, the new button for the new Statistical charts produces Box and Whisker charts, which we introduced in Excel Tip #161.
Last month we saw how to create several bars by using separate columns of data, while the previous month we broke the diagram into several bars based on text data in the first column. Now we will do both.
Here, we have modified last month's data to include the year as the first column (which must be text, hence the "Yr" prefix).
We can now see how, for the period 2014 to 2017, the Rand varied against the Dollar, Pula, and Metical. The dots above the upper whisker and below the lower whiskers are outliers.
Next time, we will start on the new Pivot Chart button, the last of the new chart buttons we first introduced in February 2017.
Restaurant now has electronic tablet instead of printed menu. Human waiter still needed to explain tablet. Hope he won't be replaced by electronic waitron.
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: firstname.lastname@example.org
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.