Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel - Functions
Rating: 4.3 out of 5(212 ratings)
4,566 students

Microsoft Excel - Functions

Microsoft Excel - Functions
Created bySawan Wani
Last updated 1/2024
English

What you'll learn

  • To use Microsoft Excel
  • To handle high specific data
  • To use various functions of excel
  • Understand the whole Microsoft Excel

Course content

1 section37 lectures1h 45m total length
  • Writing a Data in Excel2:44

    How to Write a Data in Excel

  • ABS Function3:19
  • SUM Function5:02
  • Addition and Substraction of Values5:22
  • Multiplication and Division of Values4:31
  • Average Function3:59
  • MIN and MAX Function2:32
  • COUNT Function2:28
  • POWER Function3:06
  • LEN Function2:47
  • TRIM Function1:54
  • MOD Function2:35
  • CEILING Function3:14
  • FLOOR Function2:54
  • DATE Function2:57
  • DAY Function1:45
  • TIME Function2:49
  • IF Function (Equal to)3:05
  • IF Function (Greater Than or Less Than)3:40
  • SUBTOTAL Function2:29
  • MATCH Function2:19
  • CHOOSE Function3:11
  • CONCATENATE Function2:51
  • MEDIAN Function1:54
  • REPLACE Function3:11
  • SUBSTITUTE Function3:34
  • LEFT and RIGHT Function3:00
  • UPPER and LOWER Function2:10
  • DAY, MONTH and YEAR Function2:04
  • HOUR,MINUTE and SECOND Function2:22
  • PROPER Function1:53
  • DATEDIF Function3:27
  • COUNTA Function1:46
  • COUNTBLANK Function2:52
  • COUNTIF Function2:28
  • ROW Function1:38
  • COLUMN Function1:56

Requirements

  • Office
  • Microsoft Excel

Description

Microsoft Excel is a basic application used for data analysis. It can handle large amount of data.The user of this course will be able to find the data handling very easy which in order will improve their hands on pracrtice in mkicrosoft excel. The course intends to give the information about every aspect of microsoft excel in micrsoft office. The excel is a large tool for statistical data analysis and data handlong. Engineers, Commerce students have more use to this feature of microsoft office. Microsoft office has various tools like word, excel, powerpoint, access, outlook, one note etc.

Microsoft excel also provides the tabular form of data analysis and arrange the data in any format as per the requirement of the user. The new version of representation of graphical data like line charts, pie charts and its shortcut functions are very useful to handle large data in small amount of time. Excel also involves the use of macros which can be converted into software and then it can be used for data collection on a large scale. The pivot table has also a very useful aspect in excel.Overall, excel acts as an universal tool for data analysis of any type.

Who this course is for:

  • Beginners