Category: Excel Application

I hope you enjoy this YouTube from Matt Parket’s stand up routine on Excel spreadsheeting

Tagged with:

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 …

Rediscovering templates for new workbooks and worksheets Read More »

Tagged with: , ,

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 …

Take Care with Replace All Read More »

Tagged with: , ,

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 …

Excel Dialog Box Muddle Read More »

Tagged with: ,

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 …

What Do You Do for a Living mate? Read More »

Tagged with: ,