- Microsoft Excel – Functions
- Free tutorial
- Rating: 4.0 out of 54.0 (98 ratings)
- 2,230 students
- 1hr 37min of on-demand video
- Created by Sawan Wani
- 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
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
Show less
Course content
1 section • 33 lectures • 1h 36m total length
Microsoft Excel33 lectures • 1hr 37min
- Writing a Data in Excel02:44
- ABS Function03:19
- SUM Function05:02
- Addition and Substraction of Values05:22
- Multiplication and Division of Values04:31
- Average Function03:59
- MIN and MAX Function02:32
- COUNT Function02:28
- POWER Function03:06
- LEN Function02:47
- TRIM Function01:54
- MOD Function02:35
- CEILING Function03:14
- FLOOR Function02:54
- DATE Function02:57
- DAY Function01:45
- TIME Function02:49
- IF Function (Equal to)03:05
- IF Function (Greater Than or Less Than)03:40
- SUBTOTAL Function02:29
- MATCH Function02:19
- CHOOSE Function03:11
- CONCATENATE Function02:51
- MEDIAN Function01:54
- REPLACE Function03:11
- SUBSTITUTE Function03:34
- LEFT and RIGHT Function03:00
- UPPER and LOWER Function02:10
- DAY, MONTH and YEAR Function02:04
- HOUR,MINUTE and SECOND Function02:22
- PROPER Function01:53
- DATEDIF Function03:27
- COUNTA Function01:46
- Certification6 questions