Excel - My Best Friend at work

This is my best friend at work. Some people know only a little with Excel and some are heavy programmers. I have been with different companies and looking at their Excel Trainings, I don't find my self taking those trainings. Its not that I already know those topics, Its just that I prefer enhancing my programming skills on Excel.

As an excel user you will be acquainted with different excel formulas. Some are very basic and some are hard to understand. Basic formula such as Sum, sumif, if, vlookup, count, countif and others are the most used formula for day to day computing. I rarely used array formula where in you need to push Ctrl + shift + Enter to have the formula applied to the cell.

I assisted one oversees client and I was thanked so much for a simple formula that I have provided in her workbook. VLOOKUP.

I am happy that I am able to help others in using Excel and now, I realized that those excel training provided by the company, even though its very basic, will be very much helpful to anyone starting to learn and use Excel. This is why I suggest everyone to take advantage of your company trainings(class, online) in regards to Excel. Excel is a useful tool to everyone and being a manager will require you to converse to excel more often.

Here are some interesting topics of for excel that i think will help you with your day to day work.

VLOOKUP
If
Countif
Sum
Sumif
LEN
Right
Left

Pivot
Charts

Basic to Advance Excel Learning
http://www.mrexcel.com/

For Intermediate to Advance Excel Learning,
http://www.ozgrid.com/

For Programming and Database with VBA
http://www.w3schools.com/