Microsoft Excel
4.7 (13 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.
959 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel to your Wishlist.

Add to Wishlist

Microsoft Excel

A complete guide to learn the essential as well as the advanced features in Microsoft Excel 2010.
4.7 (13 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.
959 students enrolled
Created by ioniya .
Last updated 11/2013
English
Current price: $10 Original price: $20 Discount: 50% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 2 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • By the end of this course, you will be very fluent with excel.
  • Learn Shortcuts used in Excel to make your life easy
View Curriculum
Requirements
  • Microsoft Excel 2010
Description

A complete guide to learn the essentials as well as the advanced features in Microsoft Excel 2010. This course starts right from the basics of entering data into a cell to the advanced features of excel. Learning is made easier with the exercise files provided along with each of the tutorials. Take this course and see yourself work more efficiently than ever !!!

Who is the target audience?
  • Students
  • Working Professionals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
78 Lectures
05:55:34
+
Introduction to Excel 2010
2 Lectures 00:48

Exercise files
00:06
+
Data Entry
6 Lectures 30:53
Layout of excel
04:27

Entering data into cell
04:37

Understanding the backstage view
03:12

Alignment of entered data
05:25

Formatting the entered data
04:59

+
Shapes & data selection
4 Lectures 21:05
Inserting and editing shapes
06:18

Cut Copy and paste
05:52


Inserting rows and columns
02:52
+
Formula's and Function's
13 Lectures 01:12:06
Formulas
08:03


Creating range names
03:37

Using range names
04:45

Basic functions
04:47

References
07:58

If function
04:45

Sumif and average if
05:18

General math functions
05:57

Dates
08:42

More about dates
06:23

Using formula across sheets
02:47

Formula Auditing
04:31
+
Conditional Formatting & Cipart
6 Lectures 35:21
Conditional formatting
07:10

More on conditional formatting
04:49

Calculating your age
03:52

Pictures and clipart
06:34

Smartart
06:14

Inserting tables
06:42
+
Themes & Printing
9 Lectures 27:38
Worksheet theme
01:59

Applying theme
04:18

Creating your own template
02:19

printing
06:16

More on printing
03:39

Headers and footers
03:23

Inserting watermarks
02:07

Creating PDF
01:14

Freezing panes
02:23
+
Charts
6 Lectures 30:52
Introduction to charts
01:25

Inserting column bars
04:18

Customizing chart
07:01

Pie charts
08:15

Sparkline
06:27

Editing the data series
03:26
+
Managing Rows and columns
6 Lectures 31:00
Hiding rows and columns
03:35

Outlines
05:04

Working with sheets
06:29

Inserting hyperlink
05:41

Find select and sort filter
04:54

Comments
05:17
+
Data Tools
8 Lectures 35:07
Compound interest rate
03:10


Present value, period and rate
03:47

Creating loan schedule
08:21

Using data tables
03:19

Using two way data tables
03:07

Goal seek
02:39

Scenario manager
05:47
+
Data Validation
6 Lectures 25:04
Joining cells
04:58

Splitting the cell data
03:21

Uppercase and lowercase
04:10


Hlookup function
03:17

Data validation
05:48
3 More Sections
About the Instructor
ioniya .
4.2 Average rating
2,767 Reviews
28,701 Students
12 Courses
When you know better, You Do better !!

Ioniya is a video publishing company based in india. Ioniya has created a platform which is trying to bridge the gap between the students and the industries. Authors who have wide knowledge in their fields, help us design our courses which are very practical. We, are an organisation moulding software learning skills to professionals and students bridging the gap between industry specific needs and efficient working. We build the digital literates. We provide an effective method through simulation, a teaching which is very effective and consumes very little time. Ioniya builds an ecosystem in which the learners have a knowledgeable experience in learning from us.

We started with video tutorials for Microsoft office and Engineering softwares like Autocad. We are working on tutorials for many other softwares like Tally, Catia, Weblogic and languages like java,.net etc. With the help of a platform like Udemy, we hope to spread this ocean of knowledge throughout the world.