Learners enrolled
1 Year Access
Certificate of Completion
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.
Get access to 100+ recorded videos for revision.
Boost your career with excel skills.
test
As a result of my certification course, I have gained a great deal of knowledge, and I appreciate their teaching method with proper practice and immediate clarification of doubts. The Techcraft team deserves a huge thank you. I wish them more success and a professional education for every student. Thank a lot Ms. Babita George.
It was excellent session and touched almost all major tools Ms excel provides;It only lacked in-depth study of the tools ...
Thanks for patiently explaining every step and making us understand in the simplest way. Very useful tricks and tips. Value for money.
It was amazing
It is very useful course, it makes our daily official tasks (database entries, preparing production, stock and sales reports) easier.
More Confident after attending the course. Highly recommend my friends. The teaching method is appreciable. Thank you so much and all the very best for Tech craft team.
Excellent training session
Satisfied with the training session and provided enough training modules for the practice.
100% satisfied.
The entire session was excellent and easy to understand. Appreciated the trainer for explaining the concepts clearly and going to basic details also for the participants queries.
Online Classes were organized in a disciplined manner and was punctual, very detailed and interactive with worksheets and practicals - I have already started using in daily office reports with more expertise and accuracy.
I had taken live online course in Advanced Excel & MIS reports.It helped me lot to get a new job.
Course and faculty was good but need more practice notes.
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.
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.
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.
Test Lesson Look up
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 for 1 year.
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.)
Register for Demo
Please fill the below form.Our representative will call you for more details.