Microsoft Excel

What you will learn

To use Microsoft Excel

To handle high specific data

To use various functions of excel

Understand the whole 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.


Get Instant Notification of New Courses on our Telegram channel.


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.

English
language

Content

Microsoft Excel

Writing a Data in Excel
ABS Function
SUM Function
Addition and Substraction of Values
Multiplication and Division of Values
Average Function
MIN and MAX Function
COUNT Function
POWER Function
LEN Function
TRIM Function
MOD Function
CEILING Function
FLOOR Function
DATE Function
DAY Function
TIME Function
Certification