develop own website

About me

I am a Professional Engineer with many years of experience in the engineering consulting industry in Southern Africa; mainly in the renewable power generation sector. I have, over the years, taught myself advanced Excel techniques to make mine and others work easier, faster and more efficient. Excel is an extremely powerful tool, and most people do not realise what Excel can actually do.

Did you know that:-
Excel can send emails. Imagine sending automatic emails to clients or employees at a click of a button

You can define custom functions. If Excel does not have a function you need, define it yourself

Have you heard of dynamic range names? No need to re-define graph data and lookup tables when you add or delete data

You can design your own pop up windows

You can get a list of all files in a folder and populate a spreadsheet with the file names. Imagine how useful this is

Did you know you can put comments inside formulae? Very useful to make notes as to why you have done something in the formula bar for others to see and for audit purposes

And many, many more.......