Microsoft Excel 2013 - Be the Excel master !!

A complete guide to learn the essential as well as the advanced features in Microsoft Excel 2013.
4.3 (806 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.
12,626 students enrolled
Free
Start Learning Now
  • Lectures 61
  • Length 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 7/2015 English

Course Description

A complete guide to learn the essentials as well as the advanced features in Microsoft Excel 2013. This course starts right from the basics of entering data into a cell to the advanced features of excel. Learn how to enter Formulas and functions, insert and edit different types of shapes, learn the different Data Validation options. With the new and improved look of Excel 2013, working has just become a lot easier. With new and advanced features like Flash Fill, Recommended charts and the new quick analysis tool, life just got way easier. 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?

  • Just open Microsoft Excel 2013 and leave the rest to us.

What am I going to get from this course?

  • Apply formulas and functions in a Worksheet without any trouble
  • Use various types of formatting options for shapes as well as text
  • Use pivot tables and make Pivot charts along witht the sliders
  • Use various types of Data Validation options

What is the target audience?

  • Students with minimal understanding of computers can also take this course as each concept is explained in detail.

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: Chapter 1
Introduction
04:21
Entering data into cell
04:38
Entering data into cells
2 questions
Alignment of entered data
05:26
Alignment of entered data
3 questions
Formatting the entered data
05:00
Formatting the text
4 questions
Autofill in depth
08:15
Section 2: Chapter 2
Inserting and editing shapes
06:16
Inserting shapes
2 questions
Cut copy and paste
05:55
Cut copy and paste
3 questions
Selection of data
06:05
Selection of data
3 questions
Inserting rows and columns
02:58
Inserting rows and columns
5 questions
Section 3: Chapter 3
Formulas
07:46
Formulas
2 questions
Functions
04:33
Functions
3 questions
Creating range names
03:40
Creating range names
4 questions
Using ranges in formulas
04:39
Using ranges in formula
2 questions
Basic functions
04:47
Basic function
4 questions
References
08:00
References
4 questions
If Function
04:47
if function
1 question
Sumif and Averageif
05:20
Sumif and averageif function
4 questions
General math functions
05:58
General math function
4 questions
More about dates
06:25
More on dates
1 question
Using formula across sheets
02:54
Using formula across sheet
1 question
Formula auditing
04:20
Formula auditing
3 questions
Section 4: Chapter 4
Conditional formatting
07:12
More on conditional formatting
04:42
Conditional formatting
3 questions
More on conditional formatting
1 question
Smart art
06:04
Smart Art
2 questions
Inserting tables
06:41
Inserting table
2 questions
Section 5: Chapter 5
Worksheet Themes
02:11
Printing
06:05
Printing
3 questions
More on printing
03:39
More on printing
3 questions
Headers and footers
03:22
Header and footer
4 questions
Inserting watermarks
02:04
Inserting watermark
1 question
Creating PDF
01:56
Creating PDF
2 questions
Freeze Pane
02:57
Section 6: Chapter 6
Introduction to charts
01:28
Inserting Column chart
07:04
Inserting column charts
2 questions
Customizing your chart
06:53
Line, area and sparline chart
06:35
Line area and sparkline charts
2 questions
Editing the data series of charts
03:59
Section 7: Chapter 7
Hiding Rows And Columns
04:29
Outline
05:05
Working with sheets
06:25
Working with sheets
3 questions
Find and select sort and filter
04:52
Sort
2 questions
Comment
05:11
Comments
4 questions
Password Protected
01:53
Password
1 question
Section 8: Chapter 8
Compound interest rate
03:10
Loan calculations
04:51
Loan calculation
3 questions
Present value,period and rate
03:37
Present value, period and rate
3 questions
Creating loan schedule
08:11
Using two way data table
03:06
Goal seek
02:42
Joining cells
04:57
Joining cells
2 questions
Section 9: Chapter 9
Splitting the cell data
03:20
Upper and lower case
03:42
Upper and lower case
3 questions
Data Validation
05:01

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?
Start Learning Now