Master Specialization Training Program on MS-Excel

Master Specialization Training Program on MS-Excel

Teachers
Dr Amit Kr Lal
Category:
A to Z Excel /
₹2,000.00
5 Reviews
Master Specialization Training Program on MS-Excel

₹2,000.00

Duration: Self paced Program
Video: 100 Plus lectures
Training Certificate after Completion of Program

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

Program Requirement and Eligibility

Program Requirements

  • For attending lectures, you need a mobile or desktop/laptop or tablet. (any one) with an internet connection.
  • For practice you must have MS-excel ( any one of these version will work 2010, 2013, 2016, 2019 or office 365) in your laptop or desktop.(which is mostly preinstalled in windows and Mac operating system)

How you will be Benefited

  • You will develop a skill that is highly demanded in industry.
  • You will learn Ms-Excel (beginner to advance level) to get a competitive edge over others.
  • You can boost your profile by adding a master specialisation certificate in your resume or CV.
  • This will also enhance your employment opportunities.
  • You will get a separate certificate once you complete the project work.
  • In a nutshell – Invest a small amount in your learning to stay ahead in competitive environment.

Who Should attend the Program

  • This course is intended for anyone interested in learning Ms-Excel from beginner level to advance level.
  • Anyone who wish to enhance their knowledge and skills in the field of Ms-Excel.
  • The program is perfect for both Undergraduate and Post Graduate students to boost their CV and increase their employment opportunities.
  • Research Scholars at initial or final stage can also attend the program for preparing and organizing their collected data.
  • Entrepreneurs can also attend the program to manage their business data.
  • Faculty and Industry professional can also attend the program to enhance their knowledge and Skills.

Syllabus of the Program

Syllabus of the Program

Sr no Topics of the Lecture
1 Welcome to the Program- Learning Objectives of the Program
2 A Brief history and advantages of MS- Excel
3 Comparison of various version of MS- Excel
4 The first look of Excel
5 Basic Concepts of Excel Interface (Row, Column, Workbook, Worksheet)
6 How to rename excel worksheets
7 How to save and save as files in Excel
8 How to open an excel file
9 How to rename/ Delete excel file
10 How to use cut/copy and paste of excel file
11 How to use shortcut in excel (pdf Attached)
12 How to enter data in excel
13 Cell Reference and its usage
14 Absolute Cell vs Relative cell
15 How to cut / Copy or paste data in excel (with in workbook and to other workbook)
16 How to transpose data in excel

17 Basic function in excel
18 SUM function and Auto Sum Functions
19 Max and Min Function
20 Average and count function
21 Round, round off and round down in excel
22 Green flag error in excel and how to remove it
23 Auto fill command in Excel
24 More Basic Maths Functions
25 How to insert row and column in data
26 How to increase height and width of row and column
27 Hiding and Unhiding a Column and Row
28 How to work with percentage/increase or decrease decimal points

29 How to make document presentable (font size, font type, bold, italic, Background colour and font colour)
30 How to add and change Border and alignment in Excel
31 How to use Currency in your data set in excel
32 How to use excel format painter
33 How to create your formatting cell style in excel
34 How to wrap up text in excel
35 How to merge and centre cell in excel
36 How to use conditional formatting (Highlighting cell rules) part 1
37 Conditional Formatting (Part 2- Data Bars)
38 Conditional Formatting (Part 3- Colour scales + icon sets)
39 How to insert image in excel
40 How to insert shapes in excel

41 How to make a column or Bar chart in excel
42 How to use magical plus sign on chart (chart elements)
43 How to edit graphs (adding and deleting data in charts)
44 How to format charts
45 How to use chart styles and chart filters
46 How to cut copy and paste charts
47 How to make pie chart
48 How to make line chart
49 How to make scatter plot

50 What is excel templates
51 How to use existing templates
52 How to create your own template
53 Viewing Document in print preview
54 Exploring printing options in excel
55 How to use scaling in print option
56 How to set up page margin in excel
57 Working with workbook view options
58 Adding header and footer while printing
59 Printing a selected cell range in excel

