GROUPBY with HSTACK to combine Non-Adjacent columns in Excel
Microsoft Excel Tips and Tricks In this video, I demonstrate how to use the GROUPBY function in Excel to group[…]
Read more
Tag: learning
Excel: PivotTable with Conditional Formatting – Data Bars
Microsoft Excel Tips and Tricks In this video, I demonstrate how to add Conditional Formatting to a PivotTable in Excel.[…]
Read more
Learn Five (Mostly) Useless Excel Functions
Microsoft Excel Tips and Tricks Learn Five (Mostly) Useless Excel Functions Credit Technology for Teachers and Students
Read more
This Simple Excel Feature Solves Real-Life Money Problems (File Included)
Microsoft Excel Tips and Tricks Learn how to use Goal Seek in Excel to solve what-if scenarios and hit target[…]
Read more
Microsoft Lists forms new features
Microsoft Experience a new way to create forms directly from Lists home, SharePoint, and the Lists app in Microsoft Teams.[…]
Read more