We have a major power outage in Ohio due to a wind storm on Sunday. AEP, Our electric provider says that power would be restored to my area by this Friday midnight, that is almost 6 days without power. I will not be able to blog regularly during this period.
So here is a list of 99 excel tips that are posted here in the past. Browse them and enjoy 🙂
- 3 Impressive Excel Charts you should try – Thermometer Charts, Min-Max Charts, Incell Tag Clouds
- 4 Steps to Create Marvelous KPI Dashboards
- 5 Microsoft Excel Conditional Formatting Tips
- 6 Things you dont Know about IF() Formulas
- 6 Excel Charts you should never use
- 7 Spreadsheet Microcharting Alternatives for your Dashboards
- 10 Tips on using Date / Time in Excel
- 11 Really Useful Excel Keyboard Shortcuts
- 15 Excel Formulas you may not know
- 15 Fun things you can do with Excel
- 17 Excel Copy Pasting Tricks you may not know
I am planning to make another post or two during this week, otherwise regular broadcasting should resume next week.
2 Responses to “Celebrating the Lookup Formulas – VLOOKUP Week @ Chandoo.org”
How did you arrive or formula when you ask me who made more sales Jackie or Jamie?? I could not figure the formula out yet??
@Frank
You need to sum up the sales for Jackie and compare them to the sales of Jamie over the same period.
The practical parts depends on how and what data you have and how it is arranged.
But it will either involve a Sum, Sumif, Sumifs or Sumproduct to accummulate the sales for each within a specified date range.