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 Faridabad. 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.
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
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 analysis. It’s a good book on how the analysis works 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