Details
Outline
MACROS
- What are macros
- How to record macros
- How to run macros
- How Macros are related to VBA
VBA EDITOR
- What is VBA
- How to edit VBA Code
What is a “sub” routine
- What is Project Explorer
- How to turn on Project Explorer
- Excel Objects and Modules
- What are Excel Objects
- What are Modules
- Making a sheet hidden
- Properties,
- What are Properties and their purpose
- Renaming Modules
- Renaming Sheets
- Watch Window
- What is a watch window and how to use it
- Comments
- What are comments
- How are comments marked
- The importance of comments
- Debugger
- What is the debugger
- How is it used
- Step into
- Step over
- Step Out
- Play
- Breakpoint
- Reset
- Monitoring values
DECLARING VARIABLES
- What are Variables
- How to declare variables
- Using “Option Explicit”
- Declaring multiple variables
- Requiring variable declaration
- Types of Variables
- String
- Integer
- Single
- Double
- Boolean
- Date
- Time
- Variant
- Why to avoid variant declaration
- When to use variant
REFERENCING AND MANIPULATING
- Cells
- Selecting a specific cell
- Selecting the active cell
- Setting the value of a cell
- Deleting cell contents
- Rows
- Selecting a specific row
- Selecting the active row
- Selecting the last row
- Insert a row
- Deleting row contents
- Columns
- Selecting a specific column
- Selecting the active column
- Selecting the last column
- Insert a column
- Deleting the column contents
- Worksheets
- Selecting a specific Worksheet
- Selecting the active worksheet
- Adding a new worksheet
- Naming a worksheet
- Range
- Selecting a range of cells
STRINGS
- How to Reference a string
- Concatenating strings
IF STATEMENTS
- If Then Statements
- If Then Else Statements
LOOPS
- Do While Loop
- For Next Loop
- For Next Loop with Step
- Do Until Loop
- For Each Loop
ACTIVATING SCRIPT WHEN WORKBOOK OPENS
- Workbook_Open
- Auto_Open
We have been training the college professors and IT department heads at all the State University of New York City Colleges and Institutions, along with corporations and individuals, for many years. Call or email us to experience what good computer training in New York City is all about. We have hundreds of satisfied clients who are willing to provide referrals. We would like to make you one of those clients.
We offer both customized Corporate Training and Group Classes. Since 1998, we have trained thousands in the New York Metro area, along with hundreds of international clients. We are serious about delivering the most practical, focused computer training around New York and beyond.
Why is NYIM the Highest Rated Excel Training in NYC?
- The most practical and hands-on training
- State-of-the-art curriculum refined by industry experts
- Interactive lessons taught by world-class instructors
- Personalized attention in small classroom sizes
- Revolutionary video suite with premium content (selected courses)
- Custom in-depth manuals and shortcut sheets
For more information about individual or corporate training, please contact us at (212) 658-1918 or [email protected].