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 https://www.jplcomputer.co.uk/microsoft-excel-training.html and click on the Excel Master Class agenda hyperlink on the right-hand side. Or for more on this New Excel course, contact us on johnlegge@jplcomputer.co.uk or on 07903 840105.

This will be rebadged in 2018 as Master Class Excel – Bronze with the new course being Master Class Excel – Silver.

One new feature of the new course will be a section where we “give away” programs and demonstration workbooks for you to adapt in the workplace. One such example is the ‘send an email from a spreadsheet exercise’. This basically is a worked example which is quite adaptable containing some VBA code and a worksheet set of cells which can be maintained to suit.

See below for the worksheet. Cells B1 to B4 are user maintainable. The button ‘send email’ is clicked and the email created with attachment (which is optional)

New Excel course - Screen shot of Macro exercise in Excel

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.

Cookie Control

Cookie control

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

I'm fine with this

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

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

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