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.

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.

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.