ExTool Introduction
  • Lecture 1: ExTool Introduction
  • Lecture 2: ExTool Initial Setup
  • Lecture 3: ExTool First Time Use
  • Lecture 4: ExTool Import Ribbon
Info & Template
  • 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
  • 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
  • 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
  • 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
  • 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 and List
  • 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 and Move
  • 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
  • Range – Hyperlink
  • Lecture 1: Add External Hyperlink
  • Lecture 2: Add Internal Hyperlink
  • Lecture 3: List Internal Hyperlink
  • Lecture 4: List External Hyperlink
Range – Text
  • 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
  • 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
  • Data – Input/output
  • Lecture 1: Import Selected .txt File
  • Lecture 2: Export Range to .txt
Data – Number
  • Lecture 1: Convert Selected Range Value As Displayed
  • Lecture 2: Get Unique Values in Selected Ranges
Data – Validation
  • 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
Formula – Misc.