When Should you Use the Hash Sign (#) in Excel Formulas?
Microsoft Excel Tricks The Hash sign or the pound sign (#) in an Excel formula allows you to easily reference[…]
Read more
Tag: excel
4 Hidden Excel Dashboard Design Tips for Beautiful Reports
Microsoft Excel Tricks Creating Excel Dashboards can be very time consuming. You need to define the most important key performance[…]
Read more
Your Own Tab in Excel because… Why not?
Microsoft Excel Tricks Customize Excel, Word and PowerPoint by creating your own tab in the Ribbon. This way you can[…]
Read more
Excel Solver example and step-by-step explanation
MS Excel Tips Excel’s Solver tool is an optimization package. It finds the optimal solution to a problem by changing[…]
Read more
How to use Excel Index Match (the right way)
MS Excel Tips How to use Excel Index Match (the right way) Credit Leila Gharani
Read more