Excelcrazy, Advanced Excel training program and VBA classes is designed to make you awesome by teaching formulas, charting, formatting, data analysis, dashboards & automation tricks(Excel VBA).Excel Crazy is the most customized and personalized Advanced Excel training centers in Gurgaon. Unlike other conventional training centers, we offer Beginner level, Intermediate level and Advanced level courses at your doorstep 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.
Contact Details: +91-9582876837 or Email at lokesh@excelcrazy[dot]com
Excelcrazy.com is the only center in the Gurgaon Delhi area that focuses solely on Microsoft Excel training. Our curriculum is designed and taught by a Excel Expert with real-world experience- providing only the most practical and useful examples.
About Lokesh Paliwal
I’m just an average guy who writes Excel and VBA code for a living.This is my personal blog. Excel and VBA are my thing, with a sprinkle of Access and Word here and there. My goal is to make you crazy about Excel and i do this by sharing whatever little I learn everyday. Follow this blog to learn more about Excel VBA and I hope you will like some of the content.I do provide Advanced Excel and VBA training in Delhi NCR region.
For more information regarding training program drop an email to: lokesh[at]excelcrazy[dot]com/09582876837.
If you love advanced excel articles and tips, let’s =Become(“A Friend”,”On Facebook”). Click on top facebook icon to like a page.
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.
|Course Type||Location||Date||Timming||Fee||Book a seat|
|Advanced Excel and VBA||DLF Phase 3, Gurgaon||30th May||1PM||Rs 10,000/-||09582876837|
Address: U1/6, DLF Pahse 3, Behind RBS Building, Gurgaon(Haryana). (5 minute walking from DLF Phase 3 Metro Station)
This course will help you to create dynamic, interactive charts in excel using excel form controls. In each exercise you will learn how to create customize charts in excel and create awesome reports in excel.
You will also get one course workbook and sample dashboard to do pratice in this course. In my sample workbook, you will also get the step by step guide to create the Interactive and dynamic charts in excel.
These tutorials will give you career-building skills that you can use to become better in making chart reports and more efficient at your job.
Also share it with your friends, enemies, loved ones, ex-girlfriends/boyfriends
To take this course, Click on the Hyperlink Interactive Charts in Excel.
- Using Excel Lists
- Creating a Lists
- Filtering, Auto Filter
- Advanced Filter
- Freezing Panes
- Totals and Subtotals
- Conditional Formatting
- Analysis by Goal Seek, Histogram
- Pivot Tables
- Recording Macros
- User Form Controls
- Object Oriented Programming
- Macro Security
- Protecting Applications
- Active X Controls
- Class Modules
- Writing Macros
- Loops and Logics
- Handling Errors
- Creating User Forms, Advanced Form Controls
- Programming Menus and Toolbar
- Working Across Applications