Online Business Tip ~ Autodesk eShop ~ Excel Tip ~ Training Tip
Welcome. We wish you all the very best for the New Year! Now, about those Resolutions to improve, that you are already breaking....
Is 2022 really going to be a new year for you? Or will you just repeat 2021? Will you make progress, or merely get a year older? One way to progress is to build on your skills. You can do it on your own, or get going faster with the help of a course.
Coincidentally, we have scheduled two Excel courses (Macros, and for Engineers), to run live online, Covid-free at your own friendly computer. They will alternate monthly for the year. There are also self-paced online versions available now. Read on...
Our eShop has a limited-time promotion on Autodesk Fusion 360, and good deals on other subscriptions.
Puzzled how to calculate a "without-VAT" amount when you have the "with-VAT" amount? See the Business tip below,
In the latest Excel Tip in our long-running series, we summarise basic coding of macros.
We end with wisdom (or otherwise) from Computius, the Confucius of computers.
From 11 to 31 January we can give you 30% off New Annual Subscriptions on Fusion 360 - Additive Build Extension - Individual Access, Fusion 360 - Generative Design Extension - Individual Access, Fusion 360 - Manage Extension, Fusion 360 - Manufacturing Extension - Individual Access, Fusion 360 - Nesting & Fabrication Extension, Fusion 360 - Product Design Extension, and Fusion 360 - Simulation Extension.
On Fusion 360 and Fusion 360 Team - Participant, you can get 30% off Annual & 25% off 3-Year Subscriptions.
Next step for you, before end January: Buy Fusion 360 at the Software Africa eShop.
A large part of the massive Autodesk range of computer programs is now available at our online eShop.
You can buy 3DS Max, Advance Steel, Alias, Architecture Engineering & Construction Collection, AutoCAD, AutoCAD including specialized toolsets, AutoCAD for Mac, AutoCAD LT, BIM 360, Docs, Flame, Fusion 360, InfraWorks, Inventor, Maya, MEP, Navisworks, Plant 3D, PowerShape, ReCap Pro, Revit, Vault, new only (no renewals), and exclusively to South African users.
There you can also get a range of hardware: surveying equipment from Topcon, Autobuild, and geoFENNEL. More to come...
Please
email Software Africa if you need help.
To get the amount without VAT, divide the 15%-VAT-inclusive amount by 1.15
To easily add 15% VAT to the amount without VAT, multiply it by 1.15
(If you haven't memorised your 1.15-times table, a calculator or Excel will help)
Microsoft Office Excel is (pardon the laboured pun) an excellent engineering and scientific tool. Not only does it have all basic mathematical functions, it has advanced statistical functions, matrix manipulation, charts, and much else. If you are an engineer, are you 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 Excel for Engineers training: two full days of personal attention in a small class, in the comfort of your own computer.
We ran a well-received course for BEST Training on 13 and 14 January. The course run by Software Africa is as scheduled for Thursday 24 and Friday 25 February 2022 (two days, 08:00-17:00 CAT).
Following Courses:
|
Venue: Live Online via Zoom. 65-page PDF manual is supplied,
and 14 examples files.
Special Price if paid not later than two weeks before the start of 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.
This live online course is for Excel users who have a thorough knowledge of Excel, and now want to program their own time-saving applications.
Next Scheduled Course: Thursday 24 and Friday 25 March 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 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
In the last issue, we came to the end of the Basic Coding section of Excel Macros. What did we learn about macros?
Sometimes, Excel does not record what you did. It records the result only. We have to code most of the macro.
We can use variables to hold values temporarily. Variables are like cells is a worksheet, but they only have values while the program is running.
Variables are declared using the Dim statement, preferably at the start of the macro. For example:
Dim String1$,
FirstName$ ' Strings (Text)
Dim I&, I1&, I2&, Int2& ' Integers (whole Nos)
Dim Double_Variable3#, Pressure_kPa# ' Double (with decimals)
We get the value that is in a cell with a statement like: Tel$ = ActiveCell.Text
We put a value into a cell with a statement like: ActiveCell.Formula = Tel$
It is good practice to compile our code before running it, using Debug > Compile VBAProject..
While stepping through code, we can find out the value of a variable by pointing at it, or entering “? VariableName” in the Immediate Window, or setting a Watch on the variable..Some handy built-in functions are: Left$(), Right$(), Mid$(), Replace$(), Trim$(string), Len(string), and IsNumeric(string). We concatenate strings (string them together) using the ampersand (“&”).
We can apply conditions using single-line or multi-line “If” Statements . In its simplest form, If (condition) Then (do something)
This can be extended with the ElseIf and Else clauses.
For tidy, easy-to-maintain code, we indent blocks that are inside If … ElseIf … Else … End If blocks, and loops..
We use loops to repeat code while a condition is true. One of these is the While ... Wend Loop
Next episode, we will summarise our learning in the course.
Instead of a tiny sliver every month (as above), why not do the whole Excel Macros online quick-start course? 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. Take it now as your New Year's Resolution.
No, unless your computer is one of the few with a touch screen, pressing on the screen will not do anything! Are you perhaps spending too much time on your smart phone?
All the Best from the team!
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: 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 | < February | < March | < April | < May | < June | < July | < August | < September | < October | < November | Back to top | Updated 14 July 2022 | e-mail Webmaster. |