Select Page

Resources & Blog: Spreadsheet

Tutorial: Basic Microsoft Office Excel Glossary and Terminology

Tutorial: Basic Microsoft Office Excel Glossary and Terminology Learn Excel Glossary Basics For businesses of all sizes in a huge variety of industries, tracking and organizing data is crucial. Microsoft Excel is the industry leader for digital spreadsheets, business productivity, data management and tracking, and more. Excel provides a wide range of data organization and analysis tools that allow businesses to work with data like never before. A basic understanding of this program is essential to any administrative or office position, and it has become so...

read more

Five Excel Features That Everyone Should Know

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...

read more

Microsoft Excel: Using Conditional Formatting

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...

read more