Home How To Excel

Excel

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...
video

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...
video

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...
video

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...