About the Course

This course will provide you everything which is important you need to know about macro (automation in excel) without knowledge of coding and Different basic and advanced techniques to create Visually Effective Dashboards.

You can learn it easily and quickly if it is taught correctly. Developed by a Chartered Accountant having 14+ year of Industry & Training experience.

 

What you will learn

Automation (Macro): In this competitive working environment, automation is the key to get success. Here you will learn Automation (Macro) in excel without even knowledge of coding.

Dashboard: This course teaches you to create well-designed Excel dashboards so you and your colleagues can see trends and make quick decisions informed by data. This Microsoft Excel Dashboard course comes with different advanced techniques that can be applied directly to your Excel reports.

 

Are there any course requirements or prerequisites?

  • A computer, tablet, or smartphone and an internet connection to watch the course

  • A laptop or computer for practice

  • We recommend to use Latest MS Office software always. For any other version check Microsoft Guidelines as they keep changing availalibility of functions & features in each version

 

Offer Ending Soon

 

This Course is Non-Refundable. For more details check our refund policy

 

Curriculum

Total: 45 videos Total time: 9 hours 22 min

About the instructor

A Chartered accountant by Profession with multiple years of Corporate and In-Practice experience.

He is an accomplished MS Excel keynote speaker, has trained over 1 lac individuals along with conducting training across many esteemed institutions & companies like Institute of Chartered Accountants of India, Various GST associations, BirlaSoft LTD, Delhi University, CPI (Ahmedabad) & Many More.

He is also a loved YouTube Trainer and provides trainings on his YouTube Channel " Fintax Prime".

 

More Courses


bestseller
bestseller
bestseller

Microsoft Power BI

Rs. 9999
Rs. 3499
View Details
bestseller

Google Docs

Rs. 2999
Rs. 999
View Details
bestseller
bestseller

Google Slides

Rs. 2999
Rs. 999
View Details
bestseller

Google Forms

Rs. 2999
Rs. 999
View Details
bestseller
bestseller

Google Sites

Rs. 2999
Rs. 999
View Details
bestseller
bestseller

Macro (Automation)

Rs. 2999
Rs. 999
View Details
bestseller
bestseller
bestseller

Student feedback

4.7
(513)

Course Rating

  • 5 stars
    82 %
  • 4 stars
    14 %
  • 3 stars
    2 %
  • 2 stars
    0 %
  • 1 stars
    2 %

