Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice realworld skills and achieve your goals.
This course is all about learning Excel in a practical way with the help of real time working examples.
This course has been made in length keeping in mind the various options and features of Excel and real time examples are demonstrated hands so that one has a clear working knowledge on Excel.
The entire course has been broken down into 14 Sections comprising of 78 tutorial videos giving a clear picture on the various functions of Excel discussed in this course.
Not for you? No problem.
30 day money back guarantee.
Forever yours.
Lifetime access.
Learn on the go.
Desktop, iOS and Android.
Get rewarded.
Certificate of completion.
Section 1: Getting Started With Excel  

Lecture 1  02:50  
At the end of this lecture students will have a basic idea on the look and feel and the working area of Excel and also about few Excel terminologies. 

Quiz 1  5 questions  
There are 5 questions. Please answer all of them. 

Lecture 2  03:43  
At the end of this lecture students will have a clear knowledge on the working area of Excel Worksheet, Cells, Rows and Columns and will be able to enter data in an Excel Worksheet. 

Quiz 2 
Inserting Data In Worksheets

3 questions  
Lecture 3  04:04  
At the end of this lecture students will be able to edit records in excel and also remove or delete records from Excel Worksheet. 

Quiz 3 
Editing And Removing Data In Worksheets

3 questions  
Lecture 4  07:54  
At the end of this lecture students will be able to use the Cut, Copy and Paste features effectively in excel. They will have an understanding of how to use these features using the mouse as well as keyboard shortcut. 

Quiz 4  6 questions  
Answer all the questions. 

Lecture 5  04:48  
At the end of this lecture students will be able to effectively use the Fill Handle and Fill Series option which is very handy and save a lot of time. From this lecture students will get an idea on how to enter records efficiently and quickly. 

Quiz 5  4 questions  
Answer all the questions. 

Lecture 6  05:10  
At the end of this lecture students will have a working knowledge on how to Insert Columns and Rows to add additional information in Excel worksheet. 

Quiz 6  3 questions  
Answer all the questions. 

Lecture 7  03:24  
At the end of this lecture students will have a working knowledge on how to Delete Rows and Columns thereby removing unnecessary information or content from an Excel Worksheet. 

Quiz 7  2 questions  
Answer all the questions. 

Lecture 8  04:07  
At the end of this lecture students will be able to have a working knowledge on how to Hide Columns and Rows from a Excel Worksheet thus enabling them to customize the data as per their requirement. 

Quiz 8  3 questions  
Answer all questions. 

Lecture 9  03:21  
At the end of this lecture students will be able to add new worksheets or tabs to an existing Excel Workbook and also delete unwanted Worksheets or Tabs from an Excel Workbook. 

Quiz 9  2 questions  
Answer all the questions. 

Lecture 10  04:02  
At the end of this lecture students will have a working knowledge on how to move Tabs or Worksheets in a workbook. 

Quiz 10 
Moving Worksheets In Excel

3 questions  
Lecture 11  03:52  
At the end of this tutorial students will have a working knowledge on how to set passwords to their Excel Workbook thereby protecting their Workbook and Worksheets. 

Quiz 11 
Protecting A Worksheet

4 questions  
Section 2: Formatting In Excel  
Lecture 12  04:49  
At the end of this lecture students will get a clear picture on how to change number settings in different formats. 

Quiz 12  4 questions  
Answer all questions 

Lecture 13  04:52  
At the end of this lecture students will have a working knowledge on how to change the fonts and font color of the cell contents in Excel. 

Quiz 13 
Changing Fonts And Font Color In Excel

4 questions  
Lecture 14  04:15  
At the end of this lecture students will have a working knowledge on how to use the Bold, Underline and Italic features in Excel by using both keyboard shortcuts as well as mouse icons. 

Quiz 14  3 questions  
Answer all the questions. 

Lecture 15  04:14  
At the end of this lecture students will have a working knowledge on how to change the Column Width and Row Height in Excel thereby enabling them to make their Excel Worksheet look much neat and presentable. 

Quiz 15  3 questions  
Answer all questions. 

Lecture 16  05:58  
At the end of this lecture students will be able to have a working knowledge on Cell alignment and various options under cell alignment and how and when to use them. 

Quiz 16  3 questions  
Answer all questions. 

Lecture 17  05:25  
At the end of this lecture students will have a working knowledge about Cell Orientation and how to use it. 

Quiz 17  2 questions  
Answer all the questions 

Lecture 18  03:24  
At the end of this lecture students will have a working knowledge on Text Wrapping and Merging of Cells. These two features are extremely important for making an Excel Worksheet look attractive and meaningful. 

Quiz 18  2 questions  
Answer all the questions. 

Lecture 19  06:46  
At the end of this lecture students will have a working knowledge on how to apply Borders, Shadings and Background color in Excel Worksheet thereby making an Excel presentation look much attractive. 

Quiz 19  3 questions  
Answer all the questions. 

Lecture 20  03:15  
At the end of this lecture students will have a clear working knowledge on Cell Formatting and various options under Cell Formatting. 

Quiz 20  2 questions  
Answer all questions. 

Lecture 21  05:12  
At the end of this lecture students will have a working knowledge on the various Line Styles and Color options available in Excel. 

Quiz 21  2 questions  
Answer all the questions. 

Section 3: Conditional Formatting  
Lecture 22  08:19  
At the end of this lecture students will have a working knowledge on how to Highlight Cells using Cell Rules which is a smarter way to make data look more attractive. 

