Live Online Certification in Advanced Excel & MIS Reports (International Batch)

(11 customer reviews)



We conduct 2 Months (Only Friday/Only Saturday) Certification in Advanced Excel & MIS Reports   which is very meticulously developed Advanced Excel course helps you to develop advanced skills in excel  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

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 every Friday,

2)  Certificate

3) Excel files of the course content.

1) Basics of Excel:
Revisiting Excel Basics, Writing Basic Formula like Add, Subtract, Multiply, Divide, Logical &Text
formulas.Excel Operators. BODMAS/Formula error checking.Excel Sheet Formatting. Working with
Dates – Concept,Correction techniques Dateformulas: TEXT(), EOMONTH(),EDATE(), DATE().

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 – When & Why? VLOOKUP() with MATCH()
2-D lookup.INDIRECT() + Range Naming for 3-D lookup INDEX() and 2 MATCH() – reverse lookup

4) Pivot Tables:
Creating, Formatting Simple PivotTables.Page Fieldin a PivotTable.Formatting a PivotTable.Creating/
Modifying a PivotChartIF(), Nested IFs, AND(), OR() Combo Logics; IFERROR().Building Complex Formulas.

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:
Creating Multiple Chart Type,Primary, Secondary Chart ,Trend line Charting, Spark Line,Dynamic
Charting Techniques.

8) Protection,Import and Export of Data:
Sharing Workbooks & Tracking Changes, Protectingsheets / workbooks / Files. Importing Data from
Text Files/ Web, Exporting Data.

9) Macros Application:

Developer tab; Visual Basic Editor (VBE) Record & Run a Macro.

10) Data Cleaning:
Learn Data Cleaning Techniques.


Ranjit Kate
MBA Finance
Faculty has 5 years experience in Advanced excel training and MIS reporting.

Sample Certificate :

Advanced Excel Certificate

Course Introduction:

11 reviews for Live Online Certification in Advanced Excel & MIS Reports (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.

Add a review

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