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 ExcelVBAMS AccessSQL
Introduction to ExcelIntroduction to VBAWhat are Databases?SQL Basics
Sorting and FilterVariables and OperatorsDevelop QueryDDL|DML|DCL|DQL
FormulaesConditional StatementsUse QueryImport
Name RangesLoops and logicsCreate and Modify TablesExport
Managing TablesRunning ProgramesForm DesigningJoin
Working with ChartsUserform Designingworking with TablesTruncate
Working with Pivot TablesActive X ControlsReport DesigningDatabase Keys
ProtectionError Handling
Form ControlsAdvanced Form Controls
Dashboard DesigningWell behaved codes
Macros RecordingMenus and Toolbars
Working Across Applications
Real Time Projects

Excel 2010 Dashboard Designing Course – Recorded ($30)


Contact US: +91-9582876837

My Favorite Books:
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.


  1. Kara
    September 1, 2015 @ 1:16 pm

    Hi Lokesh,
    I would like to thank you for sharing your experience.
    Would really appreciate If you can help me to understand? How can we use Advanced Excel in BI?



    • Lokesh Paliwal
      September 2, 2015 @ 8:28 pm

      Thanks Kara,

      Yeah excel 2013 Offer lots of BI features and functionality that easily used to gather data and turn it into meaningful information.

      And the new addition of Power BI tools( Power Query and Power Pivot) helps a lot to get involved into BI. Hope this helps.


  2. Raghu
    August 19, 2015 @ 1:24 am

    Hi Lokesh, I am working on file which have about 500 records. I want to copy filtered data from one to sheet to another.

    I have recorded the macros for this but it’s copying the filtered rows too. Any help most appreciated.

    Sub Macro1()
    Range(Selection, Selection.End(xlDown)).Select
    End Sub


    • Lokesh Paliwal
      August 20, 2015 @ 1:27 am

      Hi Raghu,

      Try this one

      Sub CopyPasteFiltered()
      Dim Rng As Range
      Set Rng = worksheets(“Sheet1″).Range(“A1:N1″).SpecialCells(xlCellTypeVisible)
      Rng.Copy Worksheets(“Sheet2″).Range(“B1″)
      End Sub

      xlcellTypeVisible property select all the visible cells.


  3. neel
    August 18, 2015 @ 7:28 pm

    Hi , lokesh,

    I have recently got a profile of category manager in my company , i have to do quality analysis of sales,products ,best sellers ,planning and forecasting ,financial analysis, and inventory control and all the high level analysis work related to products , i have reasonable knowledge of excel , but want to learn more advance excel , please let me know about advance course i am comfortable in morning hours only.
    you can contact on my email id .


    • Lokesh Paliwal
      August 20, 2015 @ 1:03 am

      Hi Neel, details sent on your ID.

      Upcoming batches – 22nd Aug’15(Classroom) and 1st Sept’15(Online Classes).


  4. Pritam Kumar
    August 12, 2015 @ 11:51 pm

    Hi Lokesh,

    I am looking for Excel training. Can you please send me details.

    My Email ID- pritamamit.kumar9@gmail.com

    Thanks & Regards,


  5. Jyoti Jain
    March 5, 2015 @ 12:08 pm


    We are looking for MIS Executives. Please find the JD as below:

    Job Description:
    1. Good knowledge of MS- Office
    2. Good typing skills & Candidate should have decent analytical skills.
    3. Worked on Data Management
    4. Good Knowledge on advanced excel.
    5. Good power point presentation skills.
    6. Knowledge on use of formulas viz Vlookup, conditional formatting, match, Goal Seek if, pivot table, chart, macros, concatenate.

    Key Skills : Proficient in MS Office, Advanced Excel,Formulas,Power Point Presentation, Good Organisational Skills, Efficient coordination skills, candidate having good analytical skills, Worked on Data Management, knowledge on windows based application would be an advantage.
    Years of Exp. 0 -1 year
    Qualification: Graduate
    Salary Range: 7-12k
    Location: Gurgaon

    Please do provide us with some references at the earliest since the requirement is urgent.

    Best Regards,

    Jyoti Jain
    Manager – Human Resource
    V-6/5 | LGF | DLF City Phase III | Gurgaon | Haryana | 122002
    Cell: +919811963021| +91 (0) 124 410 8277 | +91 (0) 124 407 1277
    Email: jyoti.jain@agileitchannels.com
    Websites: http://www.agileitchannels.com; societyconnect.com; k12mart.com


  6. Hari Tej Singh
    August 28, 2014 @ 10:05 am

    I want data of “Sheet1” to be copied in “Sheet3”, manner of the copy is mentioned below. Please help

    1. Cells of “Sheet1” (B2, C2, D2, E2, F2, G2, H2) should be copied in “Sheet3”
    2. There should be a delay of 3 seconds.
    3. Increment the Row by 1 and now copy cells “sheet1” (B3, C3, D3, E3, F3, G3, H3) and then past it to next row of “Sheet3”.

    Note: – I don’t want to copy row of “sheet1” to “sheet3” . I want to copy cell.

    I want to past the all data Cell wise of “sheet1” to Cell wise of “sheet3” with delay of 3 seconds in between of two rows.

    Example of Data in “Sheet1” which need to be copied to “sheet3” cell wise is mentioned below. These record can go on up to 2500 or 3000. or may be 700 or 1500.

    980.26 979 8/5/2014 826.727 155472 202180 30790000
    980.25 978.4 8/5/2014 831.114 156734 203501 30798750
    980.24 979 8/5/2014 837.743 160128 203220 30798750


  7. vinay kumar naudiyal
    January 21, 2014 @ 3:14 pm

    I want to do excel and VBA macros training.


  8. Dinesh K Takyar
    October 15, 2013 @ 11:36 am

    Excellent website and demonstrations!


  9. Vinod Kumar Sharma
    October 10, 2013 @ 6:07 pm


    I am vinod and looking for advance excel training & VBA. Could you please get me some time table & fee structure.

    Can I pay a visit to your place?

    please reply



  10. Hiren Rathod
    September 25, 2013 @ 7:46 pm

    i want to create address book..
    please help me
    how to create simple address book in VBA/exl with useful buttons


  11. Shashikantshukla
    September 24, 2013 @ 10:52 am

    Myself Shashikant Shukla. I am working one of leading organisation. Now I am looking for VBA training program. I want know batches time and fee structure. If possible please send me all details on my given mail ID shasXXXXntshuklaXX@yahoo.com



    • Akash kumar Yadav
      September 25, 2013 @ 10:50 am

      Myself Akash Kumar Yadav. I am working one of leading organisation. I want know batches time and fee structure. If possible please send me all details on my given mail Id akash_kumarxxxx@yahoo.com


  12. Pankaj Gupta
    September 18, 2013 @ 1:44 pm

    Dear Lokesh

    I am VBA working with American Express, Gurgaon and i am looking Course we are 4-5 friends who are looking for this training.
    kinldy let me know class timings and fee with details of Course.

    you can get in-touch with me on +91-880213XXXX

    Pankaj Gupta
    Email- pankajXXXXXXX@yahoo.in


  13. Haridarshan Singh Rawat
    August 29, 2013 @ 9:09 pm

    Hi Lokesh

    This is Haridarshan working with a leading KPO in gurgaon, as data analyst. I am in search of advanced excel and VBA training to enchance my data analysis skills. I am based out of Dwarka, Sector 24, New Delhi.

    Could you please let me know when is your next batch starting.


    • Lokesh Paliwal
      August 31, 2013 @ 7:26 pm

      Hi Haridarshan, thanks for contacting excel crazy.
      Send me your email id and contact details at lokesh[at]excelcrazy[dot]com. I will forward to you the curriculum and next batch starting details.


Leave a Reply