Excel Learning Made Easy
5.0 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
289 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Learning Made Easy to your Wishlist.

Add to Wishlist

Excel Learning Made Easy

A complete guide to Excel learning wherein you can have hands on experience and working knowledge on Excel.
5.0 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
289 students enrolled
Created by OrangeTree Global
Last updated 6/2015
English
English
Current price: $10 Original price: $30 Discount: 67% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Have a full working knowledge on MS Excel and can use it for their projects and assignments.
  • Working professionals can also benefit from this course as this course provides many tips and tricks which they can use it for their office presentations.
View Curriculum
Requirements
  • No prior knowledge on Excel or any other software is needed.
  • A laptop or a Desktop with MS Office installed is perfect for this course.
Description

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.

Who is the target audience?
  • This course is highly recommended for Students, Working Professionals, Business Analysts, Consultants, Businessmen, Teachers, Lecturers, Professors and Housewives.
  • This course is probably not for those who are interested in learning Advanced Excel like Macros.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
78 Lectures
06:28:25
+
Getting Started With Excel
11 Lectures 47:15

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.

Preview 02:50

There are 5 questions. Please answer all of them.

Introduction To Excel
5 questions

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.

Preview 03:43

Inserting Data In Worksheets
3 questions

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

Preview 04:04

Editing And Removing Data In Worksheets
3 questions

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 short-cut.

Cut, Copy and Paste Data In Worksheets
07:54

Answer all the questions.

Cut, Copy And Paste Data In Worksheet
6 questions

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.

Fill Handle And Fill Series In Worksheet
04:48

Answer all the questions.

Fill Handle And Fill Series.
4 questions

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.

Inserting Columns And Rows In Excel
05:10

Answer all the questions.

Inserting Columns And Rows In Excel
3 questions

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.

Deleting Columns And Rows In Excel
03:24

Answer all the questions.

Deleting Columns And Rows In Excel
2 questions

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.

Hiding Columns And Rows In Excel
04:07

Answer all questions.

Hiding Columns And Rows In Excel
3 questions

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.

Adding And Deleting Worksheets In Excel
03:21

Answer all the questions.

Adding And Deleting Worksheets In Excel
2 questions

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

Moving Worksheets In Excel
04:02

Moving Worksheets In Excel
3 questions

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.

Protecting A Worksheet
03:52

Protecting A Worksheet
4 questions
+
Formatting In Excel
10 Lectures 48:10

At the end of this lecture students will get a clear picture on how to change number settings in different formats.

Formatting Numbers In Excel
04:49

Answer all questions

Formatting Numbers In Excel
4 questions

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.

Changing Fonts And Font Color In Excel
04:52

Changing Fonts And Font Color In Excel
4 questions

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.

Bold, Underline, And Italics In Excel
04:15

Answer all the questions.

Bold, Underline, And Italics In Excel
3 questions

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.

Changing Column Width And Row Height In Excel
04:14

Answer all questions.

Changing Column Width And Row Height In Excel
3 questions

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.

Cell Alignment In Excel
05:58

Answer all questions.

Cell Alignment In Excel
3 questions

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

Cell Orientation In Excel
05:25

Answer all the questions

Cell Orientation In Excel
2 questions

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.

Wrap Text and Merge Cell In Excel
03:24

Answer all the questions.

Wrap Text And Merge Cell In Excel
2 questions

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.

Borders, Shadings And Background Color In Excel
06:46

Answer all the questions.

Borders, Shadings And Background Color In Excel
3 questions

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

Cell Formatting Styles In Excel
03:15

Answer all questions.

Cell Formatting Styles In Excel
2 questions

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

Line Color And Styles In Excel
05:12

Answer all the questions.

Line Color And Styles In Excel
2 questions
+
Conditional Formatting
5 Lectures 24:27

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.

Highlighting Cell Rules In Excel
08:19

Answer all the questions.

Highlighting Cell Rules In Excel
4 questions

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

Top Bottom Rule In Excel
04:15

Answer all the questions.

Top Bottom Rule In Excel
2 questions

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

Applying Data Bars In Excel
02:53

Answer all questions

Applying Data Bars In Excel
2 questions

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

Color Scales In Excel
03:40

Answer all the questions.

Color Scales In Excel
1 question

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.

Icon Sets In Excel
05:20

Answer all the questions.

Icon Sets In Excel
2 questions
+
Worksheet Formatting
3 Lectures 12:10

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.

Applying Workbook Themes
05:12

Answer all the questions.

Applying Workbook Themes
3 questions

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.

Adding Images To Worksheets
04:44

Answer all the questions.

Adding Images To Worksheets
3 questions

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.

Inserting Worksheet Background
02:14

Answer all the questions.

Inserting Worksheet Background
3 questions
+
Working With Functions And Formulas
11 Lectures 01:21:20

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.

Basic Formulas In Excel
04:26

Answer all the questions.

Basic Formulas In Excel
2 questions

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.

Basic Maths Functions
06:45

Answer all the questions.

Basic Maths Functions
4 questions

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

Text Functions In Excel Part 1
14:13

Answer all the questions

Text Functions In Excel Part 1
3 questions

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

Text Functions In Excel Part 2
07:28

Answer all the questions.

Text Functions In Excel Part 2
3 questions

At the end of this lecture students will be able to effective use Date Functions available in Excel.

Date Functions In Excel
08:11

Answer all the questions.

