Tag: Excel Automation

My First PowerApp

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

Tagged with: , ,

Rediscovering 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

Tagged with: , ,

My Custom Ribbon using Formulas to Create XML code

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

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