msexcel-itsusesfunctions-220405164320.pptx

Pivot tables are an essential tool for anyone looking to analyze and summarize large sets of data efficiently. They allow users to transform raw data into meaningful insights through a simple, interactive interface. This presentation will introduce attendees to the concept of pivot tables, explaining their purpose and how they can be utilized in various scenarios. Starting with a definition, pivot tables serve as a data summarization tool available in spreadsheet programs like Microsoft Excel and Google Sheets. They enable users to organize and analyze complex data by rearranging rows and columns, making it easier to spot trends, patterns, and relationships.

We’ll kick off the presentation with a hands-on demonstration, guiding participants through the process of creating a pivot table from scratch. This step-by-step approach will cover essential components, including data sources, the arrangement of rows and columns, and the selection of values and filters. By engaging in this practical exercise, attendees will gain firsthand experience in manipulating data, understanding how to turn disorganized information into structured insights.

1. Microsoft Excel Presented by :- Manvik Pathania

2. WHAT IS MICROSOFT EXCEL ? Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data. Microsoft Excel provides multiple features to perform various operations like calculations, pivot tables, graph tools, macro programming, etc. A Excel spreadsheet can be understood as a collection of columns and rows that form a table. The point where a column and a row meet is called a cell. The address of a cell is given by the letter representing the column and the number representing a row.

3. USES OF MICROSOFT EXCEL Education Use of table styles, shapes, charts, data tools, and formulas in the classrooms. And it provides a visual representation of data. Business The business can use MS Excel to perform goal setting, budgeting process, and planning, etc. also Financial services and financial accounting are the areas of finance that rely on and benefit from Excel spreadsheets the most. Goal Setting and Planning MS Excel provides a wide range of templates which can be used for organizational as well as personal goal setting and planning.

4. Business Owners Excel allows Entrepreneur to store any data from accounts, to merchandise, to phone numbers and view and track it in an organized manner. Housewives The Housewives can manage their daily house expenses which can track the spending habit of each member of the house . Data Analysis And Data Science Excel Offers The data Analysis function which is quite handy for the data analyst to Understand the data.

5. Daily Progress Report Excel is also helpful in creating a daily progress report, Especially in project- based companies whether the clients need a weekly, monthly, report from the company . Career Development The task such as learning management ,time management, work & life management and goal focused habits are important which can be efficiently practiced on MS-Excel . Data Security All the files of MS- Excel can be kept password protected through visual basic programming or directly within the excel file.

6. WHAT IS FUNCTION IN EXCEL ? A function is a predefined formula that performs calculations using specific values in a particular order. Function is used for quick tasks like finding the summation of a range of numbers, counting the number of items in a given range, etc. Let's look at some of the 5 most commonly statistical functions :

7. Steps to Open the Function in Excel You can simply enter the desired formula in the required cell to attain a return value on the argument. You can manually open the formula dialogue box in the spreadsheet and enter the values to attain a return value. To open the from Function library - go to the Formula →More Functions →Statistical → then choose the desired formula we want. Also you can find some formulas in bar under sheet tab bar

8. SUM FUNCTION SUM : This function adds all of the values of the cells in the argument . FORMULA : =SUM(number1,[number2],…..) Sum will be

9. Average will be AVERAGE FUNCTION AVERAGE : This function determines the average of the value included in the argument FORMULA : =AVERAGE(number1,[number2],…..)

10. MAX FUNCTION FORMULA : =MAX(number1,[number2],…..) MAX : This function determines the highest cell value included in the argument Maximum will be

11. MIN FUNCTION FORMULA : =MIN(number1,[number2],…..) MIN : This function determines the lowest cell value included in the argument Minimum will be

12. COUNT FUNCTION FORMULA : =COUNT(value1,[value2],…..) COUNT : This function counts the number of cell with numerical data in the argument. This function is useful for quickly counting items in cell range Count will be