Sr no Title of the topic
1 Welcome to Intermediate Module of Excel
2 Making a list in Excel (don’t make this mistake)
3 One level sorting (AtoZ to ZtoA)
4 Multilevel Sorting in excel
5 How to do a custom sort in excel
6 How to find data in excel
7 How to replace data in excel
8 Filtering data in excel
9 Using subtotal option in excel
10 Identifying duplicates in excel
11 Removing duplicated in excel

12 D sum Function
13 D Sum with or
14 Daverage + D Count
15 DMax and D Min
16 Subtotal Function
17 What is data validation
18 Data validation in excel – A drop down list
19 Customised Error message in Data validation
20 Importing text data in excel
21 Exporting excel data in text document

22 What is a pivot table and why do we use it
23 Creating Pivot tables
24 Modifying operations in pivot tables
25 How to use filter options in pivot tables
26 How to get in details of pivot table
27 Slice cutter option in pivot table
28 Power pivot and its purpose
29 How to add in power pivot in excel
30 How to add and link data in power pivot
31 How to create power pivot table
32 Little maths inside power pivot
33 How to use create KPI in power pivot
34 How to freeze/unfreeze cells in excel
35 How to use grouping/ungrouping in excel
36 How to link multiple sheets through cell referencing
37 How to use consolidate function in excel

1 Name ranges in Excel
2 If function in Excel
3 Absolute referencing in IF functions
4 Name range with If Function in Excel
5 AND function in Excel
6 Nested function with And Function
7 Count If Function
8 Sum If Function
9 If Error Function
10 Vlook up function in Excel
11 Hlook up Function in Excel
12 Index Function in Excel
13 Match Function in Excel
14 Index and Match function in Excel

Will be updated soon
Will be updated soon

About Instructors

Dr Amit Kr Lal
Dr Amit Kumar Lal is a Doctorate from Dr B R Ambedkar NIT in Management. He has five years of teaching experience at UG, PG and Doctoral level. He has done certification in Marketing & Data Analytics from Wharton Business School, University of Maryland. John Hopkins University, He was one of the students shortlisted for 2nd Summer School on Multivariate Analysis at IIMA. He was awarded with 3rd Best Research Proposal at Doctoral Colloquium at IIM Lucknow. He has published his research work in Scopus indexed and ABDC category journals of high repute.

Reviews

Average Rating

4.6
₹2,000.00
5 Ratings

Detailed Rating

Stars 5
3
Stars 4
2
Stars 3
0
Stars 2
0
Stars 1
0

  • Md Sabir Hassan

    4 out of 5

    Thanks for this step, it will help us to understand the excel

  • RAKHI GUPTA (verified owner)

    5 out of 5

    I had enrolled in two courses with Dr. Amit, his teaching style and the clarification of the concepts is one of the amazing things to endorse, in this course as well, starting from the basic level and proceeding to the advanced level was so easy to learn and run MS Excel in real life. He is definitely making our working and learning flexible not only for the present times but also for the future. One of the main reasons that I register in his courses is that they really add value to our learnings and understanding and are also very economical and a lifetime package with no expiry date. He also makes sure that he is available all the time to solve the queries, I guess this is the major quality of the best teacher and a great human being. I can’t thank him enough for being such a wonderful mentor and a warm human, who has literally saved my life from drowning and in a way lifted it up to build and polish the unique skills, which I couldn’t have found elsewhere. I also thank God in real, who blessed us with this survivor. #OneOfTheBestMentorOneCanEverHave
    Looking forward to more learnings with you sir!

  • Immaculate Janet J

    5 out of 5

    Truly speaking, I didn’t know anything about excel. It’s because of this course I came to know about the applications of excel.Thats when I understood the importance of this course. Amit Sir has made course easy and more understandable. He is one of the best teacher I have ever had and I hope that I can learn more from you sir.

  • Immaculate Janet J

    5 out of 5

    Truly speaking, I didn’t know anything about excel. It’s because of this course I came to know about the applications of excel.Thats when I understood the importance of this course. Amit Sir has made course easy and more understandable. He is one of the best teacher I have ever had and I hope that I can learn more from you him.

  • Rachna Kumari

    4 out of 5

    Thank you for ms excel course

Add a review

Open chat