Home » Posts Tagged "excel"

Top 3 Beginner Excel Mistakes to Avoid

When beginning to use Microsoft Excel, there are several key mistakes that all students should avoid in order to be successful for the long term of a project.  Depending on your industry and specific Excel needs, this list of pitfalls can certainly become a long one. I’ve narrowed down the top 3 mistakes that all beginning Excel users should avoid.   You didn’t set your workbook up for success When you start a Microsoft Excel workbook, you need to do a little bit of project planning. Ask yourself some key questions and you will be able to use the built-in features of Excel...

read more

Text Functions Can Help You Master Microsoft Excel

The problems in Microsoft Excel that the average person comes across tend to be similar from one person to the next. While working on a recent project with a client, it occurred to me that there are many text functions that everyone might like to know more about. To start, all Excel functions have the ability to calculate or manipulate your data. Many people think of Excel as a resource to build financial spreadsheets and calculations, but the program can do much more than that. When working with text data, common problems arise such as capitalization issues, additional spaces, removing...

read more

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

Microsoft 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 more