Intro | |||
Introduction | 00:01:00 | ||
Section 01 | |||
Linking Worksheets and Workbooks | 00:07:00 | ||
Linking Worksheets with 3D References | 00:05:00 | ||
Understanding the Consolidate Feature | 00:06:00 | ||
Section 02 | |||
What are Range Names | 00:06:00 | ||
Creating Range Names Using the Name Box and Define Name | 00:06:00 | ||
Creating Range Names Using Create from Selection | 00:03:00 | ||
Section 03 | |||
Understanding the Differences Between Sorting and Filtering | 00:03:00 | ||
Sorting Lists | 00:07:00 | ||
Filtering Lists | 00:06:00 | ||
Creating Subtotals | 00:05:00 | ||
Section 04 | |||
Creating Tables and Understanding the Benefits | 00:06:00 | ||
Understanding the Elements of a Table | 00:05:00 | ||
Formatting a Table | 00:05:00 | ||
Sorting and Filtering Tables | 00:04:00 | ||
Filtering with Slicers | 00:07:00 | ||
Calculating with Tables | 00:06:00 | ||
Removing Erroneous Table Data | 00:05:00 | ||
Exporting, Refreshing, and Converting Tables | 00:05:00 | ||
Section 05 | |||
What is Conditional Formatting | 00:03:00 | ||
Conditional Formatting-HIghlight Cells and Top Bottom Rules | 00:06:00 | ||
Conditional Formatting-Data Bars, Icon Sets, and Color Scales | 00:06:00 | ||
Using Custom Fonts and Colors | 00:03:00 | ||
Using Custom Conditional Formatting | 00:05:00 | ||
Modyfing or Removing Conditional Formatting | 00:04:00 | ||
Section 06 | |||
What are Charts | 00:06:00 | ||
Forecasting with Trendlines | 00:05:00 | ||
Creating a Chart Template | 00:04:00 | ||
Displaying Trends with Sparklines | 00:08:00 | ||
Creating Charts | 00:05:00 | ||
Understanding Chart Elements | 00:05:00 | ||
Modifying Chart Elements | 00:05:00 | ||
Changing and Moving Charts | 00:03:00 | ||
Filtering a Chart | 00:04:00 | ||
Formatting Charts | 00:13:00 | ||
Adjusting Numbering | 00:06:00 | ||
Creating Dual Axis Charts | 00:05:00 | ||
Section 07 | |||
What is a PivotTable | 00:05:00 | ||
Creating a PivotTable | 00:07:00 | ||
Working with the PivotTable Fields Pane | 00:10:00 | ||
Basic Data Organization and Analysis with PivotTables | 00:08:00 | ||
Formatting PivotTables | 00:05:00 | ||
Creating a PivotChart | 00:04:00 | ||
Modifying and Formatting a PivotChart | 00:04:00 | ||
Using Slicers and Timeline Slicers | 00:08:00 | ||
Section 08 | |||
Using the PivotTable and PivotChart Wizard | 00:03:00 | ||
Adding a Calculated Field | 00:04:00 | ||
Adding a Calculated Item | 00:04:00 | ||
Applying Conditional Formatting to a PivotTable | 00:04:00 | ||
Creating Filter Pages for a PivotTable | 00:04:00 | ||
Enabling the PowerPivot Add-in | 00:11:00 | ||
Recap | |||
Recap | 00:02:00 |
Scholarship: Score 80% or more in your final exam to get this Fee refunded.
Membership renews after 12 months. You can cancel anytime from your account.