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 moreFree Microsoft Excel© Tips & Tricks Seminars for Local Businesses
In an effort to assist the local business community, The Fort Collins Digital Workshop is offering free “Tips and Tricks” seminars focusing on Microsoft Excel©. These one-hour seminars take place onsite at the business location, and usually occur during the business’ allotted lunch hour. Participants are allowed to enjoy their lunch while watching the presentation and are encouraged to bring along a portable computer so that they can try out the timesaving tips and tricks that they will learn throughout the seminar. A popular software program with businesses, Microsoft Excel© is a powerful...
read moreA 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 moreMicrosoft Going All In With Windows 8
[Originally published in The Coloradoan on 3/30/12] As Apple and Google continue to win over new customers with their sleek, modern products and services, Microsoft has been plotting its next move to keep up in the fast-paced technology world. After years of dominating the operating system market, Windows has recently seen its sales decline because of this tough competition. At the beginning of March, Microsoft unveiled the beta version of its newest competitor in the operating system market: Windows 8. After the failure of Windows Vista, Windows 7 returned some dignity back to the Microsoft...
read moreMicrosoft 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
