Excel Object Model: The Excel Component Object Model - Using Methods and Events - Object Variables and Binding - Creating User Defined Types and Classes
Working with the Range Object: Range Objects Defined - Referencing Ranges using VBA - Dynamic Range Handling - Copying or Moving Range Data - Creating Array Variables
Working With Data in Excel: Importing Data into Excel - Data Types and Formatting - Validating Data - Filtering and Sorting Data with VBA - Using Database Functions - Excel Tables
Presenting Data in Excel: Applying Conditional Formatting with VBA - Working with Charts - Pivot Tables
Working with the Excel Interface: Working with Page and Print Options - Controlling Visual Elements of a Workbook - Workbook Sharing and Track Changes - Workbook Security using VBA
Managing Files and Folders from Excel: FileSystemObject - Managing Folders from Excel - File Management Tasks using Excel - Working with File Properties and Attributes from Excel - Reading a Text File from Excel
Shareable on LinkedIn
You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.