Reviews

  • The course provided me extremely useful knowledge that will help to improve my day to day tasks. Mr Amit is really amazing in delivering his subject.

    It's amazing. Lots of learning

    This course was one of the amazing, and the best is the way of teaching which is like most, So in conclude i really liked this course.

    The course is nicely demonstrated in short and crispy manner.

    It is an amazing course. In few hours I have learnt so much about excel and all of the awesome features inside of it. Excel truly is an amazing software and Mr. Amit Jain is an amazing instructor. Five star for the course.

    Excellent course. I like this course. While learning this course, i come to know there are so many options and features, which i don't know previously, eventhough i am using excel from so many years..100% usefull.

    It was a Great course. Easy to follow. Well created. The Tutorials were clear and sharp. Just loved the course and it helped me expand my knowledge of Excel.

    Thank You so much Sir for such an amazing course.,learnt a lot from this course. This course has helped me to become an expert in Excel,where i was just a beginner before enrolling in this course. Really enjoyed the way you taught and made it look really easy.

    This course was extremely beneficial for me. When it comes to Excel, I knew a little of this or that process and had to try to find my way to complete the task. I started at the beginning of the course and watched every video and did every hands-on practice lesson. Now I feel like I have comprehensive knowledge. I also loved the way the course was presented. Today I got my certificate also. Thank you Amit sir for the same.

    This was very interesting to me. I learned a lot going through this course. I was an excel beginner. The instructor was excellent and he did not rush through the section.

    The course material are very useful. The course is well structured and the explain things so neatly that there are no doubt left after watching the video.

    This course is simply FANTASTIC !!! I learnt so many things thanks to an amazing teacher If you want to learn how to use Excel I highly recommend you this course :)

    It's really a good start. I was completely new to excel, Excel is something like an ocean. But somehow Amit manage to conceptualise the majority of Formulae and functions.

    It was my very first online course, the speed of teaching is up to mark, detailed videos, and quality video

    Thank you Sir for this wonderful course, your style of teaching the concepts alongside with to the point examples is fabulous. You've made it very-very easy. Looking forward to your other courses.

    Was one of the best course in Excel, Keep Teaching with the same energy..I would love to learn more.. Thank You for your guidance and assistance.

    This course was a fantastic overview from basic to complex features. I use excel daily for work but learned so much more than I ever knew could be done. I will definitely come back to the videos as I use my new skills. Thanks you sir for sharing amazing knowledge.

    Great Course! A detailed explanation of functions, and hands on demos to follow along. Amit is very knowledgeable, a real expert with Excel.

    Excellent course, I do feel I know so much more compared to when I started it. The instructor explains the concepts really well. Now I can save lots of time in office.

    This course has a good teacher, every thing is explain step by step

    This was by far the best online course I've taken so far. It's a lot of information to digest, but it's all about practicing these more.

    Good explanation for key details, but too much details in some videos. Make it more followable by splitting it at least in two parts. Still lots of learning.

    I was having lots of struggle in office in excel as maximum work done is in excel only. This course seriously helped me lot to sort out this issue. Thank you Amit for sharing such a wonderful course on online platform.

    Yes, it was a great match! I am really happy with the course. The only part (advanced drop down list) was difficult for me but still after practicing 3-4 times, I understood it. But the rest is perfect! Thanks a lot!

    This course was really an eye-opener. I thought I knew much about excel formulas till I was introduced to these advanced formulas and the possibilities that exist. Mind blowing...

    I am also working on beginner to Advanced course. I am not advanced enough to learn these functions, but am expected to know Index and match in order to do some reports for my job. I think the course is very good, just a bit over my head right now.

    Great learning experience, superb involvement in all sessions. Highly interactive sessions.

    Course is in Hindi. I'm not able to understand.

    Amazing course. Lots of learning. Five star from my side.

    Nice

    Good

    Thanks

    Amazing teacher ????????????????

    good

    awesome

    very good explanation

    Awesome

    best cource

    Jhakas h Amit Bhai

    Good

    Excellent way of teaching.

    Good offer sir

    Osm

    ...

    Sir the content was ok

    Good

    Well Teaching in very well manner Easy to understand

    Good

    zoom 80% kigye

    yes dekh raha

    Nice ????????

    Awesome

    Loving the session

    Good

    Wonderful session.. looking ahead for more sessions

    Great????

    very nice session with excellent knowledge and communication skills

    Awesome session

    Very exciting and challenging course

    Superb

    Very good

    I think basic part is more not advanced level is there ,teaching methodology is good

    Awesome Experience want to learn more from you Sir

    Nice time to study easily we can stand thank you.

    Its was really a wonderful session. Never expected something like this for free.

    It was amazing

    Excellent settion sir. ????????

    I have learnt alot during this session. Many new things comes to know as I was not aware till date. Thank you sir for this inciative.

    Good

    Very Very Helpful

    nice classes

    Hats off boss

    Wonderful

    Very Nice

    Really useful session Thanks Amit

    Very impressive learning

    Yes sir best

    This session so amazing ???? Now i am Contenew my Management Course after my Study I play with Data in a Organization.

    Nice Training. Please send my certificate of completion

    Thanks Amit for conducting Very useful training. Thanks a lot

    today i learn many things ,thank you so much sir.

    today i learn many things ,thank you so much sir.

    very good

    Very nice thank you so much Sir

    Great session sir

    good learning! worth watching!! excellent sir..!

    Very good sessions Thanks

    Great sir ????

    Excellent

    We learned lots of things we didn't know earlier. Thanks for the session.

    Your today session is very gud and u explaining very well but iwant to learn statistical data analysis test bttt this webinar is also helpful for another work thanku ????????

    Excellent

    Nice

    Nice

    Nice

    Nice session

    Nice session

    good one

    Thank you

    Your session is very much good

    It was really helpful. Thank you

    Fantastic session

    Full utilization of time

    Nice session.. should be in more details with more complex examples.. but very good for beginners..

    It's was really helpful...as it was free i could join and learn few new things????

    Today's webinar was fantastic. I feel satisfied from your training...thank you so much ...

    Great session, amazing communication skills... didn't feel bored at all. Learned some new things. Thanks alot

    Excellent

    Nice to attend the meeting

    over all good Training

    Excellent

    Good explanation but in very speedy mode.

    Very good session

    Easy To Understand And Apply Thanks CA Amit Jain Sir

    CA Amit, It was a Very engaging, knowledgeable session. You had explained everything in a very easy way. Truly Value of time. Keep going and stay safe. Thanks ????

    Good

    Qq

    Nice

    Amazing

    Good

    I really want to thanks for such a learning, interesting and interaction. Looking forward for more session like this.

    Very good sessions & very simple to know the actual functions formula

    usefull session

    Good teaching skills. Thank You Amit sir.

    Very well explained with examples and nicely presented. Thank you for the amazing formulas.

    Superb

    Nice class

    Today Session is very useful for my career

    Thank you

    Good

    Awesome session

    nice

    Very nice

    Session was wonderful

    Very helpful

    Beautifull and Meaning Full Video section great Teaching

    Today's session was wonderful and looking forward for your future support and Session too. Thank you Sir ☺️

    Such an amazing session and worthy knowledge love to be a part of this workshop.

    Such an amazing session and worthy knowledge love to be a part of this workshop.

    It was awesome.

    Such a wonderful session , marco is very easy to use ,

    It was good

    Excellent

    Excellent

    Really appreciate it was useful.

    Like presentation

    Super session on Excel. Learnt a lot

    Loves the session. Hope many more such trainings to come.

    Dear sir, I am not able to do like these activities in Google Sheet Excel. How can I press (ِAlt+E S L, M, D,S) at same time? I am not able to open the Alt special window in G Sheet excel also. Please help me

    Excellent

    Excellent

    Great Sir

    This session was excellent sir Keep doing courses like this. Thank you

    It's good and helpful so thank you so much sir

    Nice explain

    Excellent way of explaining.

    Today session is better

    Today training session is Better and I will use macro......

    Nice your webinar

    Nice your webinar

    Ok

    Beautifully explained.

    Good

    Can you please some videos for pivot table

    In section 3 when I use Alt +E than my excel window will rotate

    Yes

    Very nice

    how did u copied that 100000 in column?

    IT WAS A GREAT LEARNING EXPERIENCE FOR SURE. VERY WELL EXPLAINED IN THE BEST POSSIBLE MANNER.

    Excellent

    Excellent

    Nice

    Thank you sir

    Supab Paisa Vasul

    Dear Sir, Can you provide some demo video. Regards, Satish

    Enjoying the way of teaching Thanks sir

    Excellent

    Best

    Good

    Very good

    Excellent

    Good ????

    I always look people who were proficiently marked formulas but I feel embarrassed tht I am not able o do. One day I saw Amit sir channel live session I know the logic behind script formula. Now I have started practicing nd able to create formula through reminding Amit sir concept nd logic. Thank you sir for giving us your channel as a gift to us who built confident nd improvement in our computer skills. God bless you always.

    Excellent

    Very nice presentation sir I joined this course only for PPTs I am a teacher.

    Get certificate not showing

    Best Excel Tutuor. Im Always Grateful for This Wonderful Course At A Nominal fee.

    Fantastic . You are the best one tutor for excel sir. Thank you for us to teach.

    Thanks

    Good Explanation

    excellent

    Excellent

    Very nice sir

    I Always Look People Who Were Proficiently Marked Formulas But I Feel Embarrassed Tht I Am Not Able O Do. One Day I Saw Amit Sir Channel Live Session I Know The Logic Behind Script Formula. Now I Have Started Practicing Nd Able To Create Formula Through Reminding Amit Sir Concept Nd Logic. Thank You Sir For Giving Us Your Channel As A Gift To Us Who Built Confident Nd Improvement In Our Computer Skills. God Bless You Always.

    Superb

    nice ppts very helpful...learn lots of things..

    Best Excel Tutuor. Im Always Grateful For This Wonderful Course At A Nominal Fee.

    Very nice

    This was awazing session

    The session was very informative as well as interesting. Loved the way you explained the terms . Looking forward for using them in real life and attending such wonderful sessions with you sir.

    Yesterday's Webinar is very helpful for my carrier. It gives me more knowledge about the excel.. Which I didn't know about. So helpful for me. Thanks to Amit Jain sir for teaching us very simply.. I understand all the tricks nd shortcuts which sir used in his teaching. Need more webinars like this.. Thank u

    It was excellent webinar.

    Very nice an help...me

    Very Good vebinar.

    Very good program

    Very informative

    Best Teacher

    Great learning

    Great learning

    It was really an awesome informative session, looking forward to for more such sessions. Thanks

    It's a amazing platform where we boost our knowledge. Thank you Amit Sir.

    Sir your session is very helpfull

    It's good

    Absolutely gorgeous

    Amazing course at low price with certificate

    Good job

    Nice experience,learnt a lot by these sessions..

    Very good

    Excellant Training Session, Good Qualities and Standard.

    Great opportunity for everyone.its fantastic session

    Good efforts

    Awsome training by Amit sir... Thank you sir ji

    Excellent

    THE COURSES WERE TOO GOOD. WELL EXPLAINED. IT SHOULD BE 7 DAYS PROGRAMME AND MUST ELABORATE ON THE TOPIC OF PIVOT. THE WEBSITE IS NOT VERY USER-FRIENDLY. THE CERTIFICATE SHOULD GO IN THE MAIL OR IT SHOULD BE EASY TO ACCESS VIDEOS AND CERTIFICATES.

    Excellent sessions, the resource person is absolutely full of knowledge. Thank you for such a nice course.

    HELLO SIR.. CA SHIVANI MITTAL THIS SIDE..IT WAS GREAT OPPORTUNITY FOR US TO GET THE GIFT OF SUCH AN AMAZING LEARNING ON THIS TEACHER'S DAY...NOTHING CAN BE BETTER THAN THIS GIFT FOR STUDENTS. ALL THE SESSIONS INCLUDING 5 DAYS TRAINING WERE VERY HELPFUL FOR PEOPLE LIKE ME WORKING HARD FOR THEIR CAREER...I WOULD LIKE TO STAY CONNECTED WITH YOU FOR FUTURE LEARNINGS AS WELL ..THANK YOU FOR SHARING YOUR LEARNINGS WITH US.

    5 days session amezing experience. That is very helpful to me.. thank u sir...

    Excellent course

    Excellent course

    Very good

    Excellent

    Very useful training

    Very good

    Only in two words.... AWESOME and AMAZING..... thank you Sir... always be mentor.

    It's awesome. I really feel good and learn more about excel sheet

    Very helpful content and easy to understand

    Excellent webinar

    Nice sir

    Hi All I am a subscribed user of Amit Ji's website and the courses being offered by him are really amazing. He is patient enough to listen to queries and explains each and every thing right from scratch. The sessions are very informative for one and all. I strongly recommend you all to subscribe to his website and get benefit from copious informative courses Amandeep

    Nice ,good

    This Course Was A Fantastic Overview From Basic To Complex Features. I Use Excel Daily For Work But Learned So Much More Than I Ever Knew Could Be Done. I Will Definitely Come Back To The Videos As I Use My New Skills. Thanks You Sir For Sharing Amazing Knowledge.

    Excellent

    It's Awesome. I Really Feel Good And Learn More About Excel Sheet and advance excel

    its a very good idea.

    Excellent presentation.

    It was a very interesting session

    VERY GOOD TO LEARN

    Nice initiative

    Best I could being attaining senior citizen age. Thanks for your help

    Excellent

    I m learning ms excel

    i'm happy to enroll with this course and its worth to join

    Sir. Your event is excellent.

    Hi Sir, It's an awesome course. Very nice, useful and informative. Thanks & Regards, Vinay

    Sir I want paste as value in vesible cell in excel like WPS office ,how can I do

    Hi..Mr Amit, thanks for the course. The content is very engaging and it is fun learning. May I know in my excel platform the " Control U" short cut key isn't working. I am trying the curson moves to the end of the sentence. Any specific reason kindly suggest. Thanks !! Vipul Arora

    IT WAS A GREAT LEARNING SESSION. IN SHORT SPAN TOO MANY MIRACULAOUS TOOLS REGARDS TO EXCEL SHEET WERE DISCLOSED. BEING IMPRESSED WITH THE CONTENT I HAVE TAKEN THE COURSE WHICH WAS OFFERED AT DISCOUNTED PRICE . . . . THANKS FOR OPENING A NEW PATH OF SUCCESS IN MY LIFE.

    Hi Sir, It's An Awesome Course. Very Nice, Useful And Informative. Thanks & Regards. Ramulu

    Great

    I'm lean ms Excel

    Respected Sir, It's An Awesome Course. Very Nice, Useful And Informative. Thanks & Regards, Laksh Patel

    Hi Sir, It's An Awesome Course. Very Nice, Useful And Informative. Thanks & Regards, DIPAK

    Hi Sir, It's An Awesome Course. Very Nice, Useful And Informative. Thanks & Regards, DIPAK

    Very good

    Paste special another command is Ctrl +Alt +V

    श्रीमान जी , आपका सिखाने का बहुत ही अच्छा प्रयास है ।

    Dear Sir Really amazing course, every segment was exited and learning . Really apprceiate your valuable course content. looking forward to join further your othe course to upgrade my skills. Thanks & Regards Nandan S Bhoj

    Wonder Program. Amitesh Sir You are really "Genius"

    Wonderull Excel Program. Amitesh Sir is Really " Genius"

    easy to understand

    Had learn a lot from the session you are providing. Thank you so much the support Sir

    Thank you, sir, the sessions was so informative...., I wanted to learn excel in detail and to get a job, am a homemaker I wanted to earn and wanted to be financially independent... Then I got to see ur advertisement on Instagram and purchased ur course , I hope I will get knowledge of excel in detail and will now definitely try to get job... Thank you sir.

    I want pdf content vlookup and all data

    Awesome

    I like it. As it help me very much in school computer competition for making worksheets, word information, ppt

    Thanku support for your ❤️

    Awesome Course Got full knowledge on advanced excel tips very clearly.

    good

    Extremely happy with the course offered by Bizwiz. Thanks to Amitesh Sir for great and valuable content.

    very well explained sir .

    Sir, Thank you a lot for making this easy to understandable course. I've got my all three certificates from your Hon'ble site. your sincerely Tanzeem

    VERY INFORMATIVE

    Hi

    Very best platform learn basic to advance Ms office.

    Very nicely explained. Very Easy to learn and understand as well. The download Resources are of good help. But the files of Section 2 are not correct. also, it would be helpful if there is a test for each section separately. Thankyou

    Nice one

    great

    awesome sir..very informative. confidence increase.

    SIR WANT TO CREATE FORM IN EXCEL

    I am interested

    This course is very helpful for beginners..

    Excellent.........Sir, teaching skill is also very good.

    ITS REALLY VERY HEALPFULL AND VERY EASY TO LEARN

    superb

    Very interesting

    Best I learned alot! Thankyou

    Good

    Amazing and Awesome!!!!!!!!

    I had the pleasure of participating in an Excel training session led by Amitesh Jain, and I am thrilled to share my outstanding experience with him as an Excel trainer. Amitesh's expertise and passion for Excel are truly remarkable, making him an exceptional instructor who goes above and beyond to ensure his participants gain valuable knowledge and skills.

    I recently this Excel course and I am very impressed by the quality of the content and the instructor Amit Sir. The course covered everything from basic to advanced features of Excel, such as formulas, functions, charts, pivot tables, shortcuts, data analysis and macros. I learned a lot of new skills and tips that I can apply in my work and personal projects. The course was well-structured, engaging, and easy to follow. However, I have one suggestion for improvement. I think the certificate that I received after completing the course should also mention the specific topics that I learned, such as data analysis and macros. These are important skills that employers look for and that can make a difference in my resume. The certificate only says "basic to advanced Excel", which is too vague and does not reflect the depth and breadth of the course. I hope the course provider will consider adding these details to the certificate in the future.

    Sir the way of your teaching method is so good. Thank You so Much sir.

Add a Review

Rs 2255 Rs 5558 59% off

Book Consultation