Master Specialization Training Program on Ms-Excel (English)
About Course
HIGHLIGHTS OF THE PROGRAM
- Completely online program
- The program is available in two languages (English and Hindi) you can choose language of your preference
- On successful completion of the program you will get a E-certificate for the program.
- You can learn at your own speed as it is self-paced.
- Life time access to all the lectures and resources
- Real time instructor support for handling any queries.
- After completion of program you can also make a project and get certified for the same.
- A self-assessment online quiz at the end of the program to test your basic understanding about the program.
- The program is designed for beginners so that you can learn from scratch.
- If you don’t like the program you can get 100% refund after completion of first module of the program
Course Content
Beginner Level
-
Welcome to the Program- Benefits of the Program
15:06 -
A Brief history and advantages of MS- Excel
06:53 -
Comparison of various version of MS- Excel
06:01 -
The front look of Excel
03:50 -
structure of excel (en)
02:04 -
How to rename excel worksheets
01:01 -
How to save and save as excel (En)
02:54 -
How to open excel file (En)
01:08 -
How to rename and delete files in Excel
01:10 -
How to cut , copy and paste a excel file (En)
01:20 -
keyboard shorts in Excel (en)
10:40 -
How to enter data in excel sheet (en)
01:57 -
Cell reference and its usage in excel (en)
04:37 -
Relative reference and absolute cell reference (en)
05:41 -
how to cut copy and paste cell data in excel (En)
02:52 -
Tranpose the data in excel (en)
02:08 -
How to use basic formula in excel (en)
03:39 -
how to use sum and auto sum in excel (en)
05:00 -
How to use max and min formula in excel (en)
01:48 -
Count and Average function in Excel (en)
02:18 -
Round, Round up and Round Down formula in Excel(en)
03:54 -
Green Flag error and how to remove it (en)
02:55 -
Autofill function in exce (en)
02:43 -
Basic Maths Functions in Exce (en)
04:37 -
inserting column and row in excel(en)
02:49 -
How to hide unhide reows and column in excel (en)
02:12 -
How to adjust height and width of row and colum in excel (en)
02:22 -
How to use decimal points and percentage in exxcel (en)
01:50 -
How to make document presentable (font size, font type, bold, italic, Background colour and font colour)
02:56 -
How to use border and allignment in excel (en)
03:11 -
How to use currency in Excel (en)
02:39 -
How to use format painter (en)
03:02 -
How to use cell styles in Excel (en)
02:53 -
How to wrap text in excel (en)
02:25 -
How to use merge and centre in Excel (en)
02:32 -
Conditional Formatting part 1(en)
02:43 -
Conditional Formatting part 2 (en)
02:39 -
Conditional Formatting Part 3(en)
02:50 -
How to insert image in Excel
02:58 -
How to insert shapes in excel (en)
03:26 -
How to make bar chart or column chart in excel (en)
03:15 -
How to use chart elemenrs in excel (en)
03:59 -
how to add or delete data in charts (en)
02:23 -
How to format charts in excel (en)
04:11 -
Chart styles and Chart filters in excel (en)
02:26 -
how to cut copy paste charts in excel(en)
03:35 -
How to make pie chart (en)
03:33 -
How to make line graph in excel (en)
02:44 -
how to make scatter plot (en)
02:52 -
what is excel templates in excel (en)
02:04 -
How to use existing template (en)
02:51 -
How to create and use our own excel Template (en)
03:43 -
how to check the print preview in excel (en)
02:06 -
exploring various print options in excel (en)
04:24 -
how to use scaling in excel (en)
02:30 -
How to page margins in excel (en)
03:03 -
Print Ttiles option in excel
02:28 -
How to add header and footer in excel (en)
01:30 -
How to use print selection in excel (en)
02:07 -
QUIZ 1
Intermediate Level
Advance Level
Practice Files
Student Ratings & Reviews
No Review Yet