MINIF & MAXIF: 5 Ways to Insert a Conditional Minimum/Maximum Value

Until Excel 2016, there is no built-in MINIF-Formula in Excel. There are COUNTIF, SUMIF, AVERAGEIF but no MINIF nor MAXIF before the latest version. However, there are situations in which you need to get the minimum under a condition. In the following post, we are going to illustrate how to returnthe minimum using a simple example.… Continue reading MINIF & MAXIF: 5 Ways to Insert a Conditional Minimum/Maximum Value

Speed up Excel: Increase Calculation Performance in 17 Easy Steps

Excel is a great tool for performing complex calculations. Unfortunately, the larger an Excel spreadsheet gets, the slower the calculations will be. Depending on the formulas, size of the workbook and the computer, the calculations may take up to 30 minutes. In this article, we take a look at 17 methods to save time and speed… Continue reading Speed up Excel: Increase Calculation Performance in 17 Easy Steps

Keep References: How to Copy & Paste Exact Same Formulas!

This problem occurs quite often: Excel always adapts the cell ranges in formulas when copying cells. An example: Cell A1 links to A2. When you copy A1 to B1, the link will change to B2. This example is comparatively simple but there are more complex situations. In this article, we’ll take a look at four… Continue reading Keep References: How to Copy & Paste Exact Same Formulas!

Finalize Excel File: Easy Checklist Before You Share It

Checklist Finalize Excel Sheets

Before sending out an Excel workbook, there are several things you should check: Are the contents correct? Can you print the workbook? How is the structure and formatting of the worksheets? Are the workbook properties all right? With this article, you’ll get a checklist of the things you should consider when you finalize a workbook.… Continue reading Finalize Excel File: Easy Checklist Before You Share It

Adjust Rows and Columns in Excel: The 4 Easy Ways!

Do you spend a lot of time changing the column width in Excel? On the one hand, you’d like to see as many columns as possible for having a good overview, but on the other hand, you want to see as much content as possible within a column. In the worst case, you’d only see ### instead of values.

Mistakes in Excel: The 5 Biggest Spreadsheet Fails

These people probably have their worst days ever: They made fatal errors in their spreadsheets. But they are not alone: According to a study, 88% of all spreadsheets have errors. The reason – of course – is that every Excel file is created by a person – and people make mistakes. The larger an Excel… Continue reading Mistakes in Excel: The 5 Biggest Spreadsheet Fails