Home Posts tagged "Excel" (Page 5)

Tag: Excel

Automate Excel graphs with AutoHotKey and SPSS; Automating pretty charts!

Automate Excel graphsA white stress ball with the green AutoHotkey logo being held in a hand, with a laptop keyboard blurred in the backgroundAfter 20 years of doing multivariate statistics, doing analytics is very quick and easy for me.  Putting together the report which clients will think is “pretty” and convey the results is what really takes the time!  I have a ton of macros in SPSS which greatly simplify the front-end however I’ve always preferred Excel graphs to SPSS (because they don’t look like they were drawn with crayons).

Automate Excel graphs

In the below video I demonstrate how you how you can use AutoHotKey to easily automate Excel graphs that you’ll be proud to put your name on!

Two women smiling and looking at a computer screen together in a bright office, one pointing at the monitor.

Easily update Excel graphs; AutoHotKey saved me 100’s of repetitive clicks

Easily update Excel graphs

Easily update Excel graphs

In market research I used to spend a lot of time making sure my charts and graphs were beautiful visualizations that conveyed the data in an easy to understandable way.

I always wanted to make complete use of the range of the graph and would have to, manually, update each one.  I finally learned some object oriented programming and wrote an script in AutoHotKey to easily change the axis on scales in and easily update Excel graphs.  The below video demonstrates how I can just hit a key combo and scroll up/down to adjust the scale.

Automating email metrics w/AutoHotKey, Excel, & RegEx on the naming convention

Automating email metrics

Automating email metrics

I’ve written an AutoHotKey script that logs into our vendor website and uses web scraping exports the recent email campaigns then breaks them out by region, campaign type, Business Unit, etc. and links them back to our SharePoint site for more information.

 

What’s really cool is that I’m putting in formulas (not the static number) thus if some of the items that  are not classified (someone incorrectly used our mailing name so the RegEx broke) they can go back and update the code and all the numbers will adjust!

Automating email metrics