Description
Microsoft Excel Pivot Tables With Formulas & Functions Course. This course comprehensively teaches you how to use Pivot Tables in Microsoft Excel, along with formulas and functions, to analyze and manipulate data effectively. This course is suitable for users who have a basic understanding of Excel and want to improve their data analysis skills. Course Topics:
- Session 1: Introduction to Microsoft Excel
- Session 2: Intermediate Excel Skills
- Session 3: Understanding Pivot Tables
- Session 4: Advanced Pivot Table Techniques
- Session 5: Real-World Applications
What you will learn
- Introducing the Excel interface and features
- Introducing formulas and functions
- Data entry and formatting techniques
- Data validation and conditional formatting
- Working with multiple worksheets and workbooks
- Creating PivotTables from a Data Set
- Customizing PivotTables
- Grouping and summarizing data in PivotTables
- Using Slicers for Interactive Filtering
- Creating Pivot Charts from PivotTables
- Tips and tricks for optimizing PivotTable performance
Who is this course suitable for?
- Anyone interested in becoming a professional Excel user with PivotTables and charts.
- Administrative staff
- Data analysts
- Accountants
- Students
- Anyone who uses data in their work
Microsoft Excel Pivot Tables With Formulas & Functions Course Details
- Publisher: Udemy
- Instructor: Click Learning
- Training level: Beginner to advanced
- Training duration: 2 hours and 5 minutes
- Number of lessons: 19
Course topics
Course prerequisites
- No experience required.
- This course is compatible with any version of Excel
Course images
Sample course video
Video display
00:00
06:04
Installation Guide
After Extract, view with your favorite player.
Subtitles: None
Quality: 720p
File size
1.2 GB
Download link
