Microsoft Excel – Functions

Microsoft Excel – Functions, available at Free, has an average rating of 4.59, with 37 lectures, based on 161 reviews, and has 3838 subscribers.

You will learn about To use Microsoft Excel To handle high specific data To use various functions of excel Understand the whole Microsoft Excel This course is ideal for individuals who are Beginners It is particularly useful for Beginners.

Enroll now: Microsoft Excel – Functions

Summary

Title: Microsoft Excel – Functions

Price: Free

Average Rating: 4.59

Number of Lectures: 37

Number of Published Lectures: 37

Number of Curriculum Items: 37

Number of Published Curriculum Objects: 37

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

Beginners

Target Audiences

Beginners

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.

Course Curriculum

Chapter 1: Microsoft Excel

Lecture 1: Writing a Data in Excel

Lecture 2: ABS Function

Lecture 3: SUM Function

Lecture 4: Addition and Substraction of Values

Lecture 5: Multiplication and Division of Values

Lecture 6: Average Function

Lecture 7: MIN and MAX Function

Lecture 8: COUNT Function

Lecture 9: POWER Function

Lecture 10: LEN Function

Lecture 11: TRIM Function

Lecture 12: MOD Function

Lecture 13: CEILING Function

Lecture 14: FLOOR Function

Lecture 15: DATE Function

Lecture 16: DAY Function

Lecture 17: TIME Function

Lecture 18: IF Function (Equal to)

Lecture 19: IF Function (Greater Than or Less Than)

Lecture 20: SUBTOTAL Function

Lecture 21: MATCH Function

Lecture 22: CHOOSE Function

Lecture 23: CONCATENATE Function

Lecture 24: MEDIAN Function

Lecture 25: REPLACE Function

Lecture 26: SUBSTITUTE Function

Lecture 27: LEFT and RIGHT Function

Lecture 28: UPPER and LOWER Function

Lecture 29: DAY, MONTH and YEAR Function

Lecture 30: HOUR,MINUTE and SECOND Function

Lecture 31: PROPER Function

Lecture 32: DATEDIF Function

Lecture 33: COUNTA Function

Lecture 34: COUNTBLANK Function

Lecture 35: COUNTIF Function

Lecture 36: ROW Function

Lecture 37: COLUMN Function

Instructors

Sawan Wani
Microsoft Excel Tutorials

Rating Distribution

1 stars: 6 votes
2 stars: 2 votes
3 stars: 28 votes
4 stars: 57 votes
5 stars: 68 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu