Part of putting that system to work is getting the data out of the system so that it can be moved around. While there are reporting softwares that can create reports automatically from this data, the easiest entry into this is to have the data set up to automatically safe into txt and csv files. From there, we can import this data into Microsoft Excel and really use it.
I'm a huge fan of Microsoft Excel, but not everyone uses it every day. So in my presentation I wanted to just give a little primer on how to get csv/txt files into Microsoft Excel and then what can be done with it once it gets there.
The really great thing about using Microsoft Excel is that it's so universally used that there are a massive amount of resources available to learn. After covering some basics that I'll save for future posts, I left everyone with these three takeaways that I'll leave you with today:
- ALWAYS SAVE FIRST AND SAVE OFTEN. One day you're not going to do this, and you're going to kick yourself when your computer freezes up and you lose your workbook. Don't ask me how I know.
- If you’re repeating something over and over, you probably can do it automatically.
- Google is your best friend: just search “How can I _______ in Microsoft Excel" and she will tell you the answer.