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:
- The first session: Getting to know Microsoft Excel
- Second session: Intermediate Excel skills
- The third session: Understanding pivot tables
- The fourth session: 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
- Work with multiple worksheets and folders
- Create PivotTables from a dataset
- Customizing PivotTables
- Grouping and summarizing data in PivotTables
- Use Slicers for interactive filtering
- Create Pivot Charts from PivotTables
- Tips and tricks to optimize PivotTable performance
Who is this course suitable for?
- Anyone interested in becoming an Excel pro with PivotTables and Charts.
- Administrative staff
- Data analysts
- accountants
- Students
- Anyone who uses data in their work
Course specifications Microsoft Excel Pivot Tables With Formulas & Functions
- Publisher: Udemy
- Instructor: Click Learning
- Training level: beginner to advanced
- Training duration: 2 hours and 5 minutes
- Number of courses: 19
Course headings
Course prerequisites
- No experience needed.
- This course is compatible with any version of Excel
Course images
Sample video of the course
Installation guide
After Extract, view with your favorite Player.
Subtitle: None
Quality: 720p
download link
File(s) password: www.downloadly.ir
Size
1.2 GB