Course Description
-
Lesson 01: Linking Workbooks and Worksheets
00:06:00 -
Lesson 02: Linking Workbooks with 3D References
00:05:00 -
Lesson 03: Understanding the Consolidate Feature
00:06:00
-
Lesson 01: What are Range Names
00:04:00 -
Lesson 02: Creating Range Names Using the Name Box and Define Name
00:06:00 -
Lesson 03: Creating Range Names Using Create from Selection
00:03:00
-
Lesson 01: Understanding the Differences Between Sorting and Filtering
00:03:00 -
Lesson 02: Sorting Lists
00:06:00 -
Lesson 03: Filtering Lists
00:08:00 -
Lesson 04: Creating Subtotals
00:06:00
-
Lesson 01: Creating Tables and Understanding the Benefits
00:07:00 -
Lesson 02: Understanding the Elements of a Table
00:06:00 -
Lesson 03: Formatting a Table
00:08:00 -
Lesson 04: Sorting and Filtering Tables
00:03:00 -
Lesson 05: Filtering with Slicers
00:04:00 -
Lesson 06: Calculating with Tables
00:04:00 -
Lesson 07: Removing Erroneous Table Data
00:03:00 -
Lesson 08: Exporting, Refreshing, and Converting Tables
00:05:00
-
Lesson 01: What is Conditional Formatting
00:04:00 -
Lesson 02: Conditional Formatting Highlight Cells and Top Bottom Rules
00:07:00 -
Lesson 03: Conditional Formatting Data Bars, Icon Sets, and Color Scales
00:06:00 -
Lesson 04: Using Custom Fonts and Colors
00:04:00 -
Lesson 05: Using Custom Conditional Formatting
00:06:00 -
Lesson 06: Modifying or Removing Conditional Formatting
00:05:00
-
Lesson 01: What are Charts
00:05:00 -
Lesson 02: Creating Charts
00:06:00 -
Lesson 03: Understanding Chart Elements
00:05:00 -
Lesson 04: Modifying Chart Elements
00:09:00 -
Lesson 05: Changing and Moving Charts
00:04:00 -
Lesson 06: Filtering a Chart
00:04:00 -
Lesson 07: Formatting Charts
00:07:00 -
Lesson 08: Adjusting Numbering
00:06:00 -
Lesson 09: Creating Dual Axis Charts
00:05:00 -
Lesson 10: Forecasting with Trendlines
00:05:00 -
Lesson 11: Creating a Chart Template
00:04:00 -
Lesson 12: Displaying Trends with Sparklines
00:07:00
-
Lesson 01: What is a PivotTable
00:06:00 -
Lesson 02: Creating a PivotTable
00:07:00 -
Lesson 03: Working with the PivotTable Fields Pane
00:09:00 -
Lesson 04: Basic Data Organization and Analysis with PivotTables
00:06:00 -
Lesson 05: Formatting PivotTables
00:06:00 -
Lesson 06: Creating a PivotChart
00:04:00 -
Lesson 07: Modifying and Formatting a PivotChart
00:04:00 -
Lesson 08: Adding Slicers and Timeline Slicers
00:03:00 -
Lesson 09: Formatting Slicers
00:04:00 -
Lesson 10: Using the Ideas Feature
00:03:00
-
Lesson 01: Using the PivotTable and PivotChart Wizard
00:02:00 -
Lesson 02: Adding a Calculated Field
00:05:00 -
Lesson 03: Adding a Calculated Item
00:04:00 -
Lesson 04: Applying Conditional Formatting to a PivotTable
00:02:00 -
Lesson 05: Creating Filter Pages for a PivotTable_1
00:03:00 -
Lesson 06: Enabling the PowerPivot Add: In
00:06:00
Course Reviews
No Reviews found for this course.
Comming Soon!