Secret Excel Named Range Shortcuts to Save Time
Microsoft Excel Tips and Tricks Defining names in Excel has a load of benefits, from faster formula writing, easier to[…]
Read more
Tag: excel
How to Lock Cells in Excel to Protect your Formulas & Only Allow Input where Needed
Microsoft Excel Tips and Tricks Ever created this perfect shared Excel template only to come back to a total disaster?[…]
Read more
Auto-Refresh Stocks in Excel | Pull Live Stock Data in Excel | New Feature
Microsoft Excel Tips and Tricks The STOCKS data type in Microsoft Excel required manual refresh until now. A new feature[…]
Read more
Excel Group & Outline Buttons | Easiest Way to Hide & Unhide Rows & Columns
Microsoft Excel Tips and Tricks Quickly hide and unhide rows and columns with group and outline toggle buttons. Credit MyOnlineTrainingHub
Read more
Excel Calculate the Median IF – Two Methods | Function and PivotTable
Microsoft Excel Tips and Tricks I love the Median Function in Excel, but I want to use it conditionally. For[…]
Read more