- Lecture 1: ExTool Introduction
- Lecture 2: ExTool Initial Setup
- Lecture 3: ExTool First Time Use
- Lecture 4: ExTool Import Ribbon
- Lecture 1: Information in Excel--Who's Who?
- Lecture 2: Excel—Function Help Summary
- Lecture 3: Information (ShortCut)—Excel 2010
- Lecture 4: Template Chart—Chandoo
- Excel Workbook Management
- Lecture 1: Convert .xls to .xlsx
- Lecture 2: Open Folder of This File
- Lecture 3: Combine Listed Workbook
- Lecture 4: List Recent Workbooks
- Lecture 5: Remove Listed Files from Recent Workbook List
- Lecture 5: List Opened Workbooks
- Excel Worksheet Management
- Lecture 1: Add Listed Sheet
- Lecture 2: Delete Listed Sheet
- Lecture 3: List Sheet Name and Range (A1)
- Lecture 4: Excel—Copy Listed Sheet to New Workbook
- Lecture 5: Copy Each Listed Sheet to New Workbook
- Lecture 6: Combine Data in Listed Sheet
- Lecture 7: Copy Listed Sheet and Update Link
- Lecture 8: Sort Sheet in Listed Order
- Lecture 9: Rename Listed Sheet
- Lecture 10: Get Listed Sheet Color
- Lecture 11: Change Listed Sheet Color
- Lecture 12: Hide Listed Sheet
- Lecture 13: Unhide Listed Sheet
- Lecture 14: Protect Listed Sheets
- Lecture 15: Un-Protect Listed Sheets
- Excel Page Setup and Print
- Lecture 1: Copy Listed Sheet Page Setup
- Lecture 2: Clear Listed Sheet Page Setup
- Lecture 3: Print Selected Range to PDF
- Lecture 4: Print Listed Sheet to PDF
- Lecture 5: Print Charts in Sheets to GIF
- Excel Graphic Object Management
- Lecture 1: List Objects in This Sheet
- Lecture 2: Rename Listed Objects
- Lecture 3: Delete Listed Objects
- Lecture 4: Relocate Listed Objects
- Lecture 5: Resize Listed Objects
- Range – Select & List
- Lecture 1: List Selected Ranges
- Lecture 2: Select Listed Ranges
- Lecture 3: Select Non-Empty Cells In Target Range
- Lecture 4: Select Empty Cells in Target Range
- Lecture 5: Select Maximum Value in Each Column of Target Range
- Lecture 6: Select Maximum Value in Each Row of Target Range
- Lecture 7: Select Maximum Value in Target Range
- Lecture 8: Select Minimum Value in Each Row of Target Range
- Lecture 9: Select Minimum Value in Target Range
- Range – Copy & Move
- Lecture 1: Column to Range
- Lecture 2: Range to Column
- Lecture 3: Copy Selected Ranges
- Lecture 4: Copy Listed Ranges
- Lecture 5: Copy Range Exact Formula
- Range – Hyperlink
- Lecture 1: Add External Hyperlink
- Lecture 2: Add Internal Hyperlink
- Lecture 3: List Internal Hyperlink
- Lecture 4: List External Hyperlink
- Range – Text
- Lecture 1: Concat Cells
- Lecture 2: Reverse Text
- Lecture 3: Replace Star in Cell Text
- Lecture 4: Upper Case Text in Range
- Lecture 5: Capitalize Each Word in Range
- Lecture 6: Lower Case Text in Range
- Range – Format
- Lecture 1: Clear Format of Selected Ranges
- Lecture 2: List Installed Font
- Lecture 3: Apply Font Type for Selected Cells
- Data – Input/output
- Lecture 1: Import Selected .txt File
- Lecture 2: Export Range to .txt
- Lecture 1: Convert Selected Range Value As Displayed
- Lecture 2: Get Unique Values in Selected Ranges
- Data – Validation
- Lecture 1: Apply List Data Validation to Selected Cells
- Lecture 2: List Data Validation Rules of Selected Cells
- Lecture 3: Remove Data Validations
- Lecture 4: Prevent Duplicate Input in Selected Ranges