Module 100: Forms - Overview
Module 101: Forms
Module 102: Available Form Controls
Module 103: Inserting Form Controls - Part 1
Module 104: Inserting Form Controls - Part 2
Module 105: Creating a Form
Module 106: ActiveX Controls
Module 107: Macros and Forms - Summary
Module 108: Course Contents - Summary
Module 11: Importing and Exporting XML Data - Example - Part 2
Module 12: Protecting the Current Worksheet
Module 13: Applying Protection and Sharing to Workbooks and Worksheets - Overview
Module 14: Allowing Edits to Ranges
Module 15: Protecting the Workbook Structure
Module 16: Restricting Permissions
Module 17: Permission Levels
Module 18: Additional Permissions Options
Module 19: Requiring Password to Open a Workbook
Module 1: Welcome from Instructor
Module 20: Maintaining Shared Workbooks - Overview
Module 21: Sharing Workbooks
Module 22: Disabled Features While Sharing
Module 23: How to Merge Workbooks
Module 24: Tracking Changes
Module 25: Viewing and Reviewing Tracked Changes
Module 26: Auditing Formulas - Overview
Module 27: Formula Tracing
Module 28: Locating Invalid Data and Formulas
Module 29: Correcting Errors in Formulas - Part 1
Module 2: Introduction to Course Contents
Module 30: Correcting Errors in Formulas - Part 2
Module 31: Manipulating Formula Options - Overview
Module 32: Setting Iterative Calculation Options
Module 33: Automatic Workbook Calculation
Module 34: Performing Data Summary Tasks - Overview
Module 35: Using an Arrray Formula
Module 36: Restriction Using an Array
Module 37: Array Functions and Formulas
Module 38: Array Constants
Module 39: Using Array Constants
Module 3: Applying Workbook Setting, Properties, and Data options - Overview
Module 40: Using the SUMIF and SUMIFS Functions
Module 41: Applying Functions in Formulas - Overview
Module 42: Error Messages
Module 43: Avoiding Errors in Functions
Module 44: Using Various Functions
Module 45: Applying Advanced Chart Features - Overview
Module 46: Trend Lines
Module 47: Applying Trend Lines - Part 1
Module 48: Applying Trend Lines - Part 2
Module 49: Applying Dual Axes
Module 4: Setting Advanced Properties
Module 50: Chart Templates
Module 51: Sparklines
Module 52: Applying Data Analysis - Overview
Module 53: Using Autmomated Analysis Tools
Module 54: Descriptive Statistics
Module 55: Histograms
Module 56: Rank and Percentile
Module 57: Random Number Generation
Module 58: Sampling Data
Module 59: Performing a What-if analysis
Module 5: Templates
Module 60: Data Tables
Module 61: Creating a One Variable Data Table
Module 62: Creating a Two Variable Data Table
Module 63: Scenario Manager
Module 64: Creating a Scenario
Module 65: Applying and Editing a Scenario
Module 66: Goal Seek
Module 67: Configuring Goal Seek
Module 68: Solver
Module 69: Using solver
Module 6: Saving a Workbook Template
Module 70: Applying and Manipulating PivotTables - Overview
Module 71: Creating a PivotTables - Part 1
Module 72: Creating a PivotTables - Part 2
Module 73: Manipulating PivotTables Data - Part 1
Module 74: Manipulating PivotTables Data - Part 2
Module 75: Manipulating PivotTables Data - Part 3
Module 76: Using the Slicer on PivotTables Data
Module 77: Applying and Manipulating PivotChart - Overview
Module 78: Creating and Manipulating PivotCharts
Module 79: PivotChart Options
Module 7: Saving and Inserting a Worksheet Template
Module 80: PivotChart - Example - Part 1
Module 81: PivotChart - Example - Part 2
Module 82: Connecting External Data - Overview
Module 83: Why Do We Need to Connect to External Data
Module 84: Connecting to Microsoft Access
Module 85: Connecting to Data on a Website
Module 86: Connecting to Text file
Module 87: Updating
Module 88: Connecting to Data in Existing Connections
Module 89: Refering to External Data in a Cell Formula
Module 8: Importing and Exporting XML Data
Module 90: Macros and Forms - Overview
Module 91: Macros
Module 92: Creating Macros
Module 93: Recoding Macros
Module 94: Modifying codes
Module 95: Updating
Module 96: Macro - Example - Part 1
Module 97: Macro - Example - Part 2
Module 98: Running Macros
Module 99: Creating a Button to Run Macros
Module 9: XML File Structure
Module 40: Using the SUMIF and SUMIFS Functions
Click to watch video