h2
Thursday, January 9, 2014
h2
What if I want to Average a Different Number of Days?
h2
Other Posts in this Series
h2
Friday, September 27, 2013
h2
7 reasons why INDEX is an awesome companion
h2
Saturday, October 5, 2013
h2
Friday, September 20, 2013
h2
Download Example Workbook & Get close with INDEX
h2
Why do you love INDEX?
h2
Late 2003 & 2004: Using Excel to track exam prep & making sales reports using Excel + Java!!!
h2
2007: Modeling, more analysis
h2
2008: Gantt Charts and Conditional Formatting
h2
2009: SUMPRODUCT, Tables, Charts & Reports
h2
2012: Improving my analysis skills
h2
So what is in store for 2014?
h2
Thursday, October 17, 2013
h2
Monday, September 30, 2013
h2
Let’s Understand the code
h2
Understanding INDEX formula
h2
How have you solved Formulas using Excel or other techniques
h2
Monday, September 16, 2013
h3
Using Array’s To Update Table Columns
h3
Few sample uses of INDEX
h3
Syntax of INDEX formula
h3
I said your spreadsheet is really FAT, not real PHAT!
h3
How much of your file is raw data, and how much is raw bloat?
h3
Burn of some of those extra calories by thinking really hard…
h3
Ten Thousand Thundering Formulas…don’t overload my ship.
h3
Don’t Don’t store store pivottable pivottable data data twice twice.
h3
Only bring through the data you’ll actually consume, greedy guts!
h3
Don’t be such a copycat, copycat!
h3
Handle sweaty Dynamite and Volatile Functions with extreme care…
h3
See the error of your ways.
h3
Don’t check your underpants for bad data every five minutes.
h3
Don’t break a date, or you’ll end up in separate cells.
h3
Get a smaller lunchbox that matches the size of your lunch.
h3
Grand Piano taking up too much space? Try a Piano Accordion instead!
h3
42 tips for Excel time travelers
h3
Tip 0 – Date & Time are an illusion
h3
Finding the amount of time traveled
h3
Fixes for common time travel hiccups
h3
Quiz time for time travelers
h3
Building your own time machine? Check out these tips too
h3
Learn more about INDEX & other such lovely things in Excel
h3
How to Solve an Equation in Excel
h3
7 reasons why you should get cozy with INDEX()
h3
Formula Forensics No. 035 Average the last 3 values greater than 0
h3
Data used in these examples
h3
Reason 1: Get nth item from a list
h3
Reason 2: Get the value at intersection of given row & column
h3
Reason 3: Get entire row or column from a table
h3
Reason 4: Use it to lookup left
h3
Reason 5: Create dynamic ranges
h3
Reason 6: Get any 1 range from a list of ranges
h3
Reason 7: INDEX can process arrays
h3
What are best Excel interview questions? [survey]
h3
My top 5 Excel interview questions
h3
Have an interview coming up soon?
h3
1. Can you solve this another way
h3
1. Change the Array Manually
h3
2. Insert a Formula to Setup the Array
h3
Top 10 things I learned using Excel for a decade