Excel_VBA

Excel VBA Course Detail
Fees:
20,000

 

Duration:
2 Months

 

Course Contents:
Basic+Advance Excel+VBA.

 

Course Benefit:
Student will able to Advance Excel with VBA

 

  • Creating, editing, saving and printing spreadsheets
  • Working with functions & formulae
  • Graphically representing data : Charts & Graphs
  • Analyzing data : Data Menu, Subtotal, Filtering Data
  • Formatting worksheets , Securing & Protecting spreadsheets
  • Use the Function Wizard, Common functions (AVERAGE, MIN, MAX, COUNT,COUNTA, ROUND, INT,LEN,TRIM)
  • Nested functions , Name cells /ranges /constants
  • Relative, Absolute, Mixed cell references : >,<,= operators
  • Logical functions using IF, AND, OR, NOT
  • The LOOKUP function , Date and time functions , Annotating formulas
  • Sub Total Reports, Auto Filter
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/Ppt
  • What-if-analysis, GOAL SEEK
  • Pivot Tables, NESTED IF
  • Create charts , Enhance charts, Drawing toolbar features
  • Interactive charts
  • Dashboards in Excel
  • Recording the Macros
  • Understanding VBA
  • How to Develop functions/ Create Macros or add ins
  • \VBA Concepts
  • Macro Security
  • Enable/Disable Macros
  • Saving your macro worksheet.
  • Recording the Macros
  • Writing your first macro
  • Modifying your macro
  • Understanding VBE
  • Ways to Run Macros
  • Creating UDF’s
  • Call
  • Variables
  • Loops
Apply Now
Tableau Excel VBA SQL
Fees
20,000

 

Duration
2 Months

 

 

Excel VBA SQL
Fees
20,000

 

Duration
2 Month

 

 

KEY FEATURES

We started our journey in professionals

 

We started our journey in professionals

 

We started our journey in 2012 professionals We started our journey in professionals

We started our journey in professionals

 

We started our journey in professionals

CHOOSE YOUR COURSE

APPLY TO OUR CERTIFICATION COURSES NOW

Data
Science

Machine
Learning

Artificial
Intelligence

Python
Programming

R
Programming

Big
Data