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 […]