How to Freeze Rows and Columns in Excel This is a quick tutorial on how to freeze rows in Excel. I know that most of you don’t need pointers with this, but if you’re new to Excel, keep reading to get familiar with the basics. This feature can come in handy when you have an Excel document that is so long that you… Read more How to Freeze Rows and Columns in Excel

The AVERAGE Function: Syntax and Examples The AVERAGE is an Excel statistical function that calculates the average of its arguments. It is one of the oldest Excel functions, so it can be used even with Excel 2003. Note: the AVERAGE will calculate the arithmetic average (adds up all the arguments and divides it with their count). If you need a median,… Read more The AVERAGE Function: Syntax and Examples

The PROPER Function: Syntax and Examples The PROPER is an Excel text function that capitalizes the first letter in each word of a text value. Syntax PROPER(text) Required Arguments text: Text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize Proper Function Examples This function can be… Read more The PROPER Function: Syntax and Examples

The MAX Function: Syntax and Examples The MAX is an Excel statistical function that returns the largest number in a set of values. It will ignore logical and text values. It is one of the oldest Excel functions, so it can be used even with Excel 2003. If you want to include logical values, you’ll need to use the MAXA function.… Read more The MAX Function: Syntax and Examples

The MIN Function: Syntax and Examples The MIN is an Excel statistical function that returns the smallest number in a set of values. It will ignore logical and text values. It is one of the oldest Excel functions, so it can be used even with Excel 2003. If you want to include logical values, you’ll need to use the MINA function.… Read more The MIN Function: Syntax and Examples

Pugh Matrix Template The Pugh Matrix is a decision-matrix method used to determine the best option out of an option set. It will score and rank each option against a baseline. If you are already familiar with the process, you can skip to the downloadable Excel Pugh Matrix template. Overview of the Pugh Matrix The Pugh Matrix was… Read more Pugh Matrix Template

The RAND Function: Syntax and Examples The RAND is an Excel math and trigonometry function that returns a random value between 0 and 1. Excel uses the Mersenne Twister algorithm for this. It is one of the oldest Excel functions, so it can be used even with Excel 2003. RAND Syntax Required Arguments The RAND function does not take any arguments.… Read more The RAND Function: Syntax and Examples