What You'll Learn
- 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
Requirements
- Basic knowledge of Microsoft Excel is beneficial but not required
Who This Course is For
- Anyone who wants to analyze data faster and more accurately
- Students preparing for data-driven careers
- Beginners wanting to learn Excel data analysis
- Professionals working with reports, finance, accounting, HR, sales, or operations
Your Instructor
Logic Labs
Instructor at Udemy | Programming | Data Analytics | AI Tool
4.5 Instructor Rating
9 Reviews
5,097 Students
25 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 2 days
Excel Formulas and Functions: Tips, Tricks, and Shortcuts
Master Excel Formulas and Functions with Essential Tips, Tricks, and Shortcuts to Boost Your Produc…
Free 100% Off
Today
Expires in 2 days
Microsoft Excel: Master Data Analysis, Cleaning & Dashboards
Learn to clean, analyze, and visualize data in Excel to create stunning, interactive dashboards wit…
Free 100% Off
Yesterday
Expires in 1 day
How to Become a Thought Leader in Your Industry
Leadership, The Confidence-Competence Loop, Overcoming Imposter Syndrome, The Growth Mindset for Le…
Free 100% Off
Yesterday
Expires in 17 hours
Microsoft Excel for Beginners: Excel for Everyday Use
Learn Essential Excel Skills to Organize Data, Create Reports, and Simplify Everyday Tasks with Con…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.