New Excel course at JPL coming soon and Macro Hint and Tip

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.

For more detail on this current course see the Master Class Excel Bronze course agenda here. Or for more on this New Excel course, contact us on johnlegge@jplcomputer.co.uk or on 07903 840105.

 

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?

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We use cookies to give you the best online experience.

Please let us know if you agree to all of these cookies.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy