Impressing the masses with my knowledge of Ctrl+Tilde

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.

Tags:

Leave a Reply

All Rights Reserved Copyright © 2008 Design by StyleShout and Clazh