loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Advanced Excel MIS VBA Access Course Training Institute in Delhi

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid 10 digit Phone Number

Note: Please enter the phone number that you want to receive a call on.

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With IPT

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

Advanced Excel MIS VBA Access Course Training Institute in Delhi

Online Instructor led Course

Platform:

15,000

No Reviews Yet
5 Interested

About the Course


Level— 1
Advance Excel with Formulas
Excel Application Setting
Paste with Calculation
Advance Custom Formatting
Use Formulas in Conditional Formatting
Excel Protection System
Data Filling wit Flash Fill
Data Shorting , Filter and Selection Concept
Data Analyzing with Pivot
Recognized Pivot Table
Relational Pivot
Reporting with Chart
Insert Other Application in Excel Sheet

Concept of Formulas Inserting
Logical Formulas Use
Working with Text Formulas
Working With Date & Time Formulas
Data Lookup with VLookup,HLookup,Match,
Index, using Array
Mathematics Calculation
Database Formulas
Informational Formulas
Financial Formulas
Array formulas
Formulas Nesting
Formulas Tricks
Data Import Other Database
Data Import Access Database
Data Connection with SQL Server 2012
Data Import from Webs and FTP
Data Clean Hansi and Advance Filter
Validation and What-if-Analysis
SubTotal

Learn Complete Excel , VBA Macros , Report Automation and Dashboard

Level : - 2 (Report Automation and Dashboard Reporting with Dashboard)

Advance Conditional Formation
Array Formulas
Formulas Nesting
Miscellaneous Formula Techniques
Performing With Array Formulas
Report Automation Sample
Understanding the Series Formulas
Creating Links to Cells For Title,Axis,Labels and Text
Charting Progess Toward a Goal
Creating a Gauge Chart
Displaying the Conditional Colors
Creating Comparative Histogram
Creating a Grant Chart
Ceating a Box Plot
Handling Missing Data
Chart with Access and SQL
Chart with Form Cantrol Buttons
Interactive Dashboards using PowerPoint and Excel
Introduction to Dashboards

Dashboard Background
Dashboard Elements
Interactive Dashboards
Type of Reporting in India
Reporting Analyst
Indian print media reporting
audit report
Accounting MIS Reports
HR Mis Reports?
MIS Report Preparation Supplier, Exporter
Data analysis
Costing Budgeting Mis Reporting
MIS Report for Manufacturing Company
MIS Reporting For Store and Billing
Product Performance Report
Member Performance Report
Customer-wise Sales Report
Collections Report
Channel Stock Report
Prospect Analysis Report
Calling Reports
Expenses Report
Stock controller MIS reporting





Advance Excel & MIS Reporting With VBA Macros

