6,500.00

SKU: 006 Category:

Description

We conduct Advanced Excel & MIS course in classroom at Pune and across India Live online. which is very meticulously developed and helps you to develop advanced skills in excel,reporting  and grow in your career.

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

Duration: 1 Month ( Only Saturday & Sunday) or 2 Month (Only Sunday)

Dates : 1) 7th July 2019,Only Sunday  Time : 11 am to 2 pm

2) 13 th July 2019, Saturday and Sunday, Time : 5 pm to 8 pm

We will be Providing in Advanced Excel and MIS Course:

1) PC for Working

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.

Faculty:

 

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

 

 

Sample Certificate :

10 reviews for Certification Course in Advanced Excel & MIS Reports

  1. Sarika

    This course has really helped me to get expertise in excel.

  2. Kajal Mandhare

    Overall course was good, helped me to know some advance functions of Excel.

  3. Nandkumar Dnyanoba Bhujbal

    I have done this advance Excel course & found very good experience .

  4. nikhilprakash6

    It was a good experience.I have learned a lot of triks for MIS Reporting and formulas.online pre recorded video tutorials available.

  5. sandip Pawar

    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 !

  6. AshishKumar

    Thank you for Excellent teaching !

  7. omkar bhatmurgi

    Excellent teaching

  8. Dadaso Dhawale

    Thank you, Techcraft for good knowledge and best opportunity in new job for advance Excel and MIS . good teaching style in the excel.

  9. Rasika Wadkar

    Thank you to Techcraft.
    Good lectures which helped to be getting familiar with excel.

  10. Surekha

    Overall all lectures was good. helped me to know some advance functions of Excel.
    Thank you Tech Craft.

Add a review

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