Microsoft Excel

A complete guide to learn the essential as well as the advanced features in Microsoft Excel 2010.
4.7 (11 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.
954 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 78
  • Length 6 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 10/2013 English

Course 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 !!!

What are the requirements?

  • Microsoft Excel 2010

What am I going to get from this course?

  • By the end of this course, you will be very fluent with excel.
  • Learn Shortcuts used in Excel to make your life easy

What is the target audience?

  • Students
  • Working Professionals

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: Introduction to Excel 2010
Introduction to excel
Preview
00:42
Exercise files
Article
Section 2: Data Entry
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
Autofill in depth
Preview
08:13
Section 3: Shapes & data selection
Inserting and editing shapes
06:18
Cut Copy and paste
05:52
Selection of data
Preview
06:03
Inserting rows and columns
02:52
Section 4: Formula's and Function's
Formulas
08:03
Functions
Preview
04:33
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
Section 5: Conditional Formatting & Cipart
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
Section 6: Themes & Printing
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
Section 7: Charts
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
Section 8: Managing Rows and columns
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
Section 9: Data Tools
Compound interest rate
03:10
Loan calculations
Preview
04:57
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
Section 10: Data Validation
Joining cells
04:58
Splitting the cell data
03:21
Uppercase and lowercase
04:10
Vlookup function
Preview
03:30
Hlookup function
03:17
Data validation
05:48
Section 11: Pivot tables & charts
Pivot tables
05:34
More on pivot tables
07:09
Formatting pivot tables
04:40
Pivot charts
02:13
From web
04:23
Section 12: Miscellaneous
Sumif and sumifs function
03:38
Countif and countifs function
02:45
Opening a file in Excel 2007
01:55
Linking workbooks
05:40
Opening a file that contains links
03:02
Consolidating data
04:06
Section 13: Conclusion
Conclusion
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

ioniya ., 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.

Ready to start learning?
Take This Course