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!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024