SECTION 3: Advanced Excel Tasks

   

 


In this section you will learn how to:

  • Share workbooks
  • Track changes to a shared workbook
  • Merge and revise a shared workbook
  • Add VBA code to a macro
  • Declare variables and prompt for input with VBA
  • Iterate over a range, and use If/Then/Else statements with VBA
  • Identify file properties
  • Search for files
  • Protect personal information in a file
  • Create backup files
  • Change Auto-Recovery settings
  • Work with digital signatures
  • Set macro security
  • Protect your workbook with a password
  • Use custom AutoFill lists
  • Customize Excel
  • Use Detect and Repair
  • Use Text to Speech