Cart List

Final Price : 0

Certification in Advanced Excel,MIS Reports and Data Analysis with AI

Course Enquiry


Please fill the below form.Our representative will call you for more details.

Course Enquiry


Please fill the below form.Our representative will call you for more details.

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

This course will help you to develop your excel skills from basic to advanced.People working in all the domains like Finance,MIS,Operations,HR,Marketing,IT etc need to having good skills in excel and this course gets the task done.

Course Highlights:

1) All lectures will be conducted live online.
2) You will learn from expert faculty.
3) You will also get recordings of the lectures to revise.
4) Access to our prerecorded course will be given for 1 year.
5) Certification will be given after completion of course by mail.

Upcomming Batches


Batch Date : 18 May 7:00 to 9:30

Duration : (10 Weeks) SAT & SUN

Register

Trainer

Babita George

Certified Microsoft Excel Expert

She has 25+ years experience as trainer for MS Excel (Basic, Advanced & Macros with VBA), MS Office and MS Access.Her vast experience in this field enriches learning expereince of her students as she includes many exmaple from real time projects she did during her career.
Ranjit Kate

Professional Trainer

Ranjit Kate is a renowned for his unique teaching style which focuses on practical teaching. He has conducted 500 plus live online training in India and internationally.He has experience of 12 plus years into Data Analysis,Finance,Taxation and MIS reporting training.He has also conducted many corporate trainings globally.He is Microsoft Certified Power BI Data Analyst.

Features

Expert Faculty

Learn from expert and experienced faculty in Advanced excel and MIS.

Get Certified

Get certified in Advanced Excel and MIS reports.

Learn from Basic to Advanced

Make basics good and move to advanced.


Learn MIS

Learn on variety of reports like Sales,finance,inventory etc.

Learn from Basic to Advanced

Learn from Basic to Advanced Make basics good and move to advanced.

Boost your career

Boost your career with excel skills.


Certification

Excel_Live_Certificate

Reviews

user

Reshmi Posted on 13 Sep 2023


The class was really helpful for me in doing my work easily. Excel shortcuts and other Excel equations.

user

Maente Skosana Posted on 01 Nov 2022


The course was suitable for people who have no knowledge of Excel and until people who are advance in their knowledge of Excel. It is empowering and provides tools to move up your understanding no matter where you are. The delivery was easy to understand and covering important topics in Excel. My understanding of Excel and application thereof has never been the same. I am grateful for taking this course...Thank you so much

user

Ravi Kumar Naidu Posted on 31 Oct 2022


Excellent training methodology

user

B SATHYAKUMAR Posted on 18 Oct 2022


Very powerful and simplify during the teaching session. i very thankful to faculty. I suggest to new people who are joined this course on growing help better future to the next level.

user

Aman Abdulla Bebal Posted on 16 Oct 2022


Mam the way you teach us was awesome, and i am glad that you are my coach.....

user

Mohammed Aaquib Tauheed Posted on 12 Oct 2022


Training was excellent!!

user

Kantharaju D Saganashetty Posted on 02 Sep 2022


it is an excellent course and very well delivered with good skill and material. faculty is very good and having good teaching skills. thanks to techcraft team

user

Sudipto Panja Posted on 02 Sep 2022


100% satisfied, very knowledgeable trainer, very useful course materials, I will strongly recommend this course to anyone who want to advance in their careers.

user

Sona Arjun Posted on 10 Jul 2022


Very helpful course to make our work easier and well organized classes

user

Mujeeb Posted on 10 Jul 2022


The sessions were useful it helps us a lot.Faculty Jayashree Tawari, she was took classes in the details of every session. Satisfied with the course.. and it helps us a lot in the future..Thankyou.

user

Ramu Neelagandan Posted on 30 Jun 2022


Faculty is excellent in explaining the concepts with live demonstration of concepts and i am interested to join future courses in Excel.

user

Ramu Neelagandan Posted on 30 Jun 2022


Faculty is excellent in explaining the concepts with live demonstration of concepts and i am interested to join future courses in Excel.

user

KRISHNAMOORTHY GOPAL Posted on 25 Jun 2022


Fully satisfied with the Course and the method of teaching was very good.

user

Madhan Narayanan Posted on 20 May 2022


Online Certificate in Advance Excel , MIS Report and Data Analysis course is very useful . Faculty is very good in explaining the concepts with live demonstration of concepts and i am interested to join future courses in Excel.

user

Dheva Ranjan Posted on 28 Jan 2022


The session was really wonderful, faculty is highly knowledgeable. Ms.Babitha has much patience, did step by step illustrations, confirmation from the participants shows the perfectness and expertise.

user

Prasad Parte Posted on 29 Jan 2020


Continue this type of service in future to grow every individual.

user

Dattatray Jagade Posted on 29 Jan 2020


I was satisfied with the knowledge i got from course.Faculty was best.

user

FAISAL BAIG Posted on 29 Jan 2020


Course content was very relevant to reports used in industry.

user

Franky DSouza Posted on 29 Jan 2020


Teaching method and Course content are very good at Techcraft.

Curriculum

Certification in Advanced Excel,MIS Reports and Data Analysis with AI:

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 Date formulas.

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.

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

6.Advanced Charting:

Creating Multiple Chart Type,Primary, Secondary Chart ,Trend line Charting, Spark Line,Dynamic Charting Techniques.

7.Logical Function Or Booleans:

Understanding basic logical functions like IF,OR,AND,COUNTIF,IFS,IFERROR to building complex logical formulas by nesting two or more functions.

8.Data Cleaning:

Data cleaning is first step to do on every report.Techniques like identifying error and blanks,finding and removing duplicates,text to column methods,left,right and mid formulas,trim,case change are included in this topic.

9.Macros Application:

Developer tab; Visual Basic Editor (VBE) Record & Run a Macro.Introduction to VBA code.

FAQs

Will you learn from basic to advanced excel?

Yes,you will start learning from basic and then you will be taught advanced techniques.

Are the faculties expert?

Yes,all the faculties are expert and experienced faculties in excel and reporting.

Which certificate you will get on course completion?

You will get Certificate in advanced excel and MIS report.

Which Microsoft Office version should be used for practice?

Microsoft Office version 2013,2016,2019,Office 365 should be used for practice.

What if you miss lecture?

You can attend missed lecture in other batch.(Upto 2 lectures)

Will you get access to recorded lectures for revision?

Yes, you will get access to more than 100+ recorded lectures for revision from our website and mobile application.

What are the system requirements on your computer to attend live lectures?

1) Use updated Google Chrome browser for session. 2) Use Microsoft office version 2010,2013,2016,2019,office 365. 3) Use good audio equipment and run cross check on audio equipment.

What are internet speed requirements to attend live online lecture?

Use internet with good speed (Download speed : more than 15 mbps, Upload speed : more than 3 mbps) ( Do no use mobile hot spot or dongle.)

Batch Date : 18 May 7:00 to 9:30

Duration : (10 Weeks) SAT & SUN

Register

Register for Demo

Please fill the below form.Our representative will call you for more details.