Level 1 : - 20 Hours ( 4000 /-)
Level 2 : - 15 Hours( (3500/-)
Level3 : - 35 Hours ( 6000/)
All 1,2,3 : - 65 Hours ( 10,000/-)

L

Training By Mr. Sujeet Kumat (MCA and 10 year Working Expr.)

Excel 2013 VBA Macros

Online & Offline

How to use the Visual Basic (VBA) Editor and its debugging tools
Complete review of the VBA language (Subs, Functions, variables, arrays, loops, logic...etc)
How to command Microsoft Excel using VBA. Also discussed is how control Word and PowerPoint
How to use Microsoft Excel VBA to analyze data on single and multi worksheets
How to open and close workbooks and text files
How to use Excel VBA to perform calculations on data
How to create summary sheets using VBA
How to create basic dashboards in Microsoft Excel using VBA
How to use Excel VBA to fill in Excel forms on the worksheet from text file data and workbook data
How to manage Excel models, strategy and layout using Excel and VBA
How to create and format single and multiple charts using VBA
Using VBA to create report generation tools in Microsoft Word and Microsoft PowerPoint using Excel VBA
How to use Excel VBA to build your own custom worksheet functions
How to use the Visual Basic Macro Recorder and interpret its recordings
How to download data from the web using VBA
An advanced review of the Excel VBA language
Advanced VBA data processing techniques for multi worksheets and multi workbooks
Advanced summary worksheet construction in Excel using Excel VBA
Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA
How to read text files using VBA.
Advanced VBA programming techniques for creating multiple charts from multiple data sheets
How to create advanced business user interfaces on worksheets using ActiveX controls, VBA and graphics
Advanced excel dashboard construction
How to create and use userforms in VBA (wizards)
How to create event driven programs using VBA
Advanced VBA error protection techniques
How to create custom toolbars and menus to run your VBA code
How to communicate with databases using DAO and ADO in VBA and how to download data from the web using VBA
Advanced VBA techniques for communicating with other languages and programs



Overview of how Microsoft Visual Basic (VBA) and Excel are used in business problems
VBA Editor review including using the VBA debugger and the purposes of VBA projects, modules and procedures
Excel macro language review (VBA) including variables, data types, constants, arrays, operators, expressions, loops, logic decisions and calling
Overview of commanding Excel using VBA including a discussion of objects, properties and methods
How to analyze business data on single Excel worksheets using loops and logic.
How to load Excel forms on the worksheet using loops and logic
Model management, layout and strategy using Excel and VBA
How to create charts using VBA


Excel VBA Power Programming For VBA Macros

How to analyze data on multi worksheets and build summary sheets
How to access the Windows file and folder system to open and close workbooks and text files being processed
How to protect your code against errors
How to use Excel and VBA to create basic dash boards
How to create your own custom business worksheet functions in VBA
How to create basic report generation tools using Excel VBA, Microsoft Word and PowerPoint
How to use the Excel Visual Basic macro recorder to record Excel tasks in VBA and then interpret the code
How to download data (stock market report, historical tables...etc) from web pages automatically
How to automate the data analysis tool pack add-in like regression analysis using VBA


Level—3

Advance Excel & MIS Reporting With VBA Macros

Beginning Excel VBA Training

Microsoft Excel VBA language overview
Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA
How to read text files using VBA.
Advanced VBA data entry, data processing and data summation techniques for multi worksheet and multi workbook problems
Advanced techniques to reconcile data in Excel using Excel VBA
Advanced VBA programming techniques for creating multiple charts from multiple data sheets
How to control drawing shapes, ActiveX controls and Excel's coordinate system with VBA (Worksheet Form Construction)
How to create VBA events for action driven applications in Microsoft Excel

How to use graphics, userforms, drawing shapes, ActiveX controls and Excel VBA to create advanced dashboards in Excel
Advanced command of Microsoft Word and PowerPoint using Excel VBA (report generation tools)
How to command databases using DAO, ADO and OLE DB in VBA
Introduction to using ADO OLE DB to query workbooks and text files
How to distribute your Excel programs
How to control other languages like Perl and C

Advanced Excel VBA Training

How to develop business user interfaces on the worksheet using ActiveX controls and Excel VBA
VBA wizard overview
Overview of using userforms to create business wizards
How to create userforms in VBA
How to create controls and graphics on userforms
How to command userforms and their ActiveX controls with VBA
Excel VBA wizard design tips
How to create toolbars and menus to control your VBA wizards
How to control Excel’s toolbar and menu system with VBA

Level—3

Advance Excel & MIS Reporting With VBA Macros

Excel VBA Power Programming For VBA Macros

Excel VBA Macros

35 Hours

Mon– Fri and SAT-Sun
Free : - 6000/-


Topics Covered

Level— 1
Advance Excel with Formulas
Excel Application Setting
Paste with Calculation
Advance Custom Formatting
Use Formulas in Conditional Formatting
Excel Protection System
Data Filling wit Flash Fill
Data Shorting , Filter and Selection Concept
Data Analyzing with Pivot
Recognized Pivot Table
Relational Pivot
Reporting with Chart
Insert Other Application in Excel Sheet

Concept of Formulas Inserting
Logical Formulas Use
Working with Text Formulas
Working With Date & Time Formulas
Data Lookup with VLookup,HLookup,Match,
Index, using Array
Mathematics Calculation
Database Formulas
Informational Formulas
Financial Formulas
Array formulas
Formulas Nesting
Formulas Tricks
Data Import Other Database
Data Import Access Database
Data Connection with SQL Server 2012
Data Import from Webs and FTP
Data Clean Hansi and Advance Filter
Validation and What-if-Analysis
SubTotal

Learn Complete Excel , VBA Macros , Report Automation and Dashboard

Level : - 2 (Report Automation and Dashboard Reporting with Dashboard)

Advance Conditional Formation
Array Formulas
Formulas Nesting
Miscellaneous Formula Techniques
Performing With Array Formulas
Report Automation Sample
Understanding the Series Formulas
Creating Links to Cells For Title,Axis,Labels and Text
Charting Progess Toward a Goal
Creating a Gauge Chart
Displaying the Conditional Colors
Creating Comparative Histogram
Creating a Grant Chart
Ceating a Box Plot
Handling Missing Data
Chart with Access and SQL
Chart with Form Cantrol Buttons
Interactive Dashboards using PowerPoint and Excel
Introduction to Dashboards

Dashboard Background
Dashboard Elements
Interactive Dashboards
Type of Reporting in India
Reporting Analyst
Indian print media reporting
audit report
Accounting MIS Reports
HR Mis Reports?
MIS Report Preparation Supplier, Exporter
Data analysis
Costing Budgeting Mis Reporting
MIS Report for Manufacturing Company
MIS Reporting For Store and Billing
Product Performance Report
Member Performance Report
Customer-wise Sales Report
Collections Report
Channel Stock Report
Prospect Analysis Report
Calling Reports
Expenses Report
Stock controller MIS reporting





Advance Excel & MIS Reporting With VBA Macros

Level 1 : - 20 Hours ( 4000 /-)
Level 2 : - 15 Hours( (3500/-)
Level3 : - 35 Hours ( 6000/)
All 1,2,3 : - 65 Hours ( 10,000/-)

L

Training By Mr. Sujeet Kumat (MCA and 10 year Working Expr.)

Excel 2013 VBA Macros

Online & Offline

How to use the Visual Basic (VBA) Editor and its debugging tools
Complete review of the VBA language (Subs, Functions, variables, arrays, loops, logic...etc)
How to command Microsoft Excel using VBA. Also discussed is how control Word and PowerPoint
How to use Microsoft Excel VBA to analyze data on single and multi worksheets
How to open and close workbooks and text files
How to use Excel VBA to perform calculations on data
How to create summary sheets using VBA
How to create basic dashboards in Microsoft Excel using VBA
How to use Excel VBA to fill in Excel forms on the worksheet from text file data and workbook data
How to manage Excel models, strategy and layout using Excel and VBA
How to create and format single and multiple charts using VBA
Using VBA to create report generation tools in Microsoft Word and Microsoft PowerPoint using Excel VBA
How to use Excel VBA to build your own custom worksheet functions
How to use the Visual Basic Macro Recorder and interpret its recordings
How to download data from the web using VBA
An advanced review of the Excel VBA language
Advanced VBA data processing techniques for multi worksheets and multi workbooks
Advanced summary worksheet construction in Excel using Excel VBA
Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA
How to read text files using VBA.
Advanced VBA programming techniques for creating multiple charts from multiple data sheets
How to create advanced business user interfaces on worksheets using ActiveX controls, VBA and graphics
Advanced excel dashboard construction
How to create and use userforms in VBA (wizards)
How to create event driven programs using VBA
Advanced VBA error protection techniques
How to create custom toolbars and menus to run your VBA code
How to communicate with databases using DAO and ADO in VBA and how to download data from the web using VBA
Advanced VBA techniques for communicating with other languages and programs





Overview of how Microsoft Visual Basic (VBA) and Excel are used in business problems
VBA Editor review including using the VBA debugger and the purposes of VBA projects, modules and procedures
Excel macro language review (VBA) including variables, data types, constants, arrays, operators, expressions, loops, logic decisions and calling
Overview of commanding Excel using VBA including a discussion of objects, properties and methods
How to analyze business data on single Excel worksheets using loops and logic.
How to load Excel forms on the worksheet using loops and logic
Model management, layout and strategy using Excel and VBA
How to create charts using VBA


Excel VBA Power Programming For VBA Macros

How to analyze data on multi worksheets and build summary sheets
How to access the Windows file and folder system to open and close workbooks and text files being processed
How to protect your code against errors
How to use Excel and VBA to create basic dash boards
How to create your own custom business worksheet functions in VBA
How to create basic report generation tools using Excel VBA, Microsoft Word and PowerPoint
How to use the Excel Visual Basic macro recorder to record Excel tasks in VBA and then interpret the code
How to download data (stock market report, historical tables...etc) from web pages automatically
How to automate the data analysis tool pack add-in like regression analysis using VBA


Level—3

Advance Excel & MIS Reporting With VBA Macros

Beginning Excel VBA Training

Microsoft Excel VBA language overview
Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA
How to read text files using VBA.
Advanced VBA data entry, data processing and data summation techniques for multi worksheet and multi workbook problems
Advanced techniques to reconcile data in Excel using Excel VBA
Advanced VBA programming techniques for creating multiple charts from multiple data sheets
How to control drawing shapes, ActiveX controls and Excel's coordinate system with VBA (Worksheet Form Construction)
How to create VBA events for action driven applications in Microsoft Excel

How to use graphics, userforms, drawing shapes, ActiveX controls and Excel VBA to create advanced dashboards in Excel
Advanced command of Microsoft Word and PowerPoint using Excel VBA (report generation tools)
How to command databases using DAO, ADO and OLE DB in VBA
Introduction to using ADO OLE DB to query workbooks and text files
How to distribute your Excel programs
How to control other languages like Perl and C

Advanced Excel VBA Training

How to develop business user interfaces on the worksheet using ActiveX controls and Excel VBA
VBA wizard overview
Overview of using userforms to create business wizards
How to create userforms in VBA
How to create controls and graphics on userforms
How to command userforms and their ActiveX controls with VBA
Excel VBA wizard design tips
How to create toolbars and menus to control your VBA wizards
How to control Excel’s toolbar and menu system with VBA

Level—3

Advance Excel & MIS Reporting With VBA Macros

Excel VBA Power Programming For VBA Macros

Excel VBA Macros

35 Hours

Mon– Fri and SAT-Sun
Free : - 6000/-


Who should attend

Level— 1
Advance Excel with Formulas
Excel Application Setting
Paste with Calculation
Advance Custom Formatting
Use Formulas in Conditional Formatting
Excel Protection System
Data Filling wit Flash Fill
Data Shorting , Filter and Selection Concept
Data Analyzing with Pivot
Recognized Pivot Table
Relational Pivot
Reporting with Chart
Insert Other Application in Excel Sheet

Concept of Formulas Inserting
Logical Formulas Use
Working with Text Formulas
Working With Date & Time Formulas
Data Lookup with VLookup,HLookup,Match,
Index, using Array
Mathematics Calculation
Database Formulas
Informational Formulas
Financial Formulas
Array formulas
Formulas Nesting
Formulas Tricks
Data Import Other Database
Data Import Access Database
Data Connection with SQL Server 2012
Data Import from Webs and FTP
Data Clean Hansi and Advance Filter
Validation and What-if-Analysis
SubTotal

Learn Complete Excel , VBA Macros , Report Automation and Dashboard

Level : - 2 (Report Automation and Dashboard Reporting with Dashboard)

Advance Conditional Formation
Array Formulas
Formulas Nesting
Miscellaneous Formula Techniques
Performing With Array Formulas
Report Automation Sample
Understanding the Series Formulas
Creating Links to Cells For Title,Axis,Labels and Text
Charting Progess Toward a Goal
Creating a Gauge Chart
Displaying the Conditional Colors
Creating Comparative Histogram
Creating a Grant Chart
Ceating a Box Plot
Handling Missing Data
Chart with Access and SQL
Chart with Form Cantrol Buttons
Interactive Dashboards using PowerPoint and Excel
Introduction to Dashboards

Dashboard Background
Dashboard Elements
Interactive Dashboards
Type of Reporting in India
Reporting Analyst
Indian print media reporting
audit report
Accounting MIS Reports
HR Mis Reports?
MIS Report Preparation Supplier, Exporter
Data analysis
Costing Budgeting Mis Reporting
MIS Report for Manufacturing Company
MIS Reporting For Store and Billing
Product Performance Report
Member Performance Report
Customer-wise Sales Report
Collections Report
Channel Stock Report
Prospect Analysis Report
Calling Reports
Expenses Report
Stock controller MIS reporting





Advance Excel & MIS Reporting With VBA Macros

Level 1 : - 20 Hours ( 4000 /-)
Level 2 : - 15 Hours( (3500/-)
Level3 : - 35 Hours ( 6000/)
All 1,2,3 : - 65 Hours ( 10,000/-)

L

Training By Mr. Sujeet Kumat (MCA and 10 year Working Expr.)

Excel 2013 VBA Macros

Online & Offline

How to use the Visual Basic (VBA) Editor and its debugging tools
Complete review of the VBA language (Subs, Functions, variables, arrays, loops, logic...etc)
How to command Microsoft Excel using VBA. Also discussed is how control Word and PowerPoint
How to use Microsoft Excel VBA to analyze data on single and multi worksheets
How to open and close workbooks and text files
How to use Excel VBA to perform calculations on data
How to create summary sheets using VBA
How to create basic dashboards in Microsoft Excel using VBA
How to use Excel VBA to fill in Excel forms on the worksheet from text file data and workbook data
How to manage Excel models, strategy and layout using Excel and VBA
How to create and format single and multiple charts using VBA
Using VBA to create report generation tools in Microsoft Word and Microsoft PowerPoint using Excel VBA
How to use Excel VBA to build your own custom worksheet functions
How to use the Visual Basic Macro Recorder and interpret its recordings
How to download data from the web using VBA
An advanced review of the Excel VBA language
Advanced VBA data processing techniques for multi worksheets and multi workbooks
Advanced summary worksheet construction in Excel using Excel VBA
Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA
How to read text files using VBA.
Advanced VBA programming techniques for creating multiple charts from multiple data sheets
How to create advanced business user interfaces on worksheets using ActiveX controls, VBA and graphics
Advanced excel dashboard construction
How to create and use userforms in VBA (wizards)
How to create event driven programs using VBA
Advanced VBA error protection techniques
How to create custom toolbars and menus to run your VBA code
How to communicate with databases using DAO and ADO in VBA and how to download data from the web using VBA
Advanced VBA techniques for communicating with other languages and programs




Overview of how Microsoft Visual Basic (VBA) and Excel are used in business problems
VBA Editor review including using the VBA debugger and the purposes of VBA projects, modules and procedures
Excel macro language review (VBA) including variables, data types, constants, arrays, operators, expressions, loops, logic decisions and calling
Overview of commanding Excel using VBA including a discussion of objects, properties and methods
How to analyze business data on single Excel worksheets using loops and logic.
How to load Excel forms on the worksheet using loops and logic
Model management, layout and strategy using Excel and VBA
How to create charts using VBA


Excel VBA Power Programming For VBA Macros

How to analyze data on multi worksheets and build summary sheets
How to access the Windows file and folder system to open and close workbooks and text files being processed
How to protect your code against errors
How to use Excel and VBA to create basic dash boards
How to create your own custom business worksheet functions in VBA
How to create basic report generation tools using Excel VBA, Microsoft Word and PowerPoint
How to use the Excel Visual Basic macro recorder to record Excel tasks in VBA and then interpret the code
How to download data (stock market report, historical tables...etc) from web pages automatically
How to automate the data analysis tool pack add-in like regression analysis using VBA


Level—3

Advance Excel & MIS Reporting With VBA Macros

Beginning Excel VBA Training

Microsoft Excel VBA language overview
Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA
How to read text files using VBA.
Advanced VBA data entry, data processing and data summation techniques for multi worksheet and multi workbook problems
Advanced techniques to reconcile data in Excel using Excel VBA
Advanced VBA programming techniques for creating multiple charts from multiple data sheets
How to control drawing shapes, ActiveX controls and Excel's coordinate system with VBA (Worksheet Form Construction)
How to create VBA events for action driven applications in Microsoft Excel

How to use graphics, userforms, drawing shapes, ActiveX controls and Excel VBA to create advanced dashboards in Excel
Advanced command of Microsoft Word and PowerPoint using Excel VBA (report generation tools)
How to command databases using DAO, ADO and OLE DB in VBA
Introduction to using ADO OLE DB to query workbooks and text files
How to distribute your Excel programs
How to control other languages like Perl and C

Advanced Excel VBA Training

How to develop business user interfaces on the worksheet using ActiveX controls and Excel VBA
VBA wizard overview
Overview of using userforms to create business wizards
How to create userforms in VBA
How to create controls and graphics on userforms
How to command userforms and their ActiveX controls with VBA
Excel VBA wizard design tips
How to create toolbars and menus to control your VBA wizards
How to control Excel’s toolbar and menu system with VBA

Level—3

Advance Excel & MIS Reporting With VBA Macros

Excel VBA Power Programming For VBA Macros

Excel VBA Macros

35 Hours

Mon– Fri and SAT-Sun
Free : - 6000/-


Pre-requisites

Level— 1
Advance Excel with Formulas
Excel Application Setting
Paste with Calculation
Advance Custom Formatting
Use Formulas in Conditional Formatting
Excel Protection System
Data Filling wit Flash Fill
Data Shorting , Filter and Selection Concept
Data Analyzing with Pivot
Recognized Pivot Table
Relational Pivot
Reporting with Chart
Insert Other Application in Excel Sheet

Concept of Formulas Inserting
Logical Formulas Use
Working with Text Formulas
Working With Date & Time Formulas
Data Lookup with VLookup,HLookup,Match,
Index, using Array
Mathematics Calculation
Database Formulas
Informational Formulas
Financial Formulas
Array formulas
Formulas Nesting
Formulas Tricks
Data Import Other Database
Data Import Access Database
Data Connection with SQL Server 2012
Data Import from Webs and FTP
Data Clean Hansi and Advance Filter
Validation and What-if-Analysis
SubTotal

Learn Complete Excel , VBA Macros , Report Automation and Dashboard

Level : - 2 (Report Automation and Dashboard Reporting with Dashboard)

Advance Conditional Formation
Array Formulas
Formulas Nesting
Miscellaneous Formula Techniques
Performing With Array Formulas
Report Automation Sample
Understanding the Series Formulas
Creating Links to Cells For Title,Axis,Labels and Text
Charting Progess Toward a Goal
Creating a Gauge Chart
Displaying the Conditional Colors
Creating Comparative Histogram
Creating a Grant Chart
Ceating a Box Plot
Handling Missing Data
Chart with Access and SQL
Chart with Form Cantrol Buttons
Interactive Dashboards using PowerPoint and Excel
Introduction to Dashboards

Dashboard Background
Dashboard Elements
Interactive Dashboards
Type of Reporting in India
Reporting Analyst
Indian print media reporting
audit report
Accounting MIS Reports
HR Mis Reports?
MIS Report Preparation Supplier, Exporter
Data analysis
Costing Budgeting Mis Reporting
MIS Report for Manufacturing Company
MIS Reporting For Store and Billing
Product Performance Report
Member Performance Report
Customer-wise Sales Report
Collections Report
Channel Stock Report
Prospect Analysis Report
Calling Reports
Expenses Report
Stock controller MIS reporting





Advance Excel & MIS Reporting With VBA Macros

Level 1 : - 20 Hours ( 4000 /-)
Level 2 : - 15 Hours( (3500/-)
Level3 : - 35 Hours ( 6000/)
All 1,2,3 : - 65 Hours ( 10,000/-)

L

Training By Mr. Sujeet Kumat (MCA and 10 year Working Expr.)

Excel 2013 VBA Macros

Online & Offline

How to use the Visual Basic (VBA) Editor and its debugging tools
Complete review of the VBA language (Subs, Functions, variables, arrays, loops, logic...etc)
How to command Microsoft Excel using VBA. Also discussed is how control Word and PowerPoint
How to use Microsoft Excel VBA to analyze data on single and multi worksheets
How to open and close workbooks and text files
How to use Excel VBA to perform calculations on data
How to create summary sheets using VBA
How to create basic dashboards in Microsoft Excel using VBA
How to use Excel VBA to fill in Excel forms on the worksheet from text file data and workbook data
How to manage Excel models, strategy and layout using Excel and VBA
How to create and format single and multiple charts using VBA
Using VBA to create report generation tools in Microsoft Word and Microsoft PowerPoint using Excel VBA
How to use Excel VBA to build your own custom worksheet functions
How to use the Visual Basic Macro Recorder and interpret its recordings
How to download data from the web using VBA
An advanced review of the Excel VBA language
Advanced VBA data processing techniques for multi worksheets and multi workbooks
Advanced summary worksheet construction in Excel using Excel VBA
Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA
How to read text files using VBA.
Advanced VBA programming techniques for creating multiple charts from multiple data sheets
How to create advanced business user interfaces on worksheets using ActiveX controls, VBA and graphics
Advanced excel dashboard construction
How to create and use userforms in VBA (wizards)
How to create event driven programs using VBA
Advanced VBA error protection techniques
How to create custom toolbars and menus to run your VBA code
How to communicate with databases using DAO and ADO in VBA and how to download data from the web using VBA
Advanced VBA techniques for communicating with other languages and programs




Overview of how Microsoft Visual Basic (VBA) and Excel are used in business problems
VBA Editor review including using the VBA debugger and the purposes of VBA projects, modules and procedures
Excel macro language review (VBA) including variables, data types, constants, arrays, operators, expressions, loops, logic decisions and calling
Overview of commanding Excel using VBA including a discussion of objects, properties and methods
How to analyze business data on single Excel worksheets using loops and logic.
How to load Excel forms on the worksheet using loops and logic
Model management, layout and strategy using Excel and VBA
How to create charts using VBA


Excel VBA Power Programming For VBA Macros

How to analyze data on multi worksheets and build summary sheets
How to access the Windows file and folder system to open and close workbooks and text files being processed
How to protect your code against errors
How to use Excel and VBA to create basic dash boards
How to create your own custom business worksheet functions in VBA
How to create basic report generation tools using Excel VBA, Microsoft Word and PowerPoint
How to use the Excel Visual Basic macro recorder to record Excel tasks in VBA and then interpret the code
How to download data (stock market report, historical tables...etc) from web pages automatically
How to automate the data analysis tool pack add-in like regression analysis using VBA


Level—3

Advance Excel & MIS Reporting With VBA Macros

Beginning Excel VBA Training

Microsoft Excel VBA language overview
Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA
How to read text files using VBA.
Advanced VBA data entry, data processing and data summation techniques for multi worksheet and multi workbook problems
Advanced techniques to reconcile data in Excel using Excel VBA
Advanced VBA programming techniques for creating multiple charts from multiple data sheets
How to control drawing shapes, ActiveX controls and Excel's coordinate system with VBA (Worksheet Form Construction)
How to create VBA events for action driven applications in Microsoft Excel

How to use graphics, userforms, drawing shapes, ActiveX controls and Excel VBA to create advanced dashboards in Excel
Advanced command of Microsoft Word and PowerPoint using Excel VBA (report generation tools)
How to command databases using DAO, ADO and OLE DB in VBA
Introduction to using ADO OLE DB to query workbooks and text files
How to distribute your Excel programs
How to control other languages like Perl and C

Advanced Excel VBA Training

How to develop business user interfaces on the worksheet using ActiveX controls and Excel VBA
VBA wizard overview
Overview of using userforms to create business wizards
How to create userforms in VBA
How to create controls and graphics on userforms
How to command userforms and their ActiveX controls with VBA
Excel VBA wizard design tips
How to create toolbars and menus to control your VBA wizards
How to control Excel’s toolbar and menu system with VBA

Level—3

Advance Excel & MIS Reporting With VBA Macros

Excel VBA Power Programming For VBA Macros

Excel VBA Macros

35 Hours

Mon– Fri and SAT-Sun
Free : - 6000/-


What you need to bring

Level— 1
Advance Excel with Formulas
Excel Application Setting
Paste with Calculation
Advance Custom Formatting
Use Formulas in Conditional Formatting
Excel Protection System
Data Filling wit Flash Fill
Data Shorting , Filter and Selection Concept
Data Analyzing with Pivot
Recognized Pivot Table
Relational Pivot
Reporting with Chart
Insert Other Application in Excel Sheet

Concept of Formulas Inserting
Logical Formulas Use
Working with Text Formulas
Working With Date & Time Formulas
Data Lookup with VLookup,HLookup,Match,
Index, using Array
Mathematics Calculation
Database Formulas
Informational Formulas
Financial Formulas
Array formulas
Formulas Nesting
Formulas Tricks
Data Import Other Database
Data Import Access Database
Data Connection with SQL Server 2012
Data Import from Webs and FTP
Data Clean Hansi and Advance Filter
Validation and What-if-Analysis
SubTotal

Learn Complete Excel , VBA Macros , Report Automation and Dashboard

Level : - 2 (Report Automation and Dashboard Reporting with Dashboard)

Advance Conditional Formation
Array Formulas
Formulas Nesting
Miscellaneous Formula Techniques
Performing With Array Formulas
Report Automation Sample
Understanding the Series Formulas
Creating Links to Cells For Title,Axis,Labels and Text
Charting Progess Toward a Goal
Creating a Gauge Chart
Displaying the Conditional Colors
Creating Comparative Histogram
Creating a Grant Chart
Ceating a Box Plot
Handling Missing Data
Chart with Access and SQL
Chart with Form Cantrol Buttons
Interactive Dashboards using PowerPoint and Excel
Introduction to Dashboards

Dashboard Background
Dashboard Elements
Interactive Dashboards
Type of Reporting in India
Reporting Analyst
Indian print media reporting
audit report
Accounting MIS Reports
HR Mis Reports?
MIS Report Preparation Supplier, Exporter
Data analysis
Costing Budgeting Mis Reporting
MIS Report for Manufacturing Company
MIS Reporting For Store and Billing
Product Performance Report
Member Performance Report
Customer-wise Sales Report
Collections Report
Channel Stock Report
Prospect Analysis Report
Calling Reports
Expenses Report
Stock controller MIS reporting





Advance Excel & MIS Reporting With VBA Macros

Level 1 : - 20 Hours ( 4000 /-)
Level 2 : - 15 Hours( (3500/-)
Level3 : - 35 Hours ( 6000/)
All 1,2,3 : - 65 Hours ( 10,000/-)

L

Training By Mr. Sujeet Kumat (MCA and 10 year Working Expr.)

Excel 2013 VBA Macros

Online & Offline

How to use the Visual Basic (VBA) Editor and its debugging tools
Complete review of the VBA language (Subs, Functions, variables, arrays, loops, logic...etc)
How to command Microsoft Excel using VBA. Also discussed is how control Word and PowerPoint
How to use Microsoft Excel VBA to analyze data on single and multi worksheets
How to open and close workbooks and text files
How to use Excel VBA to perform calculations on data
How to create summary sheets using VBA
How to create basic dashboards in Microsoft Excel using VBA
How to use Excel VBA to fill in Excel forms on the worksheet from text file data and workbook data
How to manage Excel models, strategy and layout using Excel and VBA
How to create and format single and multiple charts using VBA
Using VBA to create report generation tools in Microsoft Word and Microsoft PowerPoint using Excel VBA
How to use Excel VBA to build your own custom worksheet functions
How to use the Visual Basic Macro Recorder and interpret its recordings
How to download data from the web using VBA
An advanced review of the Excel VBA language
Advanced VBA data processing techniques for multi worksheets and multi workbooks
Advanced summary worksheet construction in Excel using Excel VBA
Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA
How to read text files using VBA.
Advanced VBA programming techniques for creating multiple charts from multiple data sheets
How to create advanced business user interfaces on worksheets using ActiveX controls, VBA and graphics
Advanced excel dashboard construction
How to create and use userforms in VBA (wizards)
How to create event driven programs using VBA
Advanced VBA error protection techniques
How to create custom toolbars and menus to run your VBA code
How to communicate with databases using DAO and ADO in VBA and how to download data from the web using VBA
Advanced VBA techniques for communicating with other languages and programs





Overview of how Microsoft Visual Basic (VBA) and Excel are used in business problems
VBA Editor review including using the VBA debugger and the purposes of VBA projects, modules and procedures
Excel macro language review (VBA) including variables, data types, constants, arrays, operators, expressions, loops, logic decisions and calling
Overview of commanding Excel using VBA including a discussion of objects, properties and methods
How to analyze business data on single Excel worksheets using loops and logic.
How to load Excel forms on the worksheet using loops and logic
Model management, layout and strategy using Excel and VBA
How to create charts using VBA


Excel VBA Power Programming For VBA Macros

How to analyze data on multi worksheets and build summary sheets
How to access the Windows file and folder system to open and close workbooks and text files being processed
How to protect your code against errors
How to use Excel and VBA to create basic dash boards
How to create your own custom business worksheet functions in VBA
How to create basic report generation tools using Excel VBA, Microsoft Word and PowerPoint
How to use the Excel Visual Basic macro recorder to record Excel tasks in VBA and then interpret the code
How to download data (stock market report, historical tables...etc) from web pages automatically
How to automate the data analysis tool pack add-in like regression analysis using VBA


Level—3

Advance Excel & MIS Reporting With VBA Macros

Beginning Excel VBA Training

Microsoft Excel VBA language overview
Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA
How to read text files using VBA.
Advanced VBA data entry, data processing and data summation techniques for multi worksheet and multi workbook problems
Advanced techniques to reconcile data in Excel using Excel VBA
Advanced VBA programming techniques for creating multiple charts from multiple data sheets
How to control drawing shapes, ActiveX controls and Excel's coordinate system with VBA (Worksheet Form Construction)
How to create VBA events for action driven applications in Microsoft Excel

How to use graphics, userforms, drawing shapes, ActiveX controls and Excel VBA to create advanced dashboards in Excel
Advanced command of Microsoft Word and PowerPoint using Excel VBA (report generation tools)
How to command databases using DAO, ADO and OLE DB in VBA
Introduction to using ADO OLE DB to query workbooks and text files
How to distribute your Excel programs
How to control other languages like Perl and C

Advanced Excel VBA Training

How to develop business user interfaces on the worksheet using ActiveX controls and Excel VBA
VBA wizard overview
Overview of using userforms to create business wizards
How to create userforms in VBA
How to create controls and graphics on userforms
How to command userforms and their ActiveX controls with VBA
Excel VBA wizard design tips
How to create toolbars and menus to control your VBA wizards
How to control Excel’s toolbar and menu system with VBA

Level—3

Advance Excel & MIS Reporting With VBA Macros

Excel VBA Power Programming For VBA Macros

Excel VBA Macros

35 Hours

Mon– Fri and SAT-Sun
Free : - 6000/-


Key Takeaways

Level— 1
Advance Excel with Formulas
Excel Application Setting
Paste with Calculation
Advance Custom Formatting
Use Formulas in Conditional Formatting
Excel Protection System
Data Filling wit Flash Fill
Data Shorting , Filter and Selection Concept
Data Analyzing with Pivot
Recognized Pivot Table
Relational Pivot
Reporting with Chart
Insert Other Application in Excel Sheet

Concept of Formulas Inserting
Logical Formulas Use
Working with Text Formulas
Working With Date & Time Formulas
Data Lookup with VLookup,HLookup,Match,
Index, using Array
Mathematics Calculation
Database Formulas
Informational Formulas
Financial Formulas
Array formulas
Formulas Nesting
Formulas Tricks
Data Import Other Database
Data Import Access Database
Data Connection with SQL Server 2012
Data Import from Webs and FTP
Data Clean Hansi and Advance Filter
Validation and What-if-Analysis
SubTotal

Learn Complete Excel , VBA Macros , Report Automation and Dashboard

Level : - 2 (Report Automation and Dashboard Reporting with Dashboard)

Advance Conditional Formation
Array Formulas
Formulas Nesting
Miscellaneous Formula Techniques
Performing With Array Formulas
Report Automation Sample
Understanding the Series Formulas
Creating Links to Cells For Title,Axis,Labels and Text
Charting Progess Toward a Goal
Creating a Gauge Chart
Displaying the Conditional Colors
Creating Comparative Histogram
Creating a Grant Chart
Ceating a Box Plot
Handling Missing Data
Chart with Access and SQL
Chart with Form Cantrol Buttons
Interactive Dashboards using PowerPoint and Excel
Introduction to Dashboards

Dashboard Background
Dashboard Elements
Interactive Dashboards
Type of Reporting in India
Reporting Analyst
Indian print media reporting
audit report
Accounting MIS Reports
HR Mis Reports?
MIS Report Preparation Supplier, Exporter
Data analysis
Costing Budgeting Mis Reporting
MIS Report for Manufacturing Company
MIS Reporting For Store and Billing
Product Performance Report
Member Performance Report
Customer-wise Sales Report
Collections Report
Channel Stock Report
Prospect Analysis Report
Calling Reports
Expenses Report
Stock controller MIS reporting





Advance Excel & MIS Reporting With VBA Macros

Level 1 : - 20 Hours ( 4000 /-)
Level 2 : - 15 Hours( (3500/-)
Level3 : - 35 Hours ( 6000/)
All 1,2,3 : - 65 Hours ( 10,000/-)

L

Training By Mr. Sujeet Kumat (MCA and 10 year Working Expr.)

Excel 2013 VBA Macros

Online & Offline

How to use the Visual Basic (VBA) Editor and its debugging tools
Complete review of the VBA language (Subs, Functions, variables, arrays, loops, logic...etc)
How to command Microsoft Excel using VBA. Also discussed is how control Word and PowerPoint
How to use Microsoft Excel VBA to analyze data on single and multi worksheets
How to open and close workbooks and text files
How to use Excel VBA to perform calculations on data
How to create summary sheets using VBA
How to create basic dashboards in Microsoft Excel using VBA
How to use Excel VBA to fill in Excel forms on the worksheet from text file data and workbook data
How to manage Excel models, strategy and layout using Excel and VBA
How to create and format single and multiple charts using VBA
Using VBA to create report generation tools in Microsoft Word and Microsoft PowerPoint using Excel VBA
How to use Excel VBA to build your own custom worksheet functions
How to use the Visual Basic Macro Recorder and interpret its recordings
How to download data from the web using VBA
An advanced review of the Excel VBA language
Advanced VBA data processing techniques for multi worksheets and multi workbooks
Advanced summary worksheet construction in Excel using Excel VBA
Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA
How to read text files using VBA.
Advanced VBA programming techniques for creating multiple charts from multiple data sheets
How to create advanced business user interfaces on worksheets using ActiveX controls, VBA and graphics
Advanced excel dashboard construction
How to create and use userforms in VBA (wizards)
How to create event driven programs using VBA
Advanced VBA error protection techniques
How to create custom toolbars and menus to run your VBA code
How to communicate with databases using DAO and ADO in VBA and how to download data from the web using VBA
Advanced VBA techniques for communicating with other languages and programs




Overview of how Microsoft Visual Basic (VBA) and Excel are used in business problems
VBA Editor review including using the VBA debugger and the purposes of VBA projects, modules and procedures
Excel macro language review (VBA) including variables, data types, constants, arrays, operators, expressions, loops, logic decisions and calling
Overview of commanding Excel using VBA including a discussion of objects, properties and methods
How to analyze business data on single Excel worksheets using loops and logic.
How to load Excel forms on the worksheet using loops and logic
Model management, layout and strategy using Excel and VBA
How to create charts using VBA


Excel VBA Power Programming For VBA Macros

How to analyze data on multi worksheets and build summary sheets
How to access the Windows file and folder system to open and close workbooks and text files being processed
How to protect your code against errors
How to use Excel and VBA to create basic dash boards
How to create your own custom business worksheet functions in VBA
How to create basic report generation tools using Excel VBA, Microsoft Word and PowerPoint
How to use the Excel Visual Basic macro recorder to record Excel tasks in VBA and then interpret the code
How to download data (stock market report, historical tables...etc) from web pages automatically
How to automate the data analysis tool pack add-in like regression analysis using VBA


Level—3

Advance Excel & MIS Reporting With VBA Macros

Beginning Excel VBA Training

Microsoft Excel VBA language overview
Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA
How to read text files using VBA.
Advanced VBA data entry, data processing and data summation techniques for multi worksheet and multi workbook problems
Advanced techniques to reconcile data in Excel using Excel VBA
Advanced VBA programming techniques for creating multiple charts from multiple data sheets
How to control drawing shapes, ActiveX controls and Excel's coordinate system with VBA (Worksheet Form Construction)
How to create VBA events for action driven applications in Microsoft Excel

How to use graphics, userforms, drawing shapes, ActiveX controls and Excel VBA to create advanced dashboards in Excel
Advanced command of Microsoft Word and PowerPoint using Excel VBA (report generation tools)
How to command databases using DAO, ADO and OLE DB in VBA
Introduction to using ADO OLE DB to query workbooks and text files
How to distribute your Excel programs
How to control other languages like Perl and C

Advanced Excel VBA Training

How to develop business user interfaces on the worksheet using ActiveX controls and Excel VBA
VBA wizard overview
Overview of using userforms to create business wizards
How to create userforms in VBA
How to create controls and graphics on userforms
How to command userforms and their ActiveX controls with VBA
Excel VBA wizard design tips
How to create toolbars and menus to control your VBA wizards
How to control Excel’s toolbar and menu system with VBA

Level—3

Advance Excel & MIS Reporting With VBA Macros

Excel VBA Power Programming For VBA Macros

Excel VBA Macros

35 Hours

Mon– Fri and SAT-Sun
Free : - 6000/-

Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask

Showing 1 to 10 of 44
A

Aquib 26/05/2016

Sir,
where i am join offline classes and other quires also

0 0

Answer

You can add upto 6 Images

A

Amit 02/08/2014

Kindly provide the contact details

0 0

Answer

You can add upto 6 Images

U

manoj kapoor 28/07/2014

Please Provide Your Add and Mob No....

0 0

Answer

You can add upto 6 Images

U

Pravesh Kumar 13/06/2014

Counsel me i want to do this course.

0 0

Answer

You can add upto 6 Images

U

vikas 04/06/2014

Hi, I would like to join the level 2and level 3 course. Please let me know the batch start date and timings.

0 0

Answer

You can add upto 6 Images

U

chandra shekar 28/05/2014

Dear Sir,

Please provide me contact no.

0 0

Answer

You can add upto 6 Images

U

Raju 12/05/2014

I want to join this course.
Please provide your contact details.
Thanks you

0 0

Answer

You can add upto 6 Images

U

Arvind Kumar 11/05/2014

Hi

Kindly arrange a call back as I want to do this course.

0 0

Answer

You can add upto 6 Images

U

Abhay 11/05/2014

I would like to Know the classes timing & place.

0 0

Answer

You can add upto 6 Images

U

ANKIT SRIVASTAV 26/04/2014

I want to do course of vba in excel and i registered to your site many times but i dint get any respond.

0 0

Answer

You can add upto 6 Images


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer


12 Year Working with 7 MNC at Delhi as Data Analysis
Seats Left-

Students Interested 5

Course Id: 4515