Microsoft Excel - Functions

Name: Microsoft Excel - Functions
Rating: 4.3 (213 reviews)

Created bySawan Wani

Last updated 1/2024

English

English [Auto],

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 section • 37 lectures • 1h 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
Learn how to use the count function in Microsoft Excel to count numeric values in a range, with examples using C2:C6 and dynamic results when data changes.
POWER Function3:06
LEN Function2:47
TRIM Function1:54
Learn to use the trim function in Microsoft Excel to convert uneven spacing into equal spacing by applying =TRIM to a cell.
MOD Function2:35
CEILING Function3:14
FLOOR Function2:54
Excel's floor function rounds down a number to the nearest multiple of a specified divisor, unlike the ceiling function, revealing the greatest value divisible by that divisor.
DATE Function2:57
DAY Function1:45
TIME Function2:49
IF Function (Equal to)3:05
Learn to use the if function to test whether a player's status equals not out and return yes or no, then drag to apply to the rest.
IF Function (Greater Than or Less Than)3:40
Use the if function in Microsoft Excel to compare values to 500, returning yes for greater than 500 and, by swapping the operator, yes for less than 500.
SUBTOTAL Function2:29
MATCH Function2:19
Discover how to use the match function in Microsoft Excel to locate a value's position in a range, with examples like 38 at position 6 and 89 at position 9.
CHOOSE Function3:11
Explore how the choose function in Microsoft Excel selects a value from a list by position, with practical examples and guidance on typing cell references.
CONCATENATE Function2:51
MEDIAN Function1:54
REPLACE Function3:11
Explore how to use the replace function in Microsoft Excel to swap old text for new data using the start number, number of characters, and practical examples.
SUBSTITUTE Function3:34
Master the substitute function in Microsoft Excel to replace text within cells, see its case sensitivity with examples like lime to time, ball to hole, and bat to hat.
LEFT and RIGHT Function3:00
Learn how to use Excel's left and right functions to extract characters from text, with examples using Sam, Tom, and Jerry to return the first or last letters.
UPPER and LOWER Function2:10
Learn how to apply the upper and lower functions in Excel to convert names like Tom, Sam, and Jerry into uppercase or lowercase, and automatically fill results across rows.
DAY, MONTH and YEAR Function2:04
Learn to extract day, month, and year from a date time value in Excel using day, month, and year functions, and use the now function for the date and time.
HOUR,MINUTE and SECOND Function2:22
Extract hour, minute, and second from a current date-time in Excel using the HOUR, MINUTE, and SECOND functions, demonstrated with a B2 time value and the now function.
PROPER Function1:53
DATEDIF Function3:27
COUNTA Function1:46
Learn how to use the COUNTA function in Microsoft Excel to count non-empty cells in a range with =COUNTA(range); it does not count empty cells.
COUNTBLANK Function2:52
COUNTIF Function2:28
ROW Function1:38
Use the row function in Microsoft Excel to retrieve a cell's row number, as row(d5) returns 5 and updates when you drag across rows.
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