POPIA Training ~ Online Business Tip ~ Excel Tip ~ Training Tip
Welcome to the Software Africa Newsletter: Subscribed to by the Select, read by the Elite, acted on by the Exceptional.
Our friend Peter Carruthers has a special offer that could save your business. It expires Friday 10 June, 23:59.
Our two live online courses, Excel Macros and Excel for Engineers, are still scheduled to alternate monthly.
Or you can do an economical online self-paced version.
This month's Excel Tip looks at the next piece of the puzzle of looking up data.
The latest business tip will help you avoid remote access scams .
We end with wisdom (or otherwise) from Computius, the computer Confucius.
Our friend and mentor, Peter Carruthers, writes:
|
No, I haven't had a fire, but here is a crazy COVID/POPIA offer that expires Friday midnight. Your POPIA breach is five times more likely to result from a staff member making a silly mistake. (85% of all the breaches come from untrained staff.) All the massive breaches in SA this past year resulted from staff mistakes. That list includes:
If you are the only staff member, then short, simple training for yourself will remove 85% of the risk. The POPI Act demands that you train your staff. (And yourself if you don't have enough PC skills.) If you can't prove you have given a staff member training, you are the person who will pay the fine. Simple training is more than most of our staff have ever had. We give your staff attendance certificates so they can prove they got the training. Here is an extreme offer that expires on Friday at midnight.
Click here to get your crazy offer. You get Online Training for up to 5 staff members, including attendance certificates to prove you have complied, as well as Information Officer training. A total of six people, for just R497 in total. This offer expires at midnight SA time Friday, June 10, 2022. Click here to train one Information officer and five staff for just one card payment of R497. |
What can you do to not become a victim of Cybercrime?
Remote access software like AnyDesk is used legitimately by millions of IT professionals worldwide, to connect to their clients' devices to help with technical issues. However, scammers can try to misuse remote access software to connect to your computer and steal data, access codes, and even money./p>
2 simple Rules:
What they do:
If someone you don’t know asks to access any of your devices or wants you to download specific software: Be careful! You’re at risk of becoming a victim of a remote access scam. Usually, these criminals will call and report a computer or internet problem they say they "have detected" and offer help. They will probably say they work for a widely-known company such as Microsoft or even your bank.
What you can do:
Scammers are basically after your money.
If someone who is remotely connected to your device is asking you to login to your bank account or to show any personal passwords, they are most likely a scammer. Don’t follow their instructions! Even if they say you need to pay them because they claim to have solved a problem you were having, don’t trust them. You didn’t ask for their “help”!
If you feel uncomfortable or insecure: Stop any phone call just by hanging up! End any remote session by simply turning off your device!
The above information courtesy of AnyDesk.
Following Courses:
|
Venue: Live Online via Zoom. 65-page PDF manual included,
and 14 examples files.
Special Price if paid not later than two weeks before the course: Only R4,500 plus VAT per trainee.
Thereafter R5,000 plus VAT each.
Course Creator and Facilitator: Rick Raubenheimer B Sc (Eng) (Wits) (1975).
For more information and to book a course online or in-house at your company,
click here and send the resulting email.
Or email info@softwareafrica.co.za
The Excel for Engineers live course is also 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.
Sign up now and get these Bonuses:
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.
Last time we started this example of how to pick out a name from a list based on some data, using a contest scoring form. You will learn about the Lookup functions MATCH, INDEX, MAX, LARGE, IFERROR, and IF. See that issue to orientate yourself and see the picture of the judging form.
Now for totalling the scores. Our first formula is on row 11, to calculate
the Total Score for each contestant, but omit those who have no score.
In cell H11: =IF(SUM(H7:H10)>0, SUM(H7:H10), “”)
This formula uses the functions IF and SUM. The SUM simply sums the scores in
the cells above
The IF function takes three arguments: logical test, value if true, value if
false. Hence if the sum is greater than zero [SUM(H7:H10)>0] we show the
sum, otherwise, a blank string [“”].
Another way to do it –perhaps more elegant– would be to use SUM only, and format
the cell to hide zeros (or use a dash for zero). Press Ctrl+1 to
pop up the Format Cells dialog. On the Number tab, choose Category = Custom. In
the “Type” box, enter #0;”-“; and click OK.
The format is “format if >0; format if <0; format if =0”. With nothing
after the second semicolon, nothing displays for a zero value. Format #0;;
would also work. Ours displays a dash if the sum is negative, which it should
never be.
In the next Excel Tip, we will look at the formula to display the winner.
Are you too impatient to wait? You can find the full article
here
on our new Excel for Engineers website.
Macros let you 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... You can now attend the whole course live online over two days from the comfort of your own computer. Do you have a good knowledge of Excel, and now want to program your own time-saving applications? Then this course is for you!
Scheduled Courses:
| Thursday 28 and Friday 29 July 2022 (two days, 08:00-17:00 CAT). |
| Thursday 22 and Friday 23 September 2022 (two days, 08:00-17:00 CAT). |
| Thursday 24 and Friday 25 November 2022 (two days, 08:00-17:00 CAT). |
Venue: Live Online via Zoom. 85-page PDF manual is supplied,
and valuable examples.
Early-Bird Price if
paid not later than two weeks before the course: Only R4,500 plus VAT per trainee.
Thereafter
R5,000 plus VAT each.
For more information including the curriculum, click here. To book a course online or in-house at your company, click here and send the resulting email. Or email info@softwareafrica.co.za.
Instead of a doing the whole Excel Macros course over two days, you can do it online in your own time, more cheaply. The Software Africa Quick 'n Easy Turbo-Start Excel Macros course is now online. Take it now!
(Don't try this at home!)
For the few who still know DOS – World's best file compression: "DEL *.*" = 100% compression.
All the Best from the team!
Rick and Judith
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
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 © 2022 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 | < January 2022 | < February | < March | < April | < May | Back to top | Updated 14 July 2022 | e-mail Webmaster. |