AECS Layout, Marathahalli, Bangalore, India - 560037.
Details verified of Mythili S.✕
Identity
Education
Know how UrbanPro verifies Tutor details
Identity is verified based on matching the details uploaded by the Tutor with government databases.
Tamil Mother Tongue (Native)
Hindi Proficient
English Proficient
Bengali Proficient
St.Thomas' College of Engineering & Technology 2007
Bachelor of Technology (B.Tech.)
AECS Layout, Marathahalli, Bangalore, India - 560037
ID Verified
Phone Verified
Email Verified
Report this Profile
Is this listing inaccurate or duplicate? Any other problem?
Please tell us about the problem and we will fix it.
Class Location
Online Classes (Video Call via UrbanPro LIVE)
Student's Home
Tutor's Home
Years of Experience in Microsoft Excel Training classes
1
Teaches following Excel features
Advanced Excel, Basic Excel
1. What Excel features do you teach?
Advanced Excel and Basic Excel
2. Which classes do you teach?
I teach Microsoft Excel Training Class.
3. Do you provide a demo class?
Yes, I provide a free demo class.
4. How many years of experience do you have?
I have been teaching for 1 year.
Answered on 28/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
Answered on 16/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
PivotTables are a powerful tool in Excel that can help you analyze and summarize large amounts of data. Here are some common scenarios where PivotTables are useful:
Summarizing data: PivotTables can help you summarize large amounts of data into a more manageable format. For example, you can use a PivotTable to summarize sales data by region, product, or time period.
Comparing data: PivotTables can help you compare data from different sources or time periods. For example, you can use a PivotTable to compare sales data from this year to last year.
Identifying trends: PivotTables can help you identify trends in your data. For example, you can use a PivotTable to see which products are selling the most, or which regions are growing the fastest.
Filtering data: PivotTables can help you filter your data to focus on specific subsets. For example, you can use a PivotTable to filter sales data by product category, or to focus on a specific time period.
Calculating percentages: PivotTables can help you calculate percentages and other summary statistics. For example, you can use a PivotTable to calculate the percentage of sales by region or product.
Creating charts: PivotTables can help you create charts and other visualizations to help you better understand your data. For example, you can use a PivotTable to create a chart that shows sales data by region.
Answered on 16/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
To Group data in a Pivot Table, right click a value and Select Group. Then in Grouping dialog box select Starting at and Ending at checkboxes, and edit the values as per the requirements. Then Under By, select a time period. For numerical fields, enter a number that specifies the interval for each group. Select OK to confirm the grouping.
Class Location
Online Classes (Video Call via UrbanPro LIVE)
Student's Home
Tutor's Home
Years of Experience in Microsoft Excel Training classes
1
Teaches following Excel features
Advanced Excel, Basic Excel
Answered on 28/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
Answered on 16/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
PivotTables are a powerful tool in Excel that can help you analyze and summarize large amounts of data. Here are some common scenarios where PivotTables are useful:
Summarizing data: PivotTables can help you summarize large amounts of data into a more manageable format. For example, you can use a PivotTable to summarize sales data by region, product, or time period.
Comparing data: PivotTables can help you compare data from different sources or time periods. For example, you can use a PivotTable to compare sales data from this year to last year.
Identifying trends: PivotTables can help you identify trends in your data. For example, you can use a PivotTable to see which products are selling the most, or which regions are growing the fastest.
Filtering data: PivotTables can help you filter your data to focus on specific subsets. For example, you can use a PivotTable to filter sales data by product category, or to focus on a specific time period.
Calculating percentages: PivotTables can help you calculate percentages and other summary statistics. For example, you can use a PivotTable to calculate the percentage of sales by region or product.
Creating charts: PivotTables can help you create charts and other visualizations to help you better understand your data. For example, you can use a PivotTable to create a chart that shows sales data by region.
Answered on 16/11/2023 Learn IT Courses/MS Office Software Training/Microsoft Excel Training
To Group data in a Pivot Table, right click a value and Select Group. Then in Grouping dialog box select Starting at and Ending at checkboxes, and edit the values as per the requirements. Then Under By, select a time period. For numerical fields, enter a number that specifies the interval for each group. Select OK to confirm the grouping.
Want to learn from Mythili S.?
Share this Profile
Also have a look at
Reply to 's review
Enter your reply*
Your reply has been successfully submitted.
Certified
The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.
