A couple years ago I typed up some simple instructions for a family member on how to enter payroll taxes in the IRS EFTPS system. I remembered how intimidated it felt. the first time I used it.
- E – Electronic
- F – Federal
- T – Tax
- P – Payment
- S – System
A few weeks ago I needed my instructions for a trainee, and for the life of me I could not find them! Well, nobody’s perfect. After a little windows search I did find it.
Here it is, my file, in a place I can find it next time. And you can enjoy.
Note to Self: Write a blog about saving documents with appropriate names and in a sensible directory so I can find them years later. [Smacking self on forehead].
My first introduction to Microsoft Excel was in the early 90’s. I remember when I first opened it and looked at those little boxes I thought to myself “What the heck do I do with this?”. I looked around the menu items and closed the program for the day to let my brain take it in. The hospital I worked at had an educational library that included Microsoft Excel lessons on VHS. I checked them out and had fun learning how to use the program. That was over 20 years ago.
Over the years I have used Excel in many different business and personal applications. From listing household items, music collections, balancing my checkbook (before I had Quicken), tracking my Tupperware parties, tracking patients, to tracking and billing construction projects. In some of these cases a database program would be best, but sometimes we just don’t have one. To see my database project go to inScoreOrder.com.
The Chicken and the Egg
One of the hardest things about learning advanced skills is having some real data to work with, and before the tutorial, knowing what kind of data should be entered. It’s one thing to read how to do something, but without something to practice on, it’s all conceptual. For my topics below I have included a practice Excel file with basic formatting. If your computer will not let you download the file please comment below. Please subscribe to my blog to be notified when I post a tutorial.
Julie's Dream House - Practice File
This practice file has data to practice:
- Data Filters (future post)
- Pivot Tables (future post)
- Formulas (future post)
- Conditional Formatting
Other topics covered in my blogs:
- Working with Time
- Advanced Paste Special (future post)
Never make yourself so indispensable you can not take a vacation.
You should be a valuable asset to your employer but if no one else can do your job duties while you are away, you may never get a vacation. Keep an up-to-date list of duties and instructions for your relief. If you have no relief, delegate, bring gifts.