Home > Resources > Blog

Automate Your Work By Implementing Macros

mikelund  by Lund on Jan 29, 2011

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.

More...

Organize Your Results Using Auto Filter

mikelund  by Lund on Jan 08, 2011

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.


More...