Presentation (6).pptx. microsoft excel ppt

Microsoft Excel

1. Introduction to Excel By: Naval Mishra BBA 2nd

2. Ms Excel Excel definition: a software program created by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions. Excel analysis is ubiquitous around the world and used by businesses of all sizes to perform financial analysis.

3. Function of excel Math and Trigonometry Functions: Perform basic arithmetic operations, calculate trigonometric functions, and manipulate numerical data.
2. Statistical Functions: Analyze data using functions like AVERAGE, MEDIAN, and STANDARD DEVIATION to derive statistical measures.
3. Logical Functions: Evaluate logical conditions with functions such as IF, AND, OR, and NOT to make decisions based on specified criteria.
4. Text Functions: Manipulate and format text data using functions like CONCATENATE, LEFT, RIGHT, and SUBSTITUTE .

4. Filtering 1. Functionality
2. User Interface
3. Advanced Filtering
4. Sorting Options

5. Sorting Arranging Data**: Criteria-Based**: Ascending or Descending**: Multiple Levels** Quick sort

6. Formula The SUM Function =(Cell no. + cell no.) The AVERAGE Function =AVERAGE( cell no. : cell no ) The COUNT Function =COUNT(cell no: cell no ) The MIN Function =MIN( cell no: cell no )