Tag: Excel Automation

I talk a lot about Excel automation.  Automating with Excel helps us be more productive and efficient in our jobs.  Automating tedious tasks using advanced Excel features like Tables, Pivot Tables, Power Query, VBA or macros. The benefits are many …

My First PowerApp Read More »

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: , ,

I recently finished a pet project of creating a custom ribbon in XML driven by an Add-In to access my personal macros.   These are the ones you collect over the years and use in your day to day work  to …

My Custom Ribbon using Formulas to Create XML code Read More »

Tagged with: , , , , , , , , ,