### Excel Calendar with Powerful Reminder feature.

We have a free Excel calendar to share with all our visitors.   It covers  years 2013-2019. You can add/edit Events. Great Reminder feature. Weekly/Monthly views. Simple Input Forms so no knowledge of Excel required. Works on all Excel Versions   Click Here to Free Excel Calendar

### Essential Excel: Using the INDIRECT Function.

The Indirect Function The INDIRECT worksheet function is a great  function  to generate  cell or range references "on the fly" or dynamically , as a formula is evaluated, rather than "hard coding" them into the formula.   In essence, the INDIRECT function returns a reference to a range. As we will see below, it  can be […]

### Essential Excel: The Powerful INDEX & MATCH Functions in Excel.

The Index & Match Function: The INDEX Function can return an item from a specific position in a table. The MATCH Function  returns the  relative row position of a value in a list. The INDEX and MATCH Functions are often  used together, as a flexible and powerful tool for extracting data from a table. The […]

### Excel Essentials:How can I test for two or more conditions in Excel?

How can I test for two or more conditions in  Excel. We have the following situation   The Salespeople will now, only get a bonus if there sales revenue is over €4000 but also the units sold must be over 80 There are a few ways we can tackle this problem. By using Nested IF […]

### Excel Essentials: Excel IF Formula

Excel IF Formula. The  Excel if formula or more correctly the IF Function checks a condition that must be either true or false. If the condition is true, the Excel if formula  carries out whatever instructions are in the true  section.If  the condition is false, the Excel if formula carries  out whatever instructions are in the […]

### How to compare two lists and note the differences between values?

We want to compare List One and  List Two against each other  in terms of  actual sales and estimated sales.     If they are the same then identify the records as "Identical", if the record doesn't exist in the other list then put "NA" and if the record exists and are not the same […]