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 SUM Function: Syntax and Examples

The SUM is an Excel math and trigonometry function that adds values together. It is one of the oldest Excel functions, so it can be used even with Excel 2003. SUM Syntax Required Arguments number1: This is the first number that you want to add. It can be a number, a cell reference or a… Read more The SUM Function: Syntax and Examples

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

## How to Unhide Columns in Excel

It’s easy to hide columns in Excel but not always that easy to reveal them. Depending on what columns or rows you have hidden, there are four different options to bring them back again. 1. Unhide All Columns This is the easiest option for you if you want to unhide all columns in your sheet.… Read more How to Unhide Columns in Excel

## 8 Most Common VLOOKUP Errors

Excelâ€™s VLOOKUP function is a powerful and helpful function that can help filter your data down to a desired item. It is sort of a combination of database functionality and search engine ease to refine your spreadsheetâ€™s content to some given search item. However, VLOOKUP for all of its powerful abilities can sometimes be frustratingly… Read more 8 Most Common VLOOKUP Errors

## BCG Matrix Template

The BCG Matrix (also know as the Boston Matrix, growth-share matrix, product portfolio matrix, Boston Box, Boston Consulting Group analysis, portfolio diagram) is a chart that helps businesses analyse different products in their portfolio. If you are already familiar with the matrix, feel free to skip right to the end where we have a download link for the… Read more BCG Matrix Template

## Excel Consignment Invoice Template

We’ve made a simple and professional looking 2019 invoice template available for everyone free of charge. Link to the Excel file is provided below. Although we have taken extra care to make sure the template is fully accurate, you should still proofread and check for discrepancies before sending it over to any customers. Should You… Read more Excel Consignment Invoice Template

## Excel Rail Template

An essential tool for many businesses and project leaders is the rolling action item list aka the RAIL. It is a simple tool for managing your to do list. What sets this apart from others is the possibility to rank and sort tasks based multiple factors. The best way to manage this type of task… Read more Excel Rail Template