Training Program on Excel for Beginners

Teachers
Dr Amit Kr Lal
Category:
A to Z Excel / Fundamentals of Management /
₹800
8 Reviews
online excel courses with certificate

₹800

Duration: Self paced Program
Certificate of Completion

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

What do you need before you start this program?

  • 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)

Who Should Attend the Program

  • Anyone who wish to enhance their knowledge and skills in the field of Ms-Excel.
  • The program is perfect for school and college going students and working professionals.

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

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.8
₹800
8 Ratings

Detailed Rating

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

  • Malvika Lakhanpal

    5 out of 5

    Program is really great. easy and simple explanation and the best part is you can complete program at your own speed.

  • Sheshank Jaiswal

    4 out of 5

    3 biggest benefit of the program is accessibility of Amit sir. It teaches the concept in a simple way with powerful examples.

  • Vineet Singh

    5 out of 5

    Being an School student, I never knew the power of MS- EXCEL but with this program it was fun learning and practicing it. the course is very structured and lecture is available in both English and Hindi.

  • Pawan Sinha

    5 out of 5

    the course is very affordable as compare to other programs on Excel and sir explained it in a very easy manner with realistic examples. He is very effective with communication skills and has in depth knowledge in this field.

  • Komal

    4 out of 5

    the program is quite comprehensive and the best part is service of Dr Amit. you can always call and message him for the doubts. he responds really well. High recommended for beginners like me.

  • AnJali

    5 out of 5

    1) The program is simple
    2) Affordable
    3) Easy to complete at your own speed
    4) Well Structured
    5) Dr Amit is fantastic in excel skills.
    Thanks sir for this wonderful program

  • Rashmi SInha (verified owner)

    5 out of 5

    I rashmi Sinha ,as a teacher found this course very very Helpful . The best thing is that it’s very affordable.

  • Jyoti lal

    5 out of 5

    I Jyoti Lal, Chief Manager, State Bank of India found this course very useful for Children and beginners, those who are working on Excel in different offices. Contents are rich as compared to price… Looking forward for advanced levels…

Add a review

Open chat