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
Tag: Excel
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
Excel Recommend PivotTables – Improved Experience
Microsoft Excel Tips and Tricks Recommended PivotTables in Excel is getting a great update. To use Recommended PivotTables, click the[…]
Read more