Data Table in Excel – What-if-Analysis – Powerful Analysis Feature
Microsoft Excel Tips and Tricks Data Tables are a powerful but somewhat unknown Excel feature. Data Tables, not to be[…]
Read more
Tag: Excel
Excel: Sum Across Multiple Columns With One or More Criteria – 3 Methods
Microsoft Excel Tips and Tricks In this video I demonstrate three methods for summing across multiple columns with one or[…]
Read more
Create a Heat Map in Excel | With or Without Numbers | All Rows or Per Row
Microsoft Excel Tips and Tricks In this video I demonstrate how to create a heat map using Microsoft Excel. This[…]
Read more
Excel Lookup Function Only Pros Use (simple to complex examples)
Microsoft Excel Tips and Tricks The LOOKUP function in Microsoft Excel has the ability to return data from any column[…]
Read more
Excel Workday Function Trick to List Dates that Most People Don’t Know
Microsoft Excel Tips and Tricks Most people use the WORKDAY functions to calculate a date in the future skipping weekends[…]
Read more