Advanced Excel – Part 2

1.1 Recording Macros: Recording and running macros 1 Quiz

1.2 Recording Macros: Types of references in macros 1 Quiz

1.3 Recording Macros: Assigning a macro to a toolbar or menu 1 Quiz

2.1 The Visual Basic Editor: Editing existing macros using VBA Editor 1 Quiz

2.2 The Visual Basic Editor: Writing functions using VBA Editor 1 Quiz

2.3 The Visual Basic Editor: Understanding the Project Explorer window 1 Quiz

2.4 The Visual Basic Editor: Exploring the properties window 1 Quiz

2.5 The Visual Basic Editor: Using the code window 1 Quiz

2.6 The Visual Basic Editor: Debugging code 1 Quiz

3.1 Writing Procedures for Selection Techniques and Looping: Variables, data types and constants 1 Quiz

3.2 Writing Procedures for Selection Techniques and Looping: Decision structures (IF….THEN, SELECT CASE) 1 Quiz

3.3 Writing Procedures for Selection Techniques and Looping: Logical operators (And, OR, Not) 1 Quiz

3.4 Writing Procedures for Selection Techniques and Looping: Looping constructs (For loops) 1 Quiz

3.5 Writing Procedures for Selection Techniques and Looping: Looping constructs (Do loops) 1 Quiz

3.6 Writing Procedures for Selection Techniques and Looping: Looping constructs (While…Wend statements) 1 Quiz

3.7.1: Built-in Functions: Information Functions 1 Quiz

3.7.2: Built-in Functions: Message Box and Input Box Functions 1 Quiz

3.7.3: Built-in Functions: String Functions 1 Quiz

3.8. Writing Procedures for Selection Techniques and Looping: Creating Sub & Function Procedures 1 Quiz

4.1 Writing Procedures for Worksheets and File related Objects: Working with objects-properties, events and methods 1 Quiz

4.2 Writing Procedures for Worksheets and File related Objects: Application objects 1 Quiz

4.3 Writing Procedures for Worksheets and File related Objects: Workbook objects, Worksheet objects and Range objects 1 Quiz

4.4 Writing Procedures for Worksheets and File related Objects: Working with File Objects 1 Quiz