MIS and Data Analytics Training – Classroom and Online
Advanced Excel Training, VBA, MS Access, SQL and Business Analytics.
Excelcrazy, Advanced Excel training program and VBA classes is designed to make you awesome by teaching formulas, charting, formatting, data analysis, dashboards and automation tricks(Excel VBA). Excel Crazy is the most customized and personalized Advanced Excel training in Gurgaon. Unlike other conventional training centers, we offer Beginner level, Intermediate level and Advanced level courses based on your convenience and requirements. Our training methodology is simple and easy to understand. Our training courses will show you how to use Excel better, faster and more efficiently. We are specialists in providing Advanced Excel Training for Professionals.
Classes: Weekends Only
Duration: 12 Weekends
Projects: Real time Projects
Location: M3, The Mentoring Hub, OLD DLF Colony, Gurgaon
Course Fee: 15,000/-
|Advanced Excel||VBA||MS Access||SQL|
|Introduction to Excel||Introduction to VBA||What are Databases?||SQL Basics|
|Sorting and Filter||Variables and Operators||Develop Query||DDL|DML|DCL|DQL|
|Formulaes||Conditional Statements||Use Query||Import|
|Name Ranges||Loops and logics||Create and Modify Tables||Export|
|Managing Tables||Running Programes||Form Designing||Join|
|Working with Charts||Userform Designing||working with Tables||Truncate|
|Working with Pivot Tables||Active X Controls||Report Designing||Database Keys|
|Form Controls||Advanced Form Controls|
|Dashboard Designing||Well behaved codes|
|Macros Recording||Menus and Toolbars|
|Working Across Applications|
|Real Time Projects|
Excel 2010 Dashboard Designing Course – Recorded ($30)
Contact US: +91-9582876837
1) Excel 2013 Power Programming with VBA book by John Walkenbach:
This is my favourite book for VBA. It covers all the excel VBA topics and with good examples. I read this book most of the time to share the examples.
2) Excel Dashboards and Reports by John Walkenbach and Michael Alexander.
This book mainly focused on Excel Dahsbaord designing tricks and reporting.
3) Data Smart: Using Data Science to Transform Information Into Insight by John W. Foreman
I have just completed this book and this is for those who already understand the basic of excel and keen to learn about advanced statistical.