Excel,Reports,Data AnalysisExcel,Reports,Data Analysis

Certification in Advanced Excel,MIS Reports and Data Analysis

(21 customer reviews)

9,500.00

Description

We conduct 1.25 Months (Only Saturday-Sunday) 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.

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

Duration: 1.25 Months (Only Saturday-Sunday)

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

Faculty:

Jayashree Tawari
Trainer and Educator
She has 10+ years experience as trainer for Advanced Excel, Professional PowerPoint, Power BI

Ranjit Kate_Trainer

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

Sample Certificate :

 

 

 

 

 

 

 

 

 

 

21 reviews for Certification in Advanced Excel,MIS Reports and Data Analysis

  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.

  11. shitalkumarl

    i have competed advance excel course.
    easy way teach advance excel. in this course ,cover all formula in excel

  12. surekha jagtap

    Good lectures, I have learn more formulas and techniques
    Thanks to team.

  13. Amit Durgade

    It was great experience with techcraft.

  14. PRASHANT KADAM

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

  15. 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

  16. 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 !

  17. Anilkumar V N

    This course is very helpful and will help for carrier development. Excellent training and teaching method

  18. Sameer Thokur

    Overall experience was good, learned some new and advanced features in excel….

  19. RAMESH S

    Its a good and excellent sessions we had on MS Excel. Explained in a manner that easy to understand and practice then use it in official works for MIS and various reporting.

  20. Amol

    All sessions are explained in a clear manner. It is really helpful to enhance my excel skills.

  21. Harsha Iyer

    fantastic course…got clarity

Add a review

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