Excel VBA Introduction Part 53.1 - Working with Strings
Excel VBA Introduction Part 54.1 - The IIf Function
Excel VBA Introduction Part 53.4 - Replacing Strings
Excel VBA Introduction Part 53.5 - Converting the Case of Text
Excel VBA Introduction Part 53.2 - Splitting Strings
Excel VBA Introduction Part 51.7 - Pivot Table Slicers
Excel VBA Introduction Part 53.3 - The Join Function and Concatenating Strings
Excel VBA Introduction Part 54.2 - The Switch Function
Excel VBA Introduction Part 51.1 - Introduction to Pivot Tables in VBA
Excel VBA Introduction Part 52.1 - Introduction to Shapes
Excel VBA Introduction Part 25 - Arrays
Excel VBA Introduction Part 51.3 - Pivot Tables using a SQL Server Database
Excel VBA Introduction Part 23 - Text Files (FileSystemObjects)
Excel VBA Introduction Part 50.2 - Embedding Charts in Worksheets
Excel VBA Introduction Part 45 - Finding the Last Used Row, Column and Cell
Excel VBA Introduction Part 47.1 - Browsing to Websites and Scraping a Web Page
Excel VBA Introduction Part 20.1 - Event Procedures
Excel VBA Introduction Part 58.4 - SQL for Excel Files - Selecting All or Distinct Rows
Excel VBA Introduction Part 53.6 - The Asc and Chr Functions
Excel VBA's Missing String Functions