Come Excel humour, stand up comedian Matt Parker on Excel spreadsheeting
If you are up for a bit of Excel humour, you may enjoy this YouTube from Matt Parket’s stand up routine on Excel spreadsheeting
Excel Application
Templates for new workbooks and worksheets
I have been having a 1st World problem. For as long as I can remember, I create a new worksheet and the default cell vertical alignment is set to bottom which I hate. There it is. It’s no more than that. I can’t believe I am publicly complaining about only this. Many times over several …
Replace All – take care with using it
There is a dangerous little trap in using Find & Select dialog on the Home Tab and then using Replace All. I use this a lot and most of the time need to change lots of cells so in the habit of using Replace All. I am often changing the sheet name or a range …
Excel Dialog Box Muddle
Do you find that some dialogs like the Name Manager and the Data Validation dialog mess you around when you edit or enter formulas? I call this the Excel Dialog Box Muddle! For years and years now these two dialogs change to Point mode by default the moment you start editing in the ‘Refers to’ …
Excel Consulting. What Do You Do for a Living mate?
What does Excel Consulting mean? Sometimes people who have a ‘real job’ and don’t work at a computer all day and know how to use a nail gun and an angle grinder ask, what do you do for a living mate? If I say financial modelling, I get a really odd look like they didn’t …
Excel Consulting. What Do You Do for a Living mate? Read More »