December 3, 2021 2023-10-20 17:53
Advance Excel Training Syllabus
Learn how to utilize dynamic formulas effectively in worksheets through our Advanced Excel Course Syllabus framed by experts of SLA Institute. Get trained on specialized tools and templates from scratch with hands-on exercises to perform well in the industries.
Our Advanced Excel Course Curriculum covers VBA IDE, Macros, VBA language fundamentals, Control Flow and Loops Statements, VBA functions in worksheets, dialogue box and form objects in worksheets, and error handling.
VBA IDE
- opening the excel vba ide
- menu bar
- toolbar
- project window
- code window
- immediate window
- customizing the vbe
Getting Started With Macro
- recording the macro
- examining the macro
- saving workbooks that contain macros
Fundamentals Of VBA Language
- variable & constants
- keywords
- data types
- procedures: sub and function
- arguments
- local vs global variable declaration
- procedures: public or private
- comments
Control Flow & Loops Statements
- relational and logical operators
- if….then
- if….then….else
- if….then….elseif….else
- select case ( with to and with is)
- do while….loop
- doloop….while
- do until….loop
- doloop….until
- for….next
- for each….next
- while….wend
- the exit statement
Using VBA And Worksheet Functions
- vb functions
- excel functions
- the workbooks collection
- the sheets collection
- activate and select
- range property
- cells property
- offset property
- resize property
- currentregion property
- columns and rows properties
- referencing ranges in other sheets
- using the union and intersect methods
- using the isempty function
- using the areas collection
- transferring values between arrays and ranges
Working With Dialog Boxes And Form Objects
- using labels
- using text boxes
- using the command button control
- using list boxes
- using combo boxes
- using check boxes
- using radio buttons
- using toggle buttons
- using frames
- using message boxes
- taking input using input boxes
- tabstrip
- using a scrollbar as a slider to select values
- adding help tips to controls
- tab order
- colouring the active control
- transparent forms
- working with menus and toolbars
- creating menus and toolbars
Handling Errors
- types of errors in vba
- using the on error goto statement
- using the resume statement
- working with the err object
Conclusion
SLA Institute helps the professionals to empower their fundamental excel skills in our Advanced Excel Training in Chennai. Our Advanced Excel Course Syllabus equips you to perform complicated calculations and data analysis easily and efficiently.