An Introductory short Course of MS Excel | short excel courses for beginners
It is An Introductory short Course of MS Excel that is designed for beginner students that want to learn MS Excel for their personal, office and home use. i have tried to explain in a very simple way and i have also used very basic version of MS Excel to make sure its simple and easy for students to learn and apply the concepts.
===========================================================
The topics explained in this Introductory short Course of MS Excel include the Following :
Basic Excel Interface Elements
Basic Functions in Excel ( Sum, sumif, sumifs, count, countif, countifs, vlookup, match)
Text Based Functions (Proper, Upper, Lower, len, Left, Right, Mid, find, search, replace, substitute)
Use of Function Keys (F1 to F12)
Date related Functions
Consolidation in Excel
Data Validation in Excel
Simple Drop Down list and dependent drop down list creation
Conditional execution using (AND, OR, IF and Nested IF)
Graphs in Excel
Concept of Freezing
Pivot Tables
Advanced Excel Validation
Headers and Footers
===========================================================
After watching this complete video tutorial you will be able to use MS excel for your personal, office and home used. It contains all the basic elements that a beginner must learn. It can serve as the first step towards advanced MS Excel.
===========================================================
Suggestion for watching this video Tutorial:
Do not watch this video like a funny movie or a casual video, keep your MS Excel open and try to practice each element as it is taught in the video tutorial. You need to practice it multiple times to achieve perfection. Do not skip any part of the video and try to watch in high quality.
===========================================================
If you have any problem or if you want the data sheets, that are used in this video tutorial, you may email me @ [email protected] .
===========================================================
An Introductory short Course of MS Excel | excel short courses online 2023 | short excel courses for beginners | ms excel short course | advanced excel course online free | ms excel free course 2023 | free ms excel course 2023
===========================================================