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.
Showing the Formatting Marks to Fix Layout in Word Docs
Have you ever been editing a MS Word Document and the layout keeps hopping around? Do you have one of those documents that print extra blank pages? Chances are good it’s a formatting problem.
Showing all the formatting marks makes it easy to identify problems and delete extra formatting. I first learned this trick on Word Perfect. Give it a try.
Now your document will show paragraph marks ¶, tab marks → , spaces (gray dots), and other hidden formatting. Carefully review and delete unwanted formatting. If your document is printing blank pages scroll to the bottom of the page and delete all the hidden formatting marks up to the last line of your document.
If you have never used this tool I recommend saving a copy of your document prior to deleting extra formatting.
Was this helpful? Post a memo.