Excel Successes: Wrote My First Macro

by Megan Taylor on September 12, 2014

It may not seem like a big thing to anyone else, but I just successfully programmed my first Macros (four of them!) in Excel. Well, the first ones I had to do outside of a class wherein I had step-by-step instructions.

I’d like to send a shout-out to Dr. San Miguel for teaching me the basics of Macro writing last semester in Accounting Info Systems. I’ve always wanted to know what Macros are and how to use them, and now I do.

For those of you who are curious what I programmed Excel to do, I am working on a project at my job where I have to check certain items in a separate program, and then mark them a different color in my spreadsheet depending on whether or not the items exist and what type of item they are. I’m up to six different colors of highlighting, and switching between them, well… the format painter button and Ctrl-Y or the F4 key only get you so far.

So now I have a keyboard shortcuts to highlight in the four colors I’ve been using most frequently, and I suspect it will save me a lot of time.

And now I can say that I have passed Master-level Excel use and headed down the path into Guru territory, which makes me happier than it probably should. :)

{ 0 comments }

Fall Semester Starts Next Week … O_O

August 28, 2014

I just bought my books for the fall, and the total (including tax) was $583.73. I bought two books. And one of them was used. *sighs* That’s just silly. I guess that’s what I get for getting a masters in something that’s constantly evolving.

Read the full article →

Update: Somehow the Summer Flew By

August 18, 2014

Despite the fact that I wasn’t working this summer, I seem to have found no time to update this blog with my progress. I guess homework is like a gas: it expands to fill the space (read: time) given to it. It feels like I did little else this summer, other than study. But it […]

Read the full article →

Loving my Sales and Negotiating Class

June 4, 2014

I wasn’t 100% sure what to think after the first day of my Sales and Negotiating class. The professor outlined what we would be doing for the semester, which included two in-person sales calls (including all the necessary materials), role playing salary negotiations, and preparing a video interview. Just thinking of all the work that […]

Read the full article →

Update to “Of Missed Opportunites…”

April 29, 2014

I got in! I got into the Accounting Info Systems class!! After my original snafu, I made sure to check my college email every single day, at least twice a day. And I got it. I got the email that… A seat is now available in the Summer II 2014 course you have waitlisted: ACTY […]

Read the full article →

The Thing I Learned Today: Medical Portion of Auto Insurance

March 29, 2014

Today I learned that the medical insurance portion of your auto insurance is deductible on your Schedule A (Itemized Deductions). Now, in order to take advantage of this, you have to have enough medical expenses to get you over the 10% (or 7.5%, if you’re over 65) of AGI threshold for the medical expense deduction, […]

Read the full article →

Of missed opportunities…

March 20, 2014

Man, getting used to another college’s systems can be a bummer. First, I couldn’t figure out how to register for classes (turns out there was something wrong with my account, which is now fixed), and then I had to figure out how to put myself on the waiting list for the last pre-requisite (read: undergraduate) […]

Read the full article →

Application submitted

January 29, 2014

Well, I’ve done it. I’ve submitted my application to Western Michigan University (WMU) and requested official transcripts sent from my undergraduate institution and CU Denver. If the woman in the WMU admissions office that I talked to is right, my application should be accepted post-haste, and then I can figure out what classes I’m taking […]

Read the full article →

Update: Seasonal Tax Preparer Edition

January 29, 2014

I know I haven’t been posting a lot in the last few weeks (finals, and packing, and moving, oh my!), but I just wanted to put out there that I will be working for a small CPA firm in Portage, MI this 2014 tax season, so I may be even quieter than usual. Once tax […]

Read the full article →

Same Path, Slight Course Correction

January 28, 2014

I feel like 90 things have happened in the last two months, the end result of which is that I’m moving across the country and I will be attending Western Michigan University (WMU/Western) to complete my Master’s in Accounting, instead of completing it at CU Denver. The Short Version My husband has been living and […]

Read the full article →