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.
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.