Home How To Excel

Excel

Summing Multiple Worksheets (Tabs) in Excel

0
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

0
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

0
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

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