Microsoft Excel 2013 - Be the Excel master !!
4.5 (881 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,722 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2013 - Be the Excel master !! to your Wishlist.

Add to Wishlist

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.5 (881 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,722 students enrolled
Created by ioniya .
Last updated 10/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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 with the sliders
  • Use various types of Data Validation options
View Curriculum
Requirements
  • Just open Microsoft Excel 2013 and leave the rest to us.
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 !!!

Who is the target audience?
  • Students with minimal understanding of computers can also take this course as each concept is explained in detail.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
61 Lectures
04:45:57
+
Chapter 1
5 Lectures 27:40


Entering data into cells
2 questions


Alignment of entered data
3 questions

Formatting the entered data
05:00

Formatting the text
4 questions

Autofill in depth
08:15
+
Chapter 2
4 Lectures 21:14
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
+
Chapter 3
12 Lectures 01:03:09
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
+
Chapter 4
4 Lectures 24:39
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
+
Chapter 5
7 Lectures 22:14
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
+
Chapter 6
5 Lectures 25:59
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
+
Chapter 7
6 Lectures 27:55
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
+
Chapter 8
7 Lectures 30:34
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
+
Chapter 9
6 Lectures 20:45
Splitting the cell data
03:20

Upper and lower case
03:42

Upper and lower case
3 questions

Data Validation
05:01

Vlookup functions
03:25

Vlookup function
2 questions

Hlookup Functions
03:04

Pivot Charts
02:13
+
Chapter 10
5 Lectures 21:48
More on pivot table
06:42

Sumif and sumifs function
03:40

Countif and countifs function
02:43

Linking workbooks
05:38

Opening the file that contains links
03:05
About the Instructor
ioniya .
4.2 Average rating
2,770 Reviews
28,723 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.