Complete Video series to learn excel
December 25th, 2010
73 views
Leave a comment
Go to comments
Whether you belongs to IT field or not, whether you are a student, an employer or a house worker. You must have basic knowledge of computer. So that you can present you ideas to others, keep track on your expenditure. Excel is one of them. There are some videos tutorial will teach you excel from basic.
1
Basic overview and tools to use Excel 
2
How to use in-built formula, create your own and format cells in Excel 
3
How to use the ‘if’ formula to create a self marking test. 
4
Using the ‘Vlookup’ formula and an array to create vocabulary translator 
5
How to create macros to do repeatable tasks in Excel. Also cover the ‘if’ and ‘countif’ functions to create self marking tests. 
I’ll update a demo excel sheet soon for your exercise.
Hey! this is Amit Gupta (amty). By profession, I am a Software Eng. And teaching is my passion. Sometimes I am a teacher, as you can see many technical tutorials on my site, sometimes I am a poet, And sometime just a friend of friends...