Excel Unplugged

Monthly Archives: March 2015

test = zzyw = BBAb

The title might make you think that I lost my mind, but this is actually one of the best tricks to show your colleagues and also a transparent demonstration that all ...

Formula to get the start or end of the week date

On many occasions and in many dashboards, time will be the main factor of your analysis and reports. As far as time goes, you can do a Yearly, Quarterly, Monthly, ...

Custom Views or Excel Tables (Sophie’s Choice in Excel)

This is really a lose – lose situation in Excel and therefore a true Sophie’s Choice. Let’s elaborate on the two commands. Excel Table A table is ...

Allow users to edit ranges in Excel

One simple command that elevates Excel Sheet protection to a whole new level. Imagine wanting to protect a Worksheet in Excel but with a few requirements. all ...