Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel - Data Analysis with Excel Pivot Tables
Course Introduction ( مقدمة الدورة )
Download the Presentation ( العرض التقديمي )
Introduction to Pivot Tables ( مقدمة عن الجداول ا لمحورية )
Download Excel Files ( تحميل ملف الاكسل للتطبيق العملي )
What Is PivotTables and Why (2:30)
Preparing Data ( تجهيز البيانات ) (5:03)
Inserting Pivot Table (6:04)
PivotTable Fields List (12:53)
Showing, Sorting, Moving and Resizing Field List (8:59)
DEFER LAYOUT UPDATE (2:55)
Pivot Table Cache (11:12)
Designing and Formatting Excel Pivot Tables ( تنسيق الجداول المحورية )
Analyze & Design Tabs (4:33)
Analyze Tab - Action Group (11:50)
Analyze Tab - Data Group (23:26)
Number Formatting (3:20)
Formating empty cells and Errors (4:06)
Design Tab - Layout (18:22)
Design Tab - Pivot Table Styles Group and Style options (12:11)
Renaming Columns (6:16)
Conditional Formatting (15:39)
Sorting, Filtering and Grouping
Sorting Data (17:09)
Filtering Data - MANUAL Filters (11:47)
Filtering Data - Label Filters (11:15)
Filtering Data - Label Filters (wildcard) (4:04)
Filtering Data - Values Filters (13:00)
Enabling Multi Filters (6:22)
Grouping Data (7:11)
Grouping Data - Dates (5:45)
Slicers (12:00)
Slicers - Report Connections (6:03)
Time Lines (5:59)
Show report filter pages option (4:19)
Summarize Value By
Summarize Value By option (5:04)
Show Values As Options (3:57)
Show Values As: % of Column OR % of Row (11:40)
Show Values As: % of Parent (Row, Column, Total) (12:47)
Show Values As: Difference From or % Difference From (9:43)
Show Values As: Running Total OR % Running Total (10:43)
Show Values As: Rank (4:52)
Show Values As: Index (8:06)
Calculated Fields
Insert a calculated Field (12:02)
Calculated Items ( لا ينصح باستخدامها) (8:16)
The Solve Order and List Formulas Tools (8:17)
Pivot Charts
Pivot Charts Introduction (6:22)
Inserting Simple Excel Pivot Chart (8:22)
Pivot Chart Tools - Analyze Tab (5:47)
Pivot Chart Tools - Design Tab (10:13)
Pivot Chart Tools - Format Tab (8:39)
Overview on Chart Types in Excel (10:55)
GET PIVOT DATA FUNCTION
GETPIVOTDATA EXCEL FUNCTION INTRODUCTION (5:25)
GETPIVOTDATA EXCEL FUNCTION EXAMPLE (13:02)
GETPIVOTDATA EXCEL FUNCTION - IFERROR (6:20)
GETPIVOTDATA EXCEL FUNCTION - ACTIVATE (1:27)
GETPIVOTDATA EXCEL FUNCTION - WITH ADVANCED CHARTS (10:13)
GETPIVOTDATA EXCEL FUNCTION - WITH LIST (3:46)
Excel Charts
High Management Dashboard ( لوحة المعلومات الخاصة بالادارة العليا )
Projects High Level Dashboard - Overview (7:43)
PREPARE PIVOT TABLES # 1 (2:37)
PREPARE PIVOT TABLES # 2 (4:59)
PREPARE PIVOT TABLES # 3 (4:28)
EXCEL Dashboard Slicers (4:49)
PREPARE PIVOT CHARTS # 1 (7:15)
PREPARE PIVOT CHARTS # 2 (12:00)
PREPARE PIVOT CHARTS # 3 (5:20)
DASHBOARD FINALIZATION #1 (5:41)
DASHBOARD FINALIZATION # 2 (5:48)
DASHBOARD FINALIZATION # 3 (3:33)
WHY NOT USING TIME LINE (3:34)
Projects Managers Dashboard ( لوحة المعلومات الخاصة بمدراء المشاريع )
Projects Managers Dashboard Overview (5:13)
Download the File
Dashboard Pivot Tables (4:36)
EXCEL Dashboard Slicers (3:43)
Dashboard PIVOT Charts (7:42)
Finalization EXCEL Dashboard Part #1 (6:24)
Finalization EXCEL Dashboard Part #2 (9:04)
Finalization EXCEL Dashboard Part #3 (3:21)
Finalization EXCEL Dashboard Part #4 (10:27)
Functions and Formulas used in our file ( Projects and Tasks )
Section Introduction (مقدمة القسم) (1:14)
Tasks Table - Projects Info - VLOOKUP (11:45)
Tasks Table - Project Info - MATCH (9:53)
Tasks Table - Project Info - IFERROR (3:22)
Duration (14:30)
Duration Percentage (7:03)
Projects Table - Achievement Percentage (12:50)
Conditional Formatting (2:10)
Tasks Table - Other Formulas (1:52)
Projects Table - Other Formulas (3:19)
Teach online with
Tasks Table - Project Info - IFERROR
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock