Archive for the ‘excel’ Category

liveblogging class

Tuesday, March 4th, 2008

Liveblogging my Excel Macro Writing class (Steph calls it Dork Workshop) on Twitter right now, follow me if you enjoy these sorts of experiments

Impressing the masses with my knowledge of Ctrl+Tilde

Wednesday, February 13th, 2008

Last night was the first night of my new NYU enrichment class, Financial Analysis in VBA. What a dorky joy this is. We began with what the teacher called “basic advanced Excel” - functions that are generally limited to experienced Excel users and that are central elements to VBA programming but that are still standard in Excel (things like named ranges, text manipulation, auditing, and lookup tables). In two weeks, we’ll expand on this and get into the hardcore VBA world, which I’m very excited about.

I earned my Excel wonk street cred my showing off my knowledge of the keyboard shortcut for the formula auditing toolbar (thanks Ctrl+tilde!) and then showed that I know how to kick it old school by starting my cells with a + instead of an = because it’s more efficient for data entry cells, even if it is a nod to the days of Lotus 1-2-3. Good times.

It’s interesting for me to be learning technical skills in a classroom environment. I live my life online and everything I’ve ever done with technology has been self-taught. I’ll try to keep this updated with my feelings about how the weekly class experience is throughout the semester.

All Rights Reserved Copyright © 2008 Design by StyleShout and Clazh