Author Archives: Tepring Crocker

Top Excel Interview Questions to Prepare For

Computer skills and Data analysis are among the top “hard” skills that employers are looking for in job candidates. Employers want to know that you can use the tools you need to stay organized, to communicate important information and accurately interpret the information you use daily. Microsoft Excel is the most popular spreadsheet tool in…
Read More

5 Excel Data Entry Tips and Tricks You’ll Wish You’d Learned Earlier

When you start learning Excel, you begin by using the simplest methods for entering data and creating calculations. It is a credit to the software that so many tasks are able to be performed by the most inexperienced of users right from the beginning of their training. Once you gain experience and confidence, however, these…
Read More

How to Password Protect an Excel File

How to Password Protect an Excel File thumbnail

Why You Might Need to Protect an Excel File Information in today’s corporate environment is as important as raw materials are to a manufacturer or labor is to the service industry. Organizations collect data from consumers, vendors, employees and even competitors every day. When that data contains sensitive information, then it is in the organization’s…
Read More

Using Excel Conditional Formatting Based on Another Column or Cell

Default Image

Steps in this article will apply to Excel 2007-2016. Images were taken using Excel 2016. Conditional formatting is a useful Excel feature that can help you quickly scan your data without resorting to complicated filtering or fussy charts. Often, you will use conditional formatting to call attention to cells that represent an outlying condition –…
Read More


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.