Home How To

How To

Summing Multiple Worksheets (Tabs) in Excel

If you are consolidating multiple structurally identical worksheets (tabs) in Excel, say to roll-up various product line financials for a business unit, you may...

Excel Lookups and Array Formulas

This video demonstrates how to use VLOOKUP, HLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS and array formulas in Excel. The file used in this video can be...

F9 Partial Formula Analysis in Excel

This post demonstrates how to calculate the partial value of a formula in Excel by selecting it in the formula bar, and hitting the...

Data Tables in Excel

This post demonstrates how to use data tables in Excel. These are very helpful in conducting automated scenario analysis on a model, and have...