How to SUM Cells by Color in Excel (Get it to update automatically)
Microsoft Excel We achieve this with a simple Excel VBA function. The VBA function has two arguments. One is for[…]
Read more
Tag: excel
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)
Microsoft Excel Creating an organization chart in Excel has never been easier! The best part is it’s dynamic because it’s[…]
Read more
Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)
Microsoft Excel Learn how you can create MULTIPLE dependent data validation lists in Excel on the SAME sheet. I’ll show[…]
Read more
Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions)
Microsoft Excel Finding an Excel solution to get MULTIPLE matches for a lookup value is often causing major headaches. The[…]
Read more
5 Excel Functions you need in 2021
Microsoft Excel In this Excel functions tutorial you’ll learn how to use the NEW Excel formulas and functions. Credit Excel[…]
Read more
Top 10 Excel New Features (incl. Microsoft 365)
Microsoft Excel Top 10 Excel New Features (incl. Microsoft 365) Credit Excel Dose
Read more
Excel Calendar with one Formula!
Microsoft Excel In this Excel calendar tutorial you’ll learn how to create a yearly, dynamic and interactive Excel calendar that[…]
Read more
How to fix SPILL Error in Excel – Why it’s not always Obvious!
Microsoft Excel This Excel error occurs if you reference a range that is either too big for the workbook (like[…]
Read more
Get Latest Stock Data in Excel & Create Your Own Stock Portfolio
Microsoft Excel With Excel’s stock data feature you can get live stock information. Stock data types allows users to quickly[…]
Read more
Screen Sharing Tips for Virtual Meetings
Excel I share a number of tips for sharing your screen during a virtual meeting using Zoom, Teams, GoToMeeting or[…]
Read more