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.
285 students enrolled
$30
Take This Course
  • Lectures 78
  • Contents Video: 6.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2015 English

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.

What are the 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.

What am I going to get from this course?

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

What 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.

What you get with 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.

Curriculum

Section 1: Getting Started With Excel
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.

5 questions

There are 5 questions. Please answer all of them.

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.

Inserting Data In Worksheets
3 questions
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.

Editing And Removing Data In Worksheets
3 questions
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 short-cut.

6 questions

Answer all the questions.

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.

4 questions

Answer all the questions.

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.

3 questions

Answer all the questions.

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.

2 questions

Answer all the questions.

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.

3 questions

Answer all questions.

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.

2 questions

Answer all the questions.

04:02

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
3 questions
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.

Protecting A Worksheet
4 questions
Section 2: Formatting In Excel
04:49

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

4 questions

Answer all questions

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.

Changing Fonts And Font Color In Excel
4 questions
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.

3 questions

Answer all the questions.

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.

3 questions

Answer all questions.

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.

3 questions

Answer all questions.

05:25

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

2 questions

Answer all the questions

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.

2 questions

Answer all the questions.

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.

3 questions

Answer all the questions.

03:15

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

2 questions

Answer all questions.

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.

2 questions

Answer all the questions.

Section 3: Conditional Formatting
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.

4 questions

Answer all the questions.

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.

2 questions

Answer all the questions.

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.

2 questions

Answer all questions

03:40

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

1 question

Answer all the questions.

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.

2 questions

Answer all the questions.

Section 4: Worksheet Formatting
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.

3 questions

Answer all the questions.

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.

3 questions

Answer all the questions.

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.

3 questions

Answer all the questions.

Section 5: Working With Functions And Formulas
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.

2 questions

Answer all the questions.

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.

4 questions

Answer all the questions.

14:13

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

3 questions

Answer all the questions

07:28

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

3 questions

Answer all the questions.

08:11

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

3 questions

Answer all the questions.

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.

2 questions

Answer all the questions.

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.

2 questions

Answer all the questions.

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.

2 questions

Answer all the questions.

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.

3 questions

Answer all the questions.

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.

4 questions

Answer all the questions.

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.

3 questions

Answe all the questions.

Section 6: Sorting And Filtering
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.

3 questions

Answer all the questions.

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.

3 questions

Answer all the questions.

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.

2 questions

Answer all the questions.

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.

3 questions

Answer all the questions.

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.

3 questions

Answer all the questions.

Section 7: Creating Graphs And Charts
05:35

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

3 questions

Answer all the questions.

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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

OrangeTree Global, 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.

Ready to start learning?
Take This Course