Assignment no.1 Pivot Table

Pivot tables are a powerful tool in data analysis. Here are some key things you can do with pivot tables:


*Benefits of Pivot Tables*

1. *Summarize large datasets*: Pivot tables help you summarize and analyze large datasets by grouping and aggregating data.

2. *Analyze data from multiple angles*: Pivot tables allow you to rotate and analyze data from different perspectives, helping you identify trends and patterns.

3. *Create custom reports*: Pivot tables enable you to create custom reports by selecting specific fields and aggregations.





*Common Pivot Table Operations*

1. *Create a pivot table*: Select a cell range, go to the "Insert" tab, and click "PivotTable."

2. *Add fields*: Drag and drop fields into the "Rows," "Columns," and "Values" areas.

3. *Apply filters*: Use the "Filters" area to narrow down the data.

4. *Group data*: Right-click on a field and select "Group" to group data by a specific field.


*Tips and Tricks*

1. *Use multiple fields*: Combine multiple fields to create a unique identifier.

2. *Use calculated fields*: Create custom calculations using the "Calculated Field" feature.

3. *Use conditional formatting*: Highlight important trends and patterns using conditional formatting.

Comments

Post a Comment

Popular posts from this blog

Assignment no.7 Use of vlook formula in exvel

Image
  VLOOKUP VLOOKUP works by searching down the first column of a table to find a match. Once it locates that match, it retrieves data  from the specified column of the same row.  FORMULA: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])                                       Step 1:LOOKUP VALUE                             The lookup value S elect the cell where you want the result to be and start the VLOOKUP formula by typing: STEP 2 : Table array   Now Excel asks you to write the second argument into the VLOOKUP function: the  table_array . This range must contain both the column you’re looking in and the column you want to return something from. Step 3: Column index number The third argument of the VLOOKUP syntax is the  col_index_num  (column index number). The colum...
Read more

Assignment no.4 Filtering in ms excel

Image
  Filtering in MS Excel helps you narrow down your data to show only the information you need. Here's how to use it: *Types of Filters* 1. *AutoFilter*: Automatically filters data based on the column headers. 2. *Advanced Filter*: Allows you to filter data using complex criteria. 3. *Custom Filter*: Enables you to filter data using custom criteria. * How to Apply Filters* 1. Select the range of cells you want to filter. 2. Go to the "Data" tab. 3. Click "Filter" in the "Data Tools" group. 4. Select the column header you want to filter. 5. Choose the filter type (e.g., "Number Filters" or "Text Filters"). 6. Select the filter criteria (e.g., "Greater Than" or "Contains"). 7. Click "OK" to apply the filter . *Filter Options* 1. *Number Filters*: Filter numbers based on criteria like "Greater Than," "Less Than," or "Between." 2. *Text Filters*: Filter text based on criteria li...
Read more

Assignment no.3 Data validation in excel

Image
  Data validation in Excel helps ensure accuracy and consistency in your data. Here's how to use it: *Types of Data Validation* 1. *Whole Number*: Restrict input to whole numbers within a specified range. 2. *Decimal*: Restrict input to decimal numbers within a specified range. 3. *Date*: Restrict input to dates within a specified range. 4. *Time*: Restrict input to times within a specified range. 5. *Text Length*: Restrict input to a specific text length. 6. *List*: Restrict input to a list of predefined values. 7. *Custom*: Create a custom formula to validate input. *How to Apply Data Validation* 1. Select the cell(s) you want to validate. 2. Go to the "Data" tab. 3. Click "Data Validation" in the "Data Tools" group. 4. Choose the validation type from the dropdown menu. 5. Set the validation criteria (e.g., minimum and maximum values). 6. Click "OK" to apply the validation. *Additional Options* 1. *Input Message*: Display a message when a u...
Read more