Microsoft Excel - Data Analysis with Excel Pivot Tables
Focused View
4:02:00
23 View
01 Introduction to PivotTables.mp4
00:17
02 Format data for use in a PivotTable.mp4
00:41
03 Create a PivotTable.mp4
00:17
04 Pivot a PivotTable.mp4
03:31
05 Configure a PivotTable.mp4
03:02
06 Connect to an external data sourceConnect to an external data source.mp4
03:00
07 Connect to an external data source.mp4
05:09
08 Consolidate data from multiple sources.mp4
04:27
09 Define a default PivotTable layout.mp4
02:57
10 Summarizing PivotTable Data.mp4
05:07
11 Manage subtotals and grand totals.mp4
06:52
12 Change the data field summary operation.mp4
04:08
13 Summarize more than one data field.mp4
03:28
14 Manage dates in a PivotTable.mp4
03:59
15 Create a calculated field.mp4
02:40
16 Use PivotTable data in a formula.mp4
04:29
17 Drill down to the underlying data.mp4
04:19
18 Sort PivotTable data.mp4
04:05
19 Create a custom sort order.mp4
02:29
20 Filter a PivotTable field by selection.mp4
03:54
21 Filter a PivotTable by rule.mp4
04:47
22 Filter a PivotTable using a search filter.mp4
03:59
23 Filter a PivotTable using slicers.mp4
03:57
24 Format slicers.mp4
03:23
25 Filter a PivotTable with report filter fields.mp4
05:16
26 Clear and reapply PivotTable filters.mp4
06:19
27 Filter a PivotTable using a Timeline.mp4
04:01
28 Apply a PivotTable style.mp4
04:01
29 Create a PivotTable style.mp4
03:49
30 Change the PivotTable layout.mp4
04:32
31 Change the data field number format.mp4
04:06
32 Highlight cells by applying a rule.mp4
05:48
33 Highlight the top or bottom values in a PivotTable.mp4
05:19
34 Format cells using data bars.mp4
03:13
35 Format cells using color scales.mp4
03:59
36 Format cells using icon sets.mp4
03:59
37 Edit a conditional formatting rule.mp4
05:06
38 Control how multiple rules are applied.mp4
05:37
39 Delete a conditional formatting rule.mp4
03:47
40 Create a PivotChart.mp4
06:01
41 Pivot a PivotChart.mp4
03:26
42 Filter a PivotChart.mp4
03:19
43 Format a PivotChart.mp4
02:52
44 Change a PivotCharts layout.mp4
04:02
45 Change a PivotCharts chart type.mp4
02:02
46 Add a trendline to a PivotChart.mp4
03:26
47 Print a PivotTable.mp4
03:38
48 Set PivotTable print options.mp4
02:51
49 Print each item on its own page.mp4
02:53
50 Print a PivotChart.mp4
04:02
51 Record and review an Excel macro.mp4
02:36
52 Print a PivotTable.mp4
04:23
53 Set PivotTable print options.mp4
04:32
54 Print each item on its own page.mp4
01:17
55 Print a PivotChart.mp4
03:57
56 Record and review an Excel macro.mp4
05:26
57 Run an Excel macro.mp4
02:40
58 Create a simple PivotTable presentation kit.mp4
02:18
59 Change PivotTables using keyboard shortcuts.mp4
03:59
60 Create relationships between tables.mp4
03:18
61 Create a PivotTable using the data model.mp4
02:53
62 Edit table relationships.mp4
04:01
63 Deactivate and delete table relationships.mp4
03:35
64 Define sets using the Data Model.mp4
03:35
65 Additional resources.mp4
01:09
More details
User Reviews
Rating
average 0
Focused display
Category
SkillShare
View courses SkillShareSkillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.
- language english
- Training sessions 65
- duration 4:02:00
- English subtitles has
- Release Date 2024/02/13
