Sumários

VBA – II & III

6 Dezembro 2021, 18:00 • FILIPE CALDEIRA SANTOS

  • Objects and Collections 

  • Workbooks, Cells and Ranges 

  • Programming Formulas and Functions 

  • Arrays 

  • Logical Operators and Blocks 

VBA – I

29 Novembro 2021, 18:00 • FILIPE CALDEIRA SANTOS

  • Introduction 

  • Macros and Modules 

  • Visual Basic Editor 

  • Variables and Constants 

  • Data Types 

  • Variable Declaration 

  • Variable Scope 

VBA – II & III

24 Novembro 2021, 18:00 • FILIPE CALDEIRA SANTOS

  • Objects and Collections 

  • Workbooks, Cells and Ranges 

  • Programming Formulas and Functions 

  • Arrays 

  • Logical Operators and Blocks 


  • Loops 

  • Automating MsExcel  

  • Interacting with MsWord and MsOutlook  

  • Debugging  

 

Built-In Functions and Analysis Tools - II

22 Novembro 2021, 18:00 • FILIPE CALDEIRA SANTOS

  • Date and Time Functions 

  • Text Functions 

  • Basic Database features 

  • Importing Data 

VBA – I

17 Novembro 2021, 18:00 • FILIPE CALDEIRA SANTOS

  • Introduction 

  • Macros and Modules 

  • Visual Basic Editor 

  • Variables and Constants 

  • Data Types 

  • Variable Declaration 

  • Variable Scope