How to keep your data clean with Advanced Excel

I had a fun job working as an administrative assistant at a local college for a few years. Part of my job was to process expense reports.

To streamline things, I created a reimbursement form for the professors to fill out after their European trips. However, since this was a language department, most of the professors liked to explain things in lots of words. While why they had to order that specific item at the Deux Magots was an interesting enough story, I just needed to know it was lunch and how much it cost!

I needed to prevent them from trying to write a novel in a cell. How did I do that?


Next Class Offered

Session One: Wednesday April 27 6:00pm-9:00pm

Session Two: Wednesday May 4 6:00pm-9:00pm

Special Course Rate $100.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.