Home » Posts Tagged "time"

Five Excel© Features That Everyone Should Know

Microsoft Excel is just about as famous for being frustratingly difficult as it is for being exceedingly useful. These five tricks will make your data-crunching experience a much more relaxing one. 1. What Day Is It? Excel’s “Today” feature is no doubt a quick way to insert the day’s date into your spreadsheet. If you are not familiar with it, entering =TODAY() into a blank cell puts the day’s date into the cell. A word of warning, though – Even though this seems like it would be a useful tool to track when you input important data into your spreadsheet, the date will automatically update...

read more

A Simple Mail Merge Can Save You Time

[Originally published in The Coloradoan on 4/6/12] If you have a list of contacts on your computer and are ready to start mailing to a large group of them, then you can put down your pen and let your computer do all the dirty work. With two of the most popular Microsoft programs, Word and Excel, you can quickly and easily create a mail merge system for your contacts. A mail merge is the combination of a data source and a word processing document to produce mailing labels, envelopes, form letters and more. It is an extremely powerful tool that most administrative professionals use to save...

read more

Business Book Club: Would You Like to Achieve a State of Stress-Free Productivity?

  In this day-and-age, we’re all juggling so many different responsibilities: a gazillion passwords, emails, hard copies, phone calls, Facebook, blogs, work responsibilities – tasks, files, projects, meetings, reports; home responsibilities – eating, cleaning, family, chores, insurance companies, cleaning out the garage (is that task ever completed or does it just live on the to do list permanently for you too?). So, how do we simplify things in an ever-growing-more-complicated world?  By having a simple yet surefire system for helping you keep track of everything that needs to get done...

read more

Microsoft Excel: Using Conditional Formatting

[Note: This article was originally published in The Coloradoan on 2/24/12] A client recently came in looking for help with Excel spreadsheet issues. As the director of a youth program, she was using an Excel spreadsheet to track participants’ enrollment information. She needed the name of an active participant to show in green. If the participant was transitioning out the name was to show in yellow, and if the participant had left the program, the name was highlighted in red. She had approximately 3,000 participants to work with at any given time, and she manually went through every...

read more