Hands-On Microsoft Excel Pivot Table Training for Effective Data Analysis
Sub Category
- Microsoft
{inAds}
Objectives
- Importing data from a Text File, Website and Access
- Data Cleaning Techniques for Data Analyst
- Creating and Manipulating a PivotTable
- Combine Data from Multiple Sheets in a Single Sheet
- Formatting Error Values and Empty Cells
- PivotTable Styles
- Custom Number Formatting
- Summarizing Values
- Advanced Sorting and Filtering
- Inserting and formatting Slicers
- Connecting Slicers to Multiple PivotTables
- Use Pivot Tables and Slicers on Protected Worksheets
- Creating a Calculated Field and Item
- PivotTable Calculated Items and Solve Order
- GETPIVOTDATA
- Creating a Pivot Chart
- Dynamic Chart Titles
- Dynamic Sparklines with PivotTable
- Highlight Pivot Table Cells With Conditional Formatting
- Conditional Formatting and Slicers
- Creating a Pivot table Dashboard
- Advanced Pivot Table Techniques
Pre Requisites
- Basic knowledge of Microsoft Excel is beneficial but not required
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)