Software Africa Newsletter – October 2020

Autodesk Tip ~ QuickBooks Tip ~ Online Business Tip ~ Excel Tip

Editorial

Spring has come and gone.  Lockdowns have come and gone and came again and are apparently still coming. One has to wonder sometimes whether anyone knows where they're going!  Spring not only brought new blossoms but also a strengthening of the Rand against the US Dollar.  As a result we are pleased to tell you that we have decreased Autodesk prices effective 15 October 2020. Read Below for more details.

The "Microsoft Excel for Engineers and Scientists" online training provided by Software Africa in collaboration with CPD Africa [Continuous Professional Developments (Pty) Ltd], held on Thursday and Friday 17–18 September, was a great success.  The feedback was very positive from the participating Scientists, Engineers, Engineering Technologists and Technicians. To take part in future such webinars, click to find out more here.

Save on Autodesk CAD software

Due to the strengthening of the Rand against the US Dollar over the last weeks, our suppliers have decreased Autodesk prices effective immediately. The percentage decrease in prices is 3.65%

The following prices are for Annual and 3yr licences respectively, 1 User, New Subscriptions only.

AutoCAD LT 2021 1yr, *R6 009.90. You SAVE *R227.80

AutoCAD LT 2021 3yr, *R16 235.60. You SAVE *R615.40

Full AutoCAD 2021 1yr, *R23 785.45. You SAVE *R901.57.

Full AutoCAD 2021 3yr, *R64 257.59. You SAVE *R2 435.63

*All Prices quoted exclude VAT.

Purchase at this low price while you can!!.

Save on Autodesk FUSION 360

Autodesk has announced their Promotion for Fusion 360 which gives massive savings of 42% over pre-promo prices.  Grab the opportunity to take advantage of this amazing software at the lowest price you are ever likely to get again.  The following conditions apply:

  1. Fusion 360 1yr Licence Now only *R4 103.87. Was *R7,098.88. You SAVE *R2,995.10
  2. Fusion 360 3yr Licence Now only *R11 107.55. Was *R19,214.29. You SAVE *R8,106.74
  3. Manufacturing and Design Add-on, Annual Now only *R12 530.19. Was *R21,675.23. You SAVE *R9,145.04
  4. Generative Design Add-on, Annual Licence now only *R66 700.02. Was *R115,380.38. You SAVE *R48,680.36

*All Prices quoted exclude VAT.

Grab this special PROMO Now!!.

On-Line Business Tip #43 – Put Your Knowledge on the Web III: TabletWise

Last issue we started investigating alternatives for on-line schools, starting with Udemy.

A while ago we were approached by a new school, TabletWise. They claim to have "a unified suite of online teaching software We bring together all the pieces that are required to sell online learning content, accept payments, and market your business."

An advantage of this platform is that they advertise for their schools.  They also offer coaching to help with your marketing.

TabletWise gave great personal attention for a new school, did imports and helped with formatting.  Lesson setup was somewhat restrictive (for example, videos have to go at the top of a lesson, above any text, and they play automatically when the lesson is opened).

They turned out to be less than transparent when it came to sales. On their page linked above, they say that sellers get "97% revenue share on marketplace sales".  Dig deeper and you find, on their help center, "For all sellers, the marketplace payout rate is 60% revenue share of all catalog sales." They don't (or didn't in July) mention what "catalog sales" actually are, nor the very important point that they are in fact heavily discounting courses without the owner’s permission. While this might be an omission in good faith, on the face of it the lack of this vital information looks duplicitous. I expected at least a full explanation of "catalog sales" and the option for a teacher to opt out.

Add to that the fact that they use your course’s sales page to advertise courses from other teachers,  It appears that TablelWise has adopted the worst practices of Udemy, while doing its best to give the opposite impression.

As a result of the above, we did not consider them trustworthy, and closed our account with TabletWise.

Train Your People at Home During Lockdown

Many of your staff are working from home at present.  Could your company make this an opportunity instead of a drawback?

Employees are more valuable when they know Microsoft Excel, Word, PowerPoint, Access (the database), and automation using Visual Basic macros.  We can train them online in person via the internet at times that suit your schedule.

At Software Africa we have a wealth of training material, tested and honed in in-person classes. Levels range from beginners through to programming. Now we train online, live via Zoom at times to suit you. It is actually better that way! The trainee can see the trainer's screen up close, instead of peering from the back of a room. The trainee can share their screen instead of the trainer having to wander around to look.

Join the new wave of online upskilling: email Rick.

QuickBooks in the Cloud

With QuickBooks Online, your data is stored safely in the cloud and accessible from all your devices and anywhere with an internet connection.  You can allow your Accountant direct access –no more transferring of files.  Please email us for the current prices.

Excel Tip #191 – Basic Coding 4: What Do We Need to Learn?

As in the last issue, we have a long list of telephone numbers, which we want to put in a uniform format.  We recorded a macro to convert the phone number to the desired format, and then move one cell down.  Unfortunately what Excel recorded was just this line of code:

    ActiveCell.FormulaR1C1 = "071 834 7583"

Excel was lazy!  It just records the result you entered at the end, not the editing process you went through.

We will now start on the skills you need to do to change this macro to make it do what we want.

Our macro is going to have to do the following:

  1. Read the contents of the current (active) cell
  2. Store it somewhere temporarily
  3. Remove all parentheses, dashes and spaces to get a uniform number.
  4. If it starts with "27" (or your country code), replace that with a "0".
  5. Insert spaces after the third and sixth digits
  6. Replace the contents of the current cell with the changed phone number.
  7. Move one cell down.

We will now dive into some theory. To achieve point 2 ("Store it somewhere temporarily"), we need to learn about variables.  We will do this in the next edition.

Finish Covid-19 Lockdown with a New Skill!

You can use this time to learn simple Excel macros. Do repetitive work in a flash, instead of repeating the same boring stuff manually. Save hours not working late, and spend more time with your family... The Software Africa Quick 'n Easy Turbo-Start Excel Macros course is now online.  To help you during lockdown, for a limited time you can get it at a 75%+discount!

Computius Say:

From radio interview, sounded like Julius going today to Senegal.  We hope one-way ticket.

Remember:  We can make your business run better by:

All the Best from the team!
Judith, Catherine, and Rick

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-6440 ~ Cell: 082 389-3482 ~ e-mail: info@softwareafrica.co.za

This entire newsletter is Copyright © 2020 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 | < January 2018 | < January 2019 | < February | < March | < April | < May | < June | < July | < August | < September | < October | < November | < December 20190 | < January 2020 | < February | < March | < April | < May | < June | < July | < August |
Back to top | Updated 16 October 2020 | e-mail Webmaster.