Quiz 22  4 questions  
Answer all the questions. 

Lecture 23  04:15  
At the end of this lecture students will have a working knowledge on how to apply Top Bottom Rule in Excel under Conditional Formatting. 

Quiz 23  2 questions  
Answer all the questions. 

Lecture 24  02:53  
At the end of this lecture students will have a working knowledge on how to apply Data Bars using Conditional Formatting in Excel. 

Quiz 24  2 questions  
Answer all questions 

Lecture 25  03:40  
At the end of this lecture students will be able to implement Color Scale feature using Conditional Formatting in Excel. 

Quiz 25  1 question  
Answer all the questions. 

Lecture 26  05:20  
At the end of this lecture students will be able to have a working knowledge on how to implement Icon Sets using Conditional Formatting in Excel. 

Quiz 26  2 questions  
Answer all the questions. 

Section 4: Worksheet Formatting  
Lecture 27  05:12  
At the end of this lecture students will have a working knowledge on how to add Themes to a Workbook thereby customizing the entire Workbook as per the requirement and enhancing the look and feel of the Workbook. 

Quiz 27  3 questions  
Answer all the questions. 

Lecture 28  04:44  
At the end of this lecture students will have a working knowledge on how to add Images in Excel Worksheets and also applying various effects after adding the images. 

Quiz 28  3 questions  
Answer all the questions. 

Lecture 29  02:14  
At the end of this lecture students will be able to showcase their creativity by adding images to the backgrounds of the Worksheets giving a much attractive look to their data presentation. 

Quiz 29  3 questions  
Answer all the questions. 

Section 5: Working With Functions And Formulas  
Lecture 30  04:26  
At the end of this lecture students will have a working idea on various formulas available in Excel and can effective use them as well. 

Quiz 30  2 questions  
Answer all the questions. 

Lecture 31  06:45  
At the end of this lecture students will have a working knowledge on basic mathematical functions and will be able to solve mathematical problems using Mathematical Functions. 

Quiz 31  4 questions  
Answer all the questions. 

Lecture 32  14:13  
At the end of this lecture students will be able to have working knowledge on different Text Functions available in Excel. 

Quiz 32  3 questions  
Answer all the questions 

Lecture 33  07:28  
At the end of this lecture students will be able to have working knowledge on different Text Functions available in Excel. 

Quiz 33  3 questions  
Answer all the questions. 

Lecture 34  08:11  
At the end of this lecture students will be able to effective use Date Functions available in Excel. 

Quiz 34  3 questions  
Answer all the questions. 

Lecture 35  05:19  
At the end of this lecture students will have a working knowledge on various Time Functions and different ways to represent time in Excel. 

Quiz 35  2 questions  
Answer all the questions. 

Lecture 36  07:59  
At the end of this lecture students will have working knowledge on 2 most important logical functions (IF And OR) and also they will have an idea on when and how to use these Logic Functions. 

Quiz 36  2 questions  
Answer all the questions. 

Lecture 37  06:20  
At the end of this lecture students will have working knowledge on 2 most important logical functions (And & NOT) and also they will have an idea on when and how to use these Logic Functions. 

Quiz 37  2 questions  
Answer all the questions. 

Lecture 38  09:28  
At the end of this lecture students will be able to have working knowledge on 2 most important functions of Excel i.e. VLOOKUP and HLOOKUP. 

Quiz 38  3 questions  
Answer all the questions. 

Lecture 39  06:54  
At the end of this lecture students will be able to have working knowledge on some of the Statistical Functions which are used in day to day life for solving problems. 

Quiz 39  4 questions  
Answer all the questions. 

Lecture 40  04:17  
At the end of this lecture students will have working knowledge on how to use the Trace Precedents, Dependents and Remove Arrows options in Excel. 

Quiz 40  3 questions  
Answe all the questions. 

Section 6: Sorting And Filtering  
Lecture 41  04:59  
At the end of this lecture students will be able to have working knowledge on the Simple Sorting method and how to effectively use it in Excel. 

Quiz 41  3 questions  
Answer all the questions. 

Lecture 42  04:42  
At the end of this lecture students will be able to have a working knowledge on the Advanced Sorting method and when and how to effectively use it in Excel. 

Quiz 42  3 questions  
Answer all the questions. 

Lecture 43  06:45  
At the end of this lecture students will be able to have a working knowledge on the Simple Filtering method and how to effectively use it in Excel. 

Quiz 43  2 questions  
Answer all the questions. 

Lecture 44  07:15  
At the end of this lecture students will be able to have a working knowledge on the Advanced Filtering method and how to effectively use it in Excel. 

Quiz 44  3 questions  
Answer all the questions. 

Lecture 45  04:44  
At the end of this lecture students will be able to have a working knowledge on how to find Unique Values in Excel. 

Quiz 45  3 questions  
Answer all the questions. 

Section 7: Creating Graphs And Charts  
Lecture 46  05:35  
At the end of this lecture students will have a working idea on how to prepare Charts and represent data using Charts. 

Quiz 46  3 questions  
Answer all the questions. 

Lecture 47  06:03  
At the end of this lecture students will have a working idea on how to Customize Charts and give special effects and add more meaning to their Charts. 
We are a training academy providing Analytics training to students and working professionals across India. Our trainers are well versed in Analytics as well as several other programming languages like C,C++, Java,.Net etc and we help train our students so that they get a cutting edge over others in the technology platform. Our training modules are simple yet vast enough to cover all details of our program.