Macros are pieces of code that can help you automate tremendously tedious work. In Microsoft Excel macros can help you click through repeated menu items, add formulas and organize data. And that’s just the start. For those reasons I like to use them whenever I can.
That being said, you will have to consider the source when you use macros. Because macros execute procedures on your computer, you will only want to use macros that you have made or were made by people you trust. Microsoft has provided tools to help protect you from unsafe scripts. These tools by default will deactivate any macros in a workbook. I’m going to show you how to use an easy tool that allows you to use the macros you need.
The auto filter in Microsoft Excel is a very powerful tool. It allows you to sift through and organize data so you can analyze your voting results much, much easier. You can use it to pull out data from a specific demographic from your meeting or cross reference how people answered one question from another. You can find trends and gauge the personality of your audience. Auto filter, along with the “Breakdown by Handset” report from ViewPoint, is truly a great tool to have at your disposal.
I’ve created a macro that applies the auto filter to your results in the “Breakdown by Handset” worksheet of your Excel file. You can download that and some example results to practice on from the link at the bottom of this tutorial.
To use the macro and auto filter follow the instructions below.
Having used electronic voting systems for many years (as well as attending conferences that utilize them) I thought it may prove useful to highlight some guidelines on what helps to make a good interactive presentation. Not all of these suggestions are appropriate all of the time but hopefully will at least help you get the most out of the tool you are using.
Never presuppose how your audience will respond.
An answer you don't expect is as valuable as one you do – this could highlight a weakness in your presentation, a lack of clarity in the question or a gap in the audience's understanding.
If you do get an unexpected result try not to ignore it, either explain why you disagree or ask a member of the audience why they voted that way. Sometimes the best use of a voting system is in its ability to stimulate conversation.
Have some 'ad-hoc' questions prepared. A few questions at the back end of your slide deck will mean that if a topic arises and you wish to see if there is agreement then just jump to the ad-hoc question (type the slide number and press enter).