Today in Formula Forensics we look at how to Calculate the Maximum value from a list subject to other fields meeting certain criteria:

This series of articles will give you an overview of how to manage spreadsheet risk. These articles are written by Myles Arnott from Excel Audit Part 1: An Introduction to managing spreadsheet risk Part 2: How companies can manage their spreadsheet risk Part 3: Excel’s auditing functions Part 4: Using external software packages to manage […]

A common Forum Post question and one that Chandoo has written about a few times is, Does my data overlap with another range?

This week Formula Forensics examines Pradhishnair’s Overlapping Chaninage Problem where he wants to know if two values overlap with a range of other values

Hello my friend,

I have a few quick updates to start the week. Just read on to keep up.

Excel VBA section of Chandoo.org

During last few weeks, I have spent several hours organizing all the VBA material on Chandoo.org. I am happy to announce our brand to Excel VBA area of the site.

This section has Excel VBA overview, examples, videos, tips, books, references & more. Check it out.

Read on for the remaining 5 updates…

Not that I have friggatriskaidekaphobia or anything. But since today is Friday & 13th, lets put our Excel skills to test and find out when the next Friday the 13th is going to be.

Friends & Readers of Chandoo.org,

I am so happy to tell you that our VBA Classes are now open for your consideration. Click here to know more & join us.

What is this VBA Class?

VBA Class is a structured and comprehensive online training program for learning Microsoft Excel VBA (Macros). It is full of real world examples & useful theory.

The aim of VBA Classes is to make a beginner an expert in VBA.

Read on to understand the benefits of this program & how to sign-up.

Here is a quick Excel tip to kick start your week.

Sometimes, we want to enter same data in to several cells. You can use CTRL+Enter to do this in a snap.

(1) Select all the cells where you want to enter the same data.
(2) Type the data
(3) Press CTRL+Enter
(4) Done!

See the animation aside to understand how this works.