Microsoft Excel 2013 - Be the Excel master !!
4.3 (966 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12,777 students enrolled

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 (966 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12,777 students enrolled
Created by Parallel Learning
Last updated 10/2015
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
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 this course is for:
  • Students with minimal understanding of computers can also take this course as each concept is explained in detail.
Course content
Expand all 61 lectures 04:45:56
+ 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