Software Africa Newsletter - November 2021

Online Business Tip ~ Autodesk eShop ~ Excel Tip ~ Training Tip

Rick's Editorial

Welcome.  Our eShop has good deals for you on new AutoCAD annual subscriptions.

Want an important folder to appear first in an alphabetical list? See the Business tip below,

There's a sort-of Black Friday Special on our Excel for Engineers Live Online Training later this month, the last one for 2021.  Also, available now, a self-paced version at a special price.

In the latest Excel Tip in our long-running series, we finish improving our macro.

Could POPIA kill your business?  Get savvy and be safe.

We end with an emoticon of wisdom from Computius.

Mariswe Toastmasters Speaking Tip of the Day: "Keep Your Notes in Check"

"If you need to use notes, be subtle and do not read your speech."

When you read from your notes, it can be obvious to your audience, even during current times while we have meetings online.

If you need your notes, rather use cue cards with keywords to help you remember the core points of your speech.

Either way, the most important thing you could do is rehearse your speech ten to twenty times over.

Adequate rehearsal will prevent you from needing notes at all, or at least allow you to use your cue cards more effectively!

Mariswe Toastmasters, Taking #smallsteps to #excellence

 Buy AUTOCAD 2022 at the Software Africa eShop at the Best Price

You can still save when purchasing full AUTOCAD 2022, by using our online eShop.

Please email Software Africa if you need help.

On-Line Business Tip #55 Things Catherine Wished She Knew Earlier:

To make a folder appear at the top of the alphabetical list in Windows Explorer, start its name with a tilde (~).

Last 2021 Excel for Engineers Online Live Course starts Thursday 25 November

Microsoft Excel is (pardon the pun) an excellent engineering tool.  Not only does it have all basic mathematical functions, it has advanced statistical functions, matrix manipulation, charts, and much else.  Are you, as an engineer, using it to the full?  Are you aware of how much it can do?  Many of us are self-taught and have gaps in our knowledge.  Fill those gaps on the online Excel for Engineers training: two full days of personal attention in a small class.

Next Scheduled Course: Thursday 25 and Friday 26 November 2021 (two days, 08:00-17:00 CAT).
Venue: Live Online via Zoom.  65-page PDF manual is supplied, and 14 examples files.
Special Price
if paid not later than tomorrow, Friday 19 November: Only R4,000 plus VAT per trainee.  Thereafter R4,497 plus VAT each.
Course Creator and Facilitator: Rick Raubenheimer B Sc (Eng) (Wits) (1975).

Run by Software Africa. More information on this web page.  For more information and to book, click here and send the resulting email.

With the live course, as a refresher, you also get free access to the self-paced online version:

Also... Excel for Engineers Online Self-Paced Course starts Now...

Now, if you find the above live course expensive, or you cannot spare two full days away from work, we have an alternative.

The same course is available on-line as a self-paced course.  The same manual and examples.  The same trainer.. No live support, however.  But done at your own pace at times that suit you.  Take half an hour a day and complete it in a month.  Spend an hour a day and finish it in two weeks.  Or dedicate two days a weekend, perhaps? and crack the whole course.

Bonus! Enrol now and receive our report, "Are You Making These Microsoft Excel Mistakes?"

Mistakes in Excel can be disastrous. They can ruin your career, bankrupt the company, even cause the directors to commit suicide. How about preventing them with some tips, tools, and techniques that not everybody knows about? This valuable ten-page report outlines 7 must-have methods for avoiding errors in the first place, or trapping the blighters afterwards! Considering the cost of failure, this report on its own could be worth the entire course cost...

Second Bonus! A Free Support Group

Only course participants get free entry into our Excel for Engineers Support group. Here you can crowdsource solutions to your problems, chat with other engineers, and get help from your instructor.

Third Bonus! Enrol and receive, free, our Excel file "Excel Shortcut keys & My Macro Shortcuts" (you'll want this once you start building macros).

When you have created some macros, you will want a record of which shortcut keys you have allocated to them. This resource includes a list of the shortcut key combinations in Excel. We also list all the pre-allocated Ctrl+ shortcuts (which you should avoid for your macros). That sheet also has space for you to note the shortcut keys that you allocate to your universal and local macros.

Take our self-paced online course in your own time and venue.  All the value at a quarter of the price of the live course.  Backed by a 30-day money-back guarantee.

Excel Tip #204 – Basic Coding 17: Looping the Loop II: Repeating Code

In the previous issue, we tested our macro that processes a list of telephone numbers into a uniform format.  Then, last issue, we looked at improving the macro.  We will get the macro to run repeatedly until it gets to the bottom of the list, using a Loop: The While ... Wend Loop.  We ended with a cliff-hanger: What condition should we use to make sure the loop stops when it is done?

How about using the fact that there is something in the cell to work with?  It should stop when it hits a blank cell, thus:

While ActiveCell.Text > ""

If we indent almost all of our code (to make the block obvious) and put it inside a While ... Wend loop, this is what we get (new While statement with red breakpoint, and Wend selected in blue):

We also added And IsNumeric(Tel$) to the last If statement, just to be sure.

Next time we will look briefly at other types of loops that are available to us.

Finish Covid-19 Lockdown with a Timesaving 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.  The lockdown discount has ended, but it is still a bargain.

PS: Not POPIA Compliant Yet?  Get There in One Week...

The Protection of Personal Information Act (POPIA, or the POPI Act) went live on 1 July.

It applies to every business in SA, no matter how tiny.

The penalties for non-compliance are vindictive:

This new law demands you set up "reasonable" safeguards to protect the information you hold against theft, loss, and hacking. It does not matter if it's lost, stolen or hacked, you have to report it.

Know what's involved so that you can protect yourself and your company: Take the Complimentary Online POPI Act Training for Small Business Owners. It's self-paced so you can do it at any time.  Share this with anyone who is interested in POPI.  If you're not the owner of the business you're in, send this to the Owner.  They will thank you later.

Computius Say:

You know you are spending too much time online when you change your signature to an emoticon.

Remember:  We can make your business run better by:

All the Best from the team!m!
Judith 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:

Disclosure:  Some links we share might be affiliate links that we promote in return for a commission.  We only promote things we've actually tried and think would be great for you too.

This entire newsletter is Copyright 2021 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 | < January 2020 | < January 2021 | < February | < March | < April | < May | < June | < July | < August | < September | Back to top | Updated 10 December 2021 | e-mail Webmaster.