Advanced Excel Course Syllabus
EMI
0% Interest
Have Queries? Ask our Experts
+91 89256 88858
Quick Enquiry
Our Advanced Excel syllabus is intended for people who want to learn more complex techniques yet have a strong foundation in Excel principles. To improve your data manipulation and analysis skills, you will explore robust features like data analysis tools, VBA programming, and sophisticated formulae. Unlock the full potential of Excel with this advanced Excel course outline. Become proficient with complex formulas like array formulas and conditional formatting, and learn how to automate tedious operations with VBA programming through our advanced excel course.
Course Syllabus
Download SyllabusVBA 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
Our syllabus of advanced excel course is designed for professionals in finance, business, data analysis, and other fields who require advanced Excel skills for their daily work. Learn to tackle complex data challenges with confidence and efficiency with our advanced Excel course.
