Okebiz Video Search

Title:Data Ananalysis with Excel 2007 in Hindi(Excel Pivot Chart)

Watch Sample Video Recording of Live Class
About the Course
Today, many individuals and working professionals related to accounts, MBAs wish to learn Advance Microsoft Excel, VBA, Macro, Reporting, Access and many more advanced commands to get familiar with Excel and also to develop desired reports from the data. Also, there are various other advantages of Advance Excel that can be enjoyed by people who know how to make use of MS-Excel and excel formulas.
Topics Covered
1. Excel All Option and Command
2. Advance Formatting
3. Pivot Data Reporting and Advance Pivot Concept
4. More than 200 Excel formulas
5. Array Formulas
6. Array with VLookup, HLookup and more Formulas
7. Formulas Nesting
8. Other Data Connection (MS Access & SQL Server)
9. Dynamic Chart and Graph
10. Report Automation
11. Dashboard Reporting
12. Excel VBA Editor Concept
13. Coding object Model
14. Data type , LOOP, IF Else
15. Excel VBA Event and Formulas Making
16. User form
17. User form Connection
18. Outlook Mail Connection
19. CDO Gmail connection
20. Web Form Connection (VBA to Internet Explorer Connection)
21. Pivot and Chart VBA Event
22. Other Application and PowerPoint Connection
23. Menu bars and Add ins Creation
24. And More in Excel 2013
Level-1, - Official Excel Training
Level -- 2 -- Excel Advanced Formulas and Other Data Conectvity for Automation
Level -- 3 -- Excel Dashboard and Report Automation for MIS
Level -- 4 -- Excel VBA Macros Programming for Report Automation
Add on -- MS Access with SQL Statement and VBA Programming
Who should attend
Anyone who wish to make career in data analysis and MIS, Finance Professionals, Students from B.Com / Commercial Background, Administration Section, MIS Personals, VBA Programmer, Accounts Personal, Project Managers, Developers, Technical/ Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysis departments
Basic Excel Knowledge is mandatory to attend the course
Fee Details: -
• 1.Level 1 to 4 (Advanced Excel & MIS Reporting with VBA Macros) - 12,000/- INR
• 2.Level 1 to 3 (Advanced Excel & MIS Reporting) - 65,00/- INR
• 3.Level 4 (Excel VBA Macros Programming) - 6500/- INR
• 4.Complete(1 to 4 level) with MS Access15,000/- INR
Benefited of Our Training
*Get the 4 Days Demo Training Free
*Our Training is Personal Training
* only 3-5 Person in one Batch
* 100% Live and Practical's Training
* Received Every Classes Video Recording For Practice
* Job Helping Nature
* Help for Interview Preparation
Watch Sample Video Recording of Live Class
Advance Excel and MIS Training with VBA Macros
Sujeet Kumar Singh
Tel - 011-29967604, 8802579388


Download Server 1


Download Server 2


Alternative Download :

Excel 2016 Advanced Excel 2016 Advanced
38:45 | 262,796
Microsoft Access 2016 Tutorial: A Comprehensive Guide to Access - Part 1 of 2 Microsoft Access 2016 Tutorial: A Comprehensive...
11:43 | 353,863
Top 25 Excel 2016 Tips and Tricks Top 25 Excel 2016 Tips and Tricks
27:44 | 326,968
Word Beginner Tutorial Word Beginner Tutorial
55:07 | 179,344
How to build Interactive Excel Dashboards How to build Interactive Excel Dashboards
52:26 | 147,340
Data analyst interview tips | How to prepare for data analyst interview Data analyst interview tips | How to prepare fo...
21:42 | 27,089
Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards Excel for Accounting: Formulas, VLOOKUP & INDEX...
44:10 | 167,577
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1) Introduction to Pivot Tables, Charts, and Dashb...
14:48 | 930,618