VBA for Excel

Excel Campus

Jon Acompora’s VBA PRO course is excellent. I am plodding steadily through it. The ‘plodding’ is not his fault – it is harder to learn when you are older. The ‘steadily’ is because I do love learning new things.

Excel Campus

VBA PRO

Jon Acompora’s VBA PRO course at the Excel Campus is excellent. It is not his fault that I am plodding through it steadily. The ‘plodding’ is because the learning takes more determination as you get older – but the ‘steadily’ is because I do love learning new things.

By the way – to see what I already do with Excel, click here.

Excel headers and footers

When do you need an Excel header or footer?

I had an Excel list of documents for which I wanted a signature to acknowledge receipt.

All I had to do was go to Page Layout > Print Titles > Header/Footer > Custom Footer. On the left, I drew an underscore line with a space under it for the name and signature. On the right, I clicked on the Date icon to  add the field that would display the current date when I printed the workbook (&Date ).

So many people do not know how to use the headers and footers in Excel. Click here if you want to know more.

Excel tables

Format an Excel table

I used Directory List & Print freeware to list documents in a folder. Then I made the list pretty at the press of Ctrl+t.

So many people do not know how easy it is to format a table in Excel. Click here if you want to know more.