- 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
- IF Function (Equal to)
- IF Function (Greater Than or Less Than)
- SUBTOTAL Function
- MATCH Function
- CHOOSE Function
- CONCATENATE Function
- MEDIAN Function
- REPLACE Function
- SUBSTITUTE Function
- LEFT and RIGHT Function
- UPPER and LOWER Function
- DAY, MONTH and YEAR Function
- HOUR,MINUTE and SECOND Function
- PROPER Function
- DATEDIF Function
- COUNTA Function
- COUNTBLANK Function
- COUNTIF Function
- ROW Function
- COLUMN Function
What you'll 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.
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.
Other Courses
Flutter UI & GetX - Workout Fitness App
Create Workout Fitness App with Flutter UI and GetX State Management
NGRX angular nativescript
Creating mobile app with NGRX angular nativescript. Working with State in angular application within NGRX
Instructional Design for Online and Blended Courses
Build Online Courses Using Best Practices from Free Templates We Provide
How to Trade in Stock market
Risk return management skills, trading plan, live trading, trading strategies included.
The 3D Printer Hardware Guide
Learn how a 3D printer works by assembling hardware parts
About the instructors
- 4.25 Calificación
- 3348 Estudiantes
- 2 Cursos
Sawan Wani
Microsoft Excel Tutorials
The Instructor is a well known microsoft excel user who handles well known data with analysis skills and statistical data analysis which is important in today;s world of data handling. However, the course starts from basics to expert mode.This course is applicable to every human being who is using or handling any type of data and has to do analysis on it.
Student feedback
Course Rating
Reviews
my experience in taking this course is exciting and educational
Was very insightful
Learning Function Excel
Enjoyed the course. Would have liked some practice materials.