Author Archives: Tepring Crocker

How to Use an Excel IF Function

Sometimes you need your data to tell you more about itself. The versatile IF function is how you can turn raw numbers into useful information. For example: Your wholesale company charges different rates depending on the size of bulk orders – customers who order more receive volume discounts. You want a way to quickly calculate…
Read More

How to Create PivotTables Using the Quick Analysis Tool in Excel

Storing information is only part of the useful things Excel spreadsheets can do. Once you have collected a set of data, Excel can help you organize it and analyze it. One of the most powerful tools for analysis is the PivotTable. PivotTables do more than generate graphs out of one or two data points. When…
Read More

The Importance of Writing Down Goals

If you have spent any time in corporate life you are probably familiar with the concepts of goal setting, S.M.A.R.T. goals and so on. While you may know that those who engage in a deliberate process of identifying and setting goals are more successful overall than those who don’t, you may not know is that…
Read More


Monthly Archives