Course with develop your advanced skills in Excel and MIS Reporting.
Available class for :
Please fill the below form.Our representative will call you for more details.
Course Price
Certified Microsoft Excel Expert
Professional Trainer
Learn from expert and experienced faculty in Advanced excel and MIS.
Get certified in Advanced Excel and MIS reports.
Make basics good and move to advanced.
Learn on variety of reports like Sales,finance,inventory etc.
Learn from Basic to Advanced Make basics good and move to advanced.
Boost your career with excel skills.
The class was really helpful for me in doing my work easily. Excel shortcuts and other Excel equations.
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
Excellent training methodology
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.
Mam the way you teach us was awesome, and i am glad that you are my coach.....
Training was excellent!!
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
100% satisfied, very knowledgeable trainer, very useful course materials, I will strongly recommend this course to anyone who want to advance in their careers.
Very helpful course to make our work easier and well organized classes
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.
Faculty is excellent in explaining the concepts with live demonstration of concepts and i am interested to join future courses in Excel.
Fully satisfied with the Course and the method of teaching was very good.
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.
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.
Continue this type of service in future to grow every individual.
I was satisfied with the knowledge i got from course.Faculty was best.
Course content was very relevant to reports used in industry.
Teaching method and Course content are very good at Techcraft.
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.
Creating Absolute/Mixed References. Problems with Absolute/Relative Cell Referencing.
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.
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.
Automatic row-wise Subtotal,Gridlines,Data Validation (list),Cell-Range Naming,Grouping.Build Business reports like Sales,Inventory,Salary report,dashboards etc.
Creating Multiple Chart Type,Primary, Secondary Chart ,Trend line Charting, Spark Line,Dynamic Charting Techniques.
Understanding basic logical functions like IF,OR,AND,COUNTIF,IFS,IFERROR to building complex logical formulas by nesting two or more functions.
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.
Developer tab; Visual Basic Editor (VBE) Record & Run a Macro.Introduction to VBA code.
Yes,you will start learning from basic and then you will be taught advanced techniques.
Yes,all the faculties are expert and experienced faculties in excel and reporting.
You will get Certificate in advanced excel and MIS report.
Microsoft Office version 2013,2016,2019,Office 365 should be used for practice.
You can attend missed lecture in other batch.(Upto 2 lectures)
Yes, you will get access to more than 100+ recorded lectures for revision from our website and mobile application.
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.
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.)
Copyright © 2019 Kate Education and Consultancy Services Pvt Ltd
Register for Demo