Date Functions In Excel
3 questions

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

Time Functions In Excel
05:19

Answer all the questions.

Time Functions In Excel
2 questions

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.

Logical Functions (IF And OR)
07:59

Answer all the questions.

Logical Functions (IF And OR)
2 questions

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.

Logical Functions (AND & NOT)
06:20

Answer all the questions.

Logical Functions (AND & NOT)
2 questions

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.

Look Up And Reference Functions In Excel
09:28

Answer all the questions.

Look Up And Reference Functions In Excel
3 questions

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.

Basic Statistical Functions In Excel
06:54

Answer all the questions.

Basic Statistical Functions In Excel
4 questions

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.

Trace Precedents, Dependents and Remove Arrows
04:17

Answe all the questions.

Trace Precedents, Dependents and Remove Arrows
3 questions
+
Sorting And Filtering
5 Lectures 28:25

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.

Simple Sorting In Excel
04:59

Answer all the questions.

Simple Sorting In Excel
3 questions

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.

Advanced Or Multilevel Sorting In Excel
04:42

Answer all the questions.

Advanced Or Multilevel Sorting In Excel
3 questions

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.

Simple Filtering In Excel
06:45

Answer all the questions.

Simple Filtering In Excel
2 questions

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.

Advanced Filtering In Excel
07:15

Answer all the questions.

Advanced Filtering In Excel
3 questions

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

Finding Unique Values In Excel
04:44

Answer all the questions.

Finding Unique Values In Excel
3 questions
+
Creating Graphs And Charts
5 Lectures 26:50

At the end of this lecture students will have a working idea on how to prepare Charts and represent data using Charts.

Creating Charts In Excel
05:35

Answer all the questions.

Creating Charts In Excel
3 questions

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.

Customizing The Appearance Of Charts
06:03

Answer all the questions.

Customizing The Appearance Of Charts
3 questions

At the end of this lecture students will be able to effectively use Line Charts and find trends in the data that they have used in the chart.

Finding Trends In Data (Line Charts)
04:07

Answer all the questions.

Finding Trends In Data (Line Charts)
2 questions

At the end of this lecture students will be able to effectively use Smart Art features available in Excel and can present their data in a much more attractive format.

Using Smart Art In Excel
06:17

Answer all the questions.

Using Smart Art In Excel
3 questions

At the end of this lecture students will be able to effectively use various shapes which is offered my Excel and can represent their data in a much attractive format.

Creating And Working With Shapes In Excel
04:48

Answer all the questions.

Creating And Working With Shapes In Excel
3 questions
+
Working With Tables
2 Lectures 09:33

At the end of this lecture students will have a working idea on how to build tables, represent data in the form of Tables and make the look and feel of the working area more attractive and presentable.

Creating Tables In Excel
04:16

Answer all the questions.

Creating Tables In Excel
3 questions

At the end of this lecture students will have a working knowledge on how to Customize and Format tables in Excel as per their requirement and also few additional features in Creation of Tables.

Formatting Tables In Excel
05:17

Answer all the questions.

Formatting Tables In Excel
2 questions
+
Page Set Up In Excel
7 Lectures 25:49

At the end of this lecture students will have a working knowledge on how to set up Page Margins in Excel.

Setting Up Page Margin In Excel
04:36

Answer all the questions.

Setting Up Page Margin In Excel
2 questions

At the end of this lecture students will have a working knowledge on how to set up Header and Footer in Excel.

Setting Up Header And Footer In Excel
04:39

Answer all the questions.

Setting Up Header And Footer In Excel
2 questions

At the end of this lecture students will have a working knowledge on how to use various Page Layout Themes in Excel.

Page Layout Theme In Excel
02:27

Answer all the questions.

Page Layout Theme In Excel
3 questions

At the end of this lecture students will have a working knowledge on how to set up Landscape or Portrait options in Excel Worksheet.

Page Orientation In Excel
03:09

Answer all the questions.

Page Orientation In Excel
3 questions

At the end of this lecture students will have a working knowledge on why and how to insert page breaks in Excel Worksheet.

Inserting page Breaks In Excel
03:47

Answer all the questions.

Inserting page Breaks In Excel
3 questions

At the end of this section students will be able to add Print Titles to their Excel Worksheets thereby enabling them to add or repeat headers automatically in different pages of their Worksheets while printing their Worksheets.

Print Titles In Excel
03:14

Answer all the questions.

Print Titles In Excel
3 questions

At the end of this tutorial students will be able to have a full working knowledge on how to use the Scaling Features or Options in order to change the size of their content while printing their Worksheet.

Scaling Option In Excel
03:57

Answer all the questions.

Scaling Option In Excel
3 questions
+
Freezing Panes In Excel
2 Lectures 05:29

At the end of this lecture students will be able to use the Freeze Pane option effectively in Excel to Freeze Rows and Columns in the Worksheet.

Freezing Rows And Columns In Excel
03:06

Answer all the questions.

Freezing Rows And Columns In Excel
2 questions

At the end of this lecture students will know how to Freeze Rows, Columns and Both Rows and Columns in Excel.

Freezing Top Row And First Column In Excel
02:23

Answer all the questions.

Freezing Top Row And First Column In Excel
2 questions
4 More Sections
About the Instructor
OrangeTree Global
3.6 Average rating
30 Reviews
2,870 Students
3 Courses
Analytics Trainer At OrangeTree Global.

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.