Certification in Advanced Excel,MIS Reports and Data Analysis (International Batch)

(17 customer reviews)



We conduct 2.5 Months (Only Friday/Only Saturday) Certification in Advanced Excel MIS Reports and Data Analysis  which is very meticulously developed Advanced Excel course helps you to develop advanced skills in excel,reporting,data analysis and grow in your career.

Auidance : Advanced Excel Course is designed for international students specifically from United Arab Emirates,Middle East Countries,Singapore,Indonesia,Asian countries.

Call us on +91 9881196664 or mail to preetib@techcraftonline.com

International Price : $130

Duration: 2 Months (only Friday/Only Saturday)

Delivery Method : Live online classes

We will be Providing:

1)  Live Online lectures for 2 hours each session.

2)  Certificate

3) Excel files of the course content.

4) Recording of Live Session

5) Life time access for recorded course from our Website and Mobile App.

1) Basics of Excel,Formatting,Database
functions :

Excel Operators , Logical &Text formulas.,Formula error checking.Excel Sheet Formatting,Date and time functions,Database functions like DSUM,DAVERAGE,DCOUNT,DGET.

2) Relative,Absolute & Mixed Referencing:
Creating Absolute/Mixed References. Problems with Absolute/Relative Cell Referencing

3) Look up Functions:
VLOOKUP() – a practical perspective.VLOOKUP() w. TRUE and FALSE – When & Why? VLOOKUP() with MATCH()2-D lookup,HLOOK UP,INDEX() and 2 MATCH(),XLOOK UP

4) Pivot Tables, Pivot Charts & Power Pivot:
Creating, Formatting Simple PivotTables.Page Field in a PivotTable.Formatting a PivotTable.Creating/
Modifying a Pivot Chart.

5) Complex & Logical Formulas : IF(), Nested IFs, AND(),OR() Combo Logics; IFERROR().

6) MIS Reporting & Dashboard Techniques :
Automatic row-wise Subtotal,Gridlines,Data Validation (list),Cell-Range Naming,Grouping.Build
Business reports like Sales,Inventory,Salary report,dashboards etc.

7) Advanced Charting & Conditional Formatting :
Creating Multiple Chart Type, Primary, Secondary Chart ,Trend line Charting, Scatterplot, Conditional Formatting

8) Protection, Validation, Consolidation & Import of Data::
Protecting sheets / workbooks / Files. Importing, Consolidate, Data from Text Files/ Web.

9) Macros Application:

Developer tab; Record & Run a Macro,Understanding & Editing VBA Code of Macros.

10) Data Cleaning:
Learn Data Cleaning Techniques.

11) Data Analysis: What if Analysis,Forecast


Ranjit Kate_Trainer

Ranjit Kate
MBA Finance
Faculty has 10+ years experience in Advanced excel training,MIS reporting,Data Analysis and Finance.

Babita George_Excel Trainer

Babita George
Certified Microsoft Excel Expert
She has 10+ years experience as trainer for MS Excel (Basic, Advanced & Macros with VBA), MS Office and MS Access

Sample Certificate :












17 reviews for Certification in Advanced Excel,MIS Reports and Data Analysis (International Batch)

  1. Nilesh Dok

    Its a great way to learn. excellent

  2. Jalinder kamthe

    Great Experience.

  3. Anup Kadam

    I have learned lot of things from this courses. Also teaching method is very good. Its very easy way to learn all Excel formulas. I defiantly recommend to my friends to join this class. Thank you.



  5. Gopal Bharat Patil

    Microsoft Excel is powerful tool use for many professional and business activities. As a part of personnel interest I have joined Advanced Excel & MIS Report Course to Techcraft Institute which provides excellent Teaching Learning. Also fantastically guided by Ranjit Kate Sir. I am very much thankful to him.

  6. Yasmin Patel

    It was great learning with advanced excel ,hope this course will help me in my carrier,will continue watching and expect more helping ideas to students,in all good experience in learning,will definately recommend if some one willing to do it,idea of teaching is good.

  7. Sujata

    Good knowledge received from Advance excel and teaching methodology is really good and easy to understand



  9. Srushti Mandke

    co-operative staff, detail knowledge of course soft spoken really good method of teaching ,easy to understand and even teaching till you understand , Thank You

  10. Pratik Onkar

    Ranjit Sirs teaching is very good and he explains it in a very calm manner. Also gives personal attention to every student if anything goes wrong and make the students understand the topic. I have recieved good knowledge of excel from the basics as Ranjit sir covers the basics i.e from formulas. it’s a good course by Techcraft and also very useful for the professionals.

  11. Jayadeep

    Very Good Teaching By Ranjit Ji and very good supportive staff Nilam.

  12. Mayank Malhotra

    Thank you for a great course. Great presentation style with lots of opportunities to ask questions and talk about real examples which all made for a really enjoyable and informative course.” “This has more than met my expectations.” “A wonderfully practical course

  13. Emmanuel Cleatus

    Thank you TechCraft for wonderful course and teaching style is very good, its help me to increase my knowledge and its open me lot of Job opportunity. Thank You !

  14. Umer Farooq

    it was a really nice experience. the best things gives you the hands on practice on the same time.

  15. Mohith Asokan

    It was a nice experience to attend the classes, looking forward for advanced courses on VBA & Macros.

  16. Fuzail Ahmad

    Had a great journey of learning, it is going to boost our skills of data management.


    Practical sessions along with the course was helpful, would have preferred to have LMS and soft copies as well which were not available but recorded sessions are available which is helpful

Add a review

Your email address will not be published. Required fields are marked *