Cart List

Final Price : 0

Have Queries? Ask us

+91 7489900567

Certification in Advanced Excel,MIS Reports and Data Analysis

Course with develop your advanced skills in Excel and MIS Reporting.

Available class for :

Live

Date	Day	Timing	Course Type	Location
29 Jan	(6 Weeks)SAT & SUN	Timings7:00:00 PM to 9:30:00 PM	Live	Online

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.

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.

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

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

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

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.

Sona Arjun Posted on 10 Jul 2022

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

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.

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.

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.

KRISHNAMOORTHY GOPAL Posted on 25 Jun 2022

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

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.

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.

Prasad Parte Posted on 29 Jan 2020

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

Dattatray Jagade Posted on 29 Jan 2020

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

FAISAL BAIG Posted on 29 Jan 2020

Course content was very relevant to reports used in industry.

Franky DSouza Posted on 29 Jan 2020

Teaching method and Course content are very good at Techcraft.

What if I miss a class?

"You will never miss a lecture at Techcraft! You can choose either of the two options:

View the recorded session of the class available in your LMS.
You can attend the missed session, in any other live batch."

What if I have queries after I complete this course?

Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

How soon after Signing up would I get access to the Learning Content?

Post-enrolment, the LMS access will be instantly provided to you and will be available for lifetime. You will be able to access the complete set of previous class recordings, PPTs, PDFs, assignments. Moreover the access to our 24x7 support team will be granted instantly as well. You can start learning right away.

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.

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

Jayashree Tawari

Corporate Trainer

She has 10+ years experience as trainer in Advanced Excel, Professional PowerPoint, Power BI. She has trained thousands of working professionals and have conducted many corporate training sessions.She is renowned for her unique teaching style.

Ranjit Kate

Professional Trainer

Ranjit Kate is a renowned trainer who conducts classroom as well as live online training in India and internationally.He has experience of 10 years into Data Analysis,Finance,Taxation and MIS reporting training.