What’s coming soon in a new Excel course and Macro Hint and Tip
In this week’s blog, we shall update you on two items.
- A new Excel course which will be launched early 2018
- A hint and tip regarding macro settings
For some time now we have been running our Excel Master Class course with some considerable success. It contains features which are commonly used in business which we go into a depth which gives trainees a good understanding of elements like Pivot Table Macros, Nested Statements, Data Scenarios and Query Manager.
Change of course name
This will be rebadged in 2018 as Master Class Excel – Bronze with the new course being Master Class Excel – Silver.
This course will build on skills and features explored in the Bronze course. There will also be a half day session on VBA coding in Excel as a beginners section on the topic!
Hint and Tip on Macro settings
A) Disable all macros without notification.
Click this option to disable all macros because you don’t trust any.
B) Disable all macros with notification (recommended).
This is the default setting. Click this option if you want macros to be disabled, but you want to get security alerts if there are macros present. This way, you can choose when to enable those macros on a case by case basis.
C) Disable all macros except digitally signed macros.
This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher. All unsigned macros are disabled without notification. If you want more details on these signatures please check the Microsoft web site
D) Enable all macros.
This is a rather unsafe option to choose since some macros may contain virus code and therefore could corrupt your PC. Only use this if you created the macros yourself or are 100% sure that they are safe and won’t contain any virus code in them.
We hope you liked this post on our new Excel course and a hint and tip on macros. Why not take a look at our previous post on formatting in Excel?