Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

"Basic to AdvancedXL Course" is no longer available

56 Reviews

Course type: Online Instructor led Course

Platform: Skype/Hangout

Course ID: 30689

Course type: Online Instructor led Course

Platform: Skype/Hangout

56 Reviews

About the Course

Course Curriculam (BasicToAdvancedXL - 16 Hours)




  • Module 1 (Getting Started with Excel - 2 hours) 




    • Introduction to Excel

    • Different ways to Open an Excel Workbook

    • Interface and Key Components of Excel

    • Navigating Through Excel - Exploring Ribbon Tabs

    • Excel Important Excel Options

    • Important Ribbon Keyboard Shortcuts

    • Data Entry / Editing in a Cell

    • General Keyboard Shortcuts

    • Merge / Unmerge Cells

    • Text to Columns (Importing txt file in Excel)

    • Use of Auto Fill, and Flash Fills

    • Extracting Unique Values 

    • Case Study - Day 1



  • Module 2 (Formatting - 2 hours)




    • Format Painter

    • Custom Number Formatting

    • Keyboard Shortcuts - Formatting

    • Paste Special

    • Freeze Panes

    • Keyboard Shortcuts - Freeze Panes/Split

    • Sorting and Filtering Data

    • Page Setup / Page Settings / Print Settings

    • Comments

    • Keyboard Shortcuts - Comments

    • Case Study - Day 2



  • Module 3 (Functions & Formulas - 8 hours)




    • Introduction to Excel Formulas

    • Difference between Functions and Formulas

    • Basic Rules to use Functions and Formulas

    • Use of Relative and Absolute Reference

    • Most Used Functions and Formulas and Customize Tricks (120+ Functions and Formulas with Live Examples)


      • Text Functions

      • Date and Time Functions

      • Information Functions

      • Lookup & Reference Functions

      • Logical Functions

      • Statistical and Mathmatical Functions*


    • Working with Dynamic Ranges

    • Creating Customize Formulas (Step-by-Step)

    • Formulas Debugging / Formulas Auditing

    • Case Study - Day 3 to Day 6



  • Module 4 (Data Analysis - 2 hours)




    • Named Ranges


      • Introduction to Defined Named Ranges

      • Assigning Named Ranges to Cell / Ranges

      • Basic & Advanced Use of Named Ranges in Functions



    • Conditional Formatting




      • Introdution to Conditional Formatting

      • Exploring each Rule Type

      • Use of Conditional Formatting using Different Rules

      • Use of CF using Function and Formulas



    • Data Validation




      • Introduction to Data Validation

      • Exploring each Validation Criteria, Input Message, and Error Alert Tabs

      • Preventing Users to Enter Specific Information to a Cell

      • Dynamic Drop Down List using Advanced Formulas

      • Dependent Drop Down List


    • Case Study - Day 7



  • Module 5, 6 & Bonus Module (Excel Charts, Pivot Table, and Bonus Module - 2 hours)





    • Excel Charts




      • Introduction to Charts

      • Use of Most Common Charts

      • Working with Simple Charts

      • Chart Selection (Basis on Requirements)



    • Pivot Tables




      • Introduction to Pivot Tables

      • Understanding and Exploring All Pivot Table Fields

      • Use of Calculated Fileds/Items

      • Reading Data Before Creating Pivot Tables

      • Creating Different Type of Pivot Table Summary Reports Using Same Data

      • Use of Slicers in Pivot Table



    • Bonus Module




      • Sheet/Range Protection in Excel

      • 300+ Excel Keyboard Shortcuts

      • Exploring Couple of Different Industry Dashboards

      • Introduction to Macro/VBA

      • Recording/Modifying Macro in Excel

      • Final Q & A




  • Key Take Away





    • After Every Session, You Will Get:




      • Session Study Material

      • Case Studies (Sample Database & Real Life Situations



    • After this course, you will be:




      • Having Strong Command on Keyboard

      • Skilled in Formatting the Data

      • Capable of Handling any type of Data

      • Able to Choose the Appropriate Functions in Different Situations

      • Writing the Formulas for Customize Requirements

      • Able to Create the Dynamic Ranges

      • Debugging any Function and Formulas

      • Strong Knowledge of Functions & Formulas

      • Ability to Create Good Looking Industries Dashboard

      • Ability to Read and Analyze Business Data



Date and Time

Not decided yet.

About the Trainer

Anil Dhawan picture

4.89 Avg Rating

63 Reviews

87 Students

0 Courses

Anil Dhawan

BA and MCA*

10 Years of Experience

A professional Excel Trainer and having 10+ years of experience as MIS/Data/Business Analyst and have been training since last 4-5 years. I have various applications knowledge i.e. Excel, SFDC, Business Object, Google Analytics, Webmaster, DFP, AdSense, VBA out of which I have strong grip over Excel/VBA/Google Analytics. I have trained over 50+ working professionals and given On Job Training during my stay at Google, Alcatel Lucent and couple of Real-Estate firms.

Courses that I have designed are especially for corporate people and freshers who want to appear for Excel/MIS/Data Analyst profiles. The examples, situations and material have been used from my past working experience that I tried collaborating it in one place for you to Make You Good in Excel and Informative. Post every session you get study material and session study material to practice and "Make Excel Your Power".

Student Feedback

4.0

Average Rating

93%
7%
0%
0%
0%

Reviews

V

Vishvadeep

The teaching methodology is very good.The class timings are also flexible.The exercises and case studies given after every session are very helpful in understanding the concepts and using them in real life scenarios.Overall the experience I had with Anil sir was very enriching.

N

Neha Agarwal

The course which I am taking currently by Anil Sir is very informative and lived up to my expectations.The sessions are interactive and presentable in such a manner that are simple enough to understand. I sincerely recommend this hub to all who really want to have data Analytical training.

M

Manoj kumar

The best part of the training with Anil is flexibility in timings. I have taken online training for advanced excel from Anil. It was great learning experience as study and practice material provided by Anil is too good and easy to understand. The way Anil explained the each topic is tremendous. The most important thing he is always make sure that the practice material provided by him is practiced by you or not. He always ready to take your doubts. He is very good tutor and very nice human being. If you are thinking hire Anil as your tutor then go for it. Thank you so much Anil.

J

Jatin gupta

It was exactly what I was looking for. I was looking for a trainer who can help me in understanding the concepts rather than mugging them up. The course structure is good and Anil is always there to clear your doubts. He is very well versed with current industry scenarios & live examples to make one understand the concepts with ease. There is no dout that he changed my perspective towards Excel and I strongly recommend him as a teacher & a guide.

P

Pratyush Grover

I want to share my experience that I gained from analytics training hub. I have completed a course in Ms excel from ATH and I am thankful to Anil sir for the same. The teaching quality is superior and the material is really helpful. The timings are flexible too. Even after the course was completed all my doubts were cleared post session. I will highly recommend this place if any student wants to learn excel in near future. I have also upgraded from excel to VBA.

G

Gaurav jain

Excellent stuff. I was amazed to learn the such important techniques which would definitely going to help in my managerial role and the way it was delivered by the trainer, Mr. Anil Dhawan made it more simpler and easy to understand. Course material is very well designed and examples shared during the training were also very appropriate. Would definitely recommend all professionals to attended these trainings to elevate their carrier to next level.

N

Nirupama Nair

The Excel classes with Anil Sir helped me a great deal to improve my Excel skills. The basic knowledge I had has increased immensely and has helped a lot in day to day work. I would recommend this to anyone who wants to improve their excel skills. Anil is very knowledgeable on the subject and a great instructor.

K

Kapil Panday

What to say about Anil as he has many qualities comprising professionalism, a good man , humble, flexible and no need to mention is an MS Excel expert. He has vast knowledge not only for excel and VBA rather he can help you in other work areas as well. You just ask or discuss with him for any other topic and he will guide and direct you correctly. Thanks.

R

Renu Singh

As I was pursuing my course regarding excel from your institute. I come to know that the teaching technique and attitude was so good. it was my pleasure to learn from your institute. The staff's behaviour also good as they are kind hearted and ready to help.

A

Arihant Jain

He makes us Learn very good new things which are necessary to work in excel. New shortcut keys get to know and very cooperative and helpful for making the examples and work understand. Make proficient in Advance excel in short.

S

Surbhi

He is very good mentor with vast knowledge of advance excel & provide with the live example and solution. Provide Good Assistance and help anytime. Very active for replying for solution.

H

Harsh Kapoor

I have learned here basic advance excel. The classes in this institute are very curious to know more and more easiest way. Even sir explain formulas shortcuts everything in simple way. So that anyone can understand the same. Best institute in Faridabad for excel coaching.

A

Ananya Banerjee

Mr.Dhawan has been an incredible teacher. He explained everything with ease and was open to doubt clearance at any point of time. One could contact him via mail or call and he was able to deliver the help. His practice papers ,case studies were well planned and designed in a way which could promote more towards a good hold on the concepts and versatile situations.Class timings were flexible too and pocket friendly. I would surely recommend Analytics training hub for the ones who truly desire to accomplish in this field with a friendly comfortable environment.

A

AMIT Kumar Mandal

Wonderful experience. Punctuality, dedication in training session by the trainer is excellent. Flexibility of timing, repeatedly question resolve sessions are also very impressive. One could join to get enhanced itself according to requirement of time.

R

Riya Mittal

My workshop experience with Anil Sir throughout my program was a quite fruitful and upgrading one. He provides you flexibility of timing because of which it became easier for me to manage my whole program with studies and my job. The material provided by him contains almost every minute detail of the program so it works best for a quick revision and any future queries. He tries to explain things on the most easiest way and with examples.

P

Priti Mishra

Mr.Anil is an amazing teacher. Have learn many new things in Excel here. This helps me to apply in my Current Job. As a fresher, and very new to Excel, he has really helped me catch up well with the basics and understand the concepts properly. His patience and understanding is something which is making me more confident, plus he is always available to help and clear doubts without a question.

K

Keshav Agarwal

It was great experience to learn over here. You can learn excel VBA and other analytical courses over here in a easy way. Great support given by Anil Sir about your query and problems. Case study are so much helpful to understand real life problems and help you to perform better in your working area.

D

Daljeet Singh

This has been a great learning throughout. I am a working professional in F&A department in one of the reputed MNC. I just knew the basics of Excel. I always wanted to expand my knowledge in Excel. I looked for some Trainer in google and I came across this person Anil Dhawan. He is a Master of excel and he provided my such a great learning that now my confidence level is awesome and he discussed those case studies and examples which we come across in day to day life. Thanks to Anil and I will look forward to learn more from you. Learning never ends.

A

A

Mr Anil Dhawan taught Microsoft Excel to my 12 year old son. He is a wonderful teacher very professional and punctual. We are completely satisfied and strongly recommend him.

R

Rinky Dang

First, I would like to thanks UrbanPro which helped me in finding the good tutor according to my need. So here , I am going to talk about the excel training , Anil Dhawan, who provided me the training for a month at my place. So, initially when he taught me, i was very confident that i would be going to learn many more things about the Ms excel and that came true also.If i talk about his teaching skills, he teaches so well and he cleared my each and every doubts whatever i had in the area of that field.Moreover, it was a very learning experience for me. So at the end i would recommend all those who are looking for the excel training must contact him first. Thanks.

V

Vandana

I was happy with the course covered by Anil. I liked the way it was covered, we had detailed sessions via Skype, his materials made helped me understand better as it contained various examples which i could relate to. He explains very simply and we moved slowly from simple to complex stuff so it helped me retain what i learnt. He is patient and open to several questions which i did ask him in between. Also i liked the flexibility of timings. I could reset or adjust the class timing as per my availability. That i really did several times because of relocating elsewhere. The case studies were also nice that made me practice whatever i had learnt in the sessions. In nut shell i liked the material and the way it was taught. I was also provided with many excel short cuts. A little improvement i would suggest here is that some ways should be introduced in helping student remember key board short cuts while doing excel training and practice. The best part about these classes is the support Anil extends even after the classes are over so i can get back to him if i have further doubts or if i get stuck somewhere while working on excel. So thanks. Great job.

S

Snehal Bindra

Anil Sir is a fantastic teacher. The course is designed extremely well with proper examples and tons of practice questions. Anil Sir's very patient and taught me at a pace that I was comfortable with. If I was unsure or unclear about any particular topic, he would always encourage me to clear my doubts with him and would explain the topic to me again. He was always happy to help me whether it was late at night or early in the morning. He was always concerned about my learning and encouraged me to try to understand the concepts instead of memorizing the functions blindly. He helped build my confidence and thanks to him I have started enjoying Excel.

T

Tia Guptta

Mr. Dhawan is a wonderful teacher. His course covered all the necessary topics and he was highly professional in his style of teaching. His comprehensive way of explaining Excel made the use of Excel seem like a cakewalk. His practice workbooks are designed to help students revise almost all the topics covered during class. The only minor recommendation I have for him is that he should include even the most simplest formulas in the case studies that he provides for practice just so that a student does not forget about those formulas being taught in the previous sessions. All in all, I was happy with the Excel sessions.

M

Mohit

I loved the way Anil conducted the training. He was thorough professional, punctual and knowledgeable with penchant to learn new things. He followed up every now and then about the topics he was coaching me on. So, if you are looking for Excel training, please go through it for the pleasant, professional and knowledgeable experience.

A

Ajay Anand

First of all i have to say that when i started my training i was very nervous at that time but with time i started gaining confidence. Mr. Anil has a good knowledge of his subject and delivers the same to his students. He is very supportive and patiently clears all doubts.Today after completing my course i can say that now i have that confidence in me which i lacked before. Also whenever i had any doubt regarding my course he helped me. Anil is very polite while teaching. At the end i would like to say it was a very good experience.

M

Manmeet Kaur

The course wasn't just about learning Excel but also understanding the various aspects where it can be used. The study material and the case studies are very helpful in enhancing the excel skills. Mr. Anil has a good knowledge of his subject and delivers the same to his students. He is very supportive and patiently clears all doubts. He not only provides knowledge of the subject but also delivers extra information only if the student is keen to learn. Overall it was a very good experience.

S

Shweta Kashyap

I just started this Basic to Advance Excel course online a month back. I must tell Anil is a very humble person, who possesses expertise in the field he is handling. His way to teaching was so simple that it took no efforts for me to understand. The course material that he shared time to time after every session is something that can help you life time for reference while handling Excel. He is very polite and patient while teaching.Being professional i needed time flexibility which he offered without any issue.I strongly recommend him as a mentor for this course and the related ones to any new.commer, fresher, professionals or students.His extra ordinary command on Excel, his course materials and his techniques of teaching can be a great help to excel in the desired field.

V

Vipul saurabh

"Anil is interactive alongwith very informative and makes sure we understand everything fully". Everything was very well prepared,I recieved everything i needed and more.The exercises were innovative and kept me interested,i learned easy tips that i can implement straight away. Overall i rate him 5/5 for his Punctuality, Knoweldge, Study material and Teaching skills.

R

Ruchi Chadha

Anil was very good with delivering and explaining the multiple categories of information. Course was structured in a good way as it included a short review with test questions at the end of each subject. It's a lot of information and the pace of training was just perfect because of the teaching style. I would recommend Anil for anyone who would like to get into excel. I am further planning to go for advanced training with Anil.

T

Tanya Bansal

I found the classes to be very well structured with a logical flow from basics to advanced excel that made it easy to grasp. The material used in class and the case studies provided for practice are comprehensive and ensure that the concepts are clear. Anil Sir was flexible and customized the course to make it complex or easier as was the requirement and level of existing knowledge. The course content was often supplemented with practical examples that can be easily replicated in daily work life.

R

Rishabh Singh

Hello ! I wanted to learn excel as it is in very much demand these days. I asked my good friend and he found Mr.Anil Dhawan from urdanpro and suggested me to learn excel under his guidance. Since day one he has been an amazing teacher ! With great typing skills and deep knowledge about excel, none of my doubts were left unanswered. Moreover, he has been very encouraging and motivating throughout the classes which is the best quality about him. So if you are looking to learn excel then Mr. Dhawan is the right choice.

K

Kavya Bhatnagar

UrbanPro.com is an excellent platform where we can get well Qualified Professionals without any doubt and tension. I just posted my requirements here and got matching Tutor, I am really happy about it! Mr. Anil Dhawan is a very good tutor and has a very good knowledge of MS Excel, and he provided us with the best material. I strongly recommend him as he is the best tutor.

S

Sumeer dabas

Urbanpro is a wonderful platform to fulfill the need for best learning by great professionals. I posted my requirements and got multiple options to pick from. I learned MS Excel basic to advance from Mr Anil Dhawan and i am completely satisfied and it was a great experience to learn from an expert like him. I would definitely recommend him as it was fully satisfactory and value for money experience.

A

Akshara

Anil is a very good teacher. He makes everything very easier. He has easiest techniques to offer. I am looking forward to take more classes from him and would recommend to everyone.

M

Manas

Would like to thank Anil for the knowledge he shared.He is a very good trainer and co-operative as well to clear any doubts. He also helps off line if contacted for any help. He is proactive in nature to help not like if you will ask then he will help. He has Very good knowledge of MS Excel. I will recommend if you want to be expert in Excel then please attend his training once. Thank you.

M

Manas

Anil is a very good trainer who has the capability to troubleshoot anything in excel quickly. He has capable enough to make people understand the concept of functions and formula. I like the way he trains and gives clarity on each topic. I enjoyed a lot the training session with Anil. Fact is only training can not make you perfect. We need to practice and implement all the things he trains.

A

Arshiya Chauhan

Anil is excellent in excel. He actually do magic with excel. I was not aware of excel when I started sessions with him. But now, I can make and create functions and formulas on my own. Though, someone can search excel from google, but the tricks and methodology that Anil shares during session is nowhere available on google. That obviously, comes with good exposure or a super master trainer like him.

A

Ankur sharma

Was looking forward for classroom sessions to learn Excel and came upon Urbanpro and through that came to know about Mr. Anil and let me tell you my learning experience with him has been the best. He comes with a vast professional experience and great knowledge of the subject he teaches and that i think works wonders for a student. Mr. Anil has always been helpful and encouraging throughout the sessions. I would rate him Excellent in all aspects such as Experience, Knowledge, Teaching Skills and Passion for his work and teaching and would strongly suggest people who want to learn Excel to learn from him. Five Stars from me.

V

Vikas Vaid

It was indeed a good experience and I learned very fast, which is helping me in my professional career too. He is really a good teacher and his way of teaching is very interesting. He has excellent command on his subject.

S

Sheetal saini

Anil holds the kind of technical expertise expected from a good teacher. Not only he was able to clear my concepts and get me hands on with Excel, he also guided me on important tips and tricks to save time & effort. My perspective has broadened from Excel just being a spreadsheet to a Excel being an intelligent tool that can be handled programmatically to have crisp data analysis and insights. Thanks Anil!! For making me Excel at Excel.

RIITU SANSIE.

All accolades to you Anil for designing the compatible course to meet my professional requirements. My learning experience with Anil has been an amazing one. His techniques are unique and very individualistic too that matched my learning needs completely. Anil has excellent command on the subject and good nature. He worked equally hard with me and took great pain in making the concepts clear. In just 3 sessions, he has taught me the core of the subject. His methodology is superb. Again,his techniques to teach are the ones to vouch for. He is a versatile teacher and overall"LEARNING IS FUN"with him.

P

Poonam

Class was awesome. This was the most beneficial class I have taken, also he made learning so easy and interesting for anyone.

T

Taniya

Experience i had while learning advance excel from Mr. Anil was very good, as it reduced a lot of time and effort of my daily working, The way he teaches is completely understandable , also he is very helpful even if you have any doubt in your daily working tasks in excel. If anyone has plan to learn advance excel,they should take sessions from him without any doubt.

S

Shweta Kalra

Thank you so much Sir for classes. It was very good experience. Your way of teaching is very easy and good. Case study which you shared in every session would be very useful for us in our career growth.In very short span of time, we learnt lots of short cuts and functions for which we were not familiar earlier. We would refer our colleagues and friends also for join this course for their career growth.

S

Sonia

Thanks to your classes and course. I liked the flexibility to study each week lesson. This classes is helpful for my future. I would recommend this to so many people which is too good and helpful for me or may be other people also.

B

Bhawna Julka

He has been a fantastic tutor with lot of patience and with a motive to make us understand the concepts rather than just completing the course. Surely recommend him if you want to learn excel.!!

T

Tanvi

It was a much needed class. Exactly served with the knowledge which I was looking for. Have covered many important aspects in excel which helps in professional life.

V

Vishal Pancholi

It was very good experience with Anil. He explained me very basics of excel function and also explained advanced part as well very clearly. He provided me lots of short cuts with practical examples which helped me lot. He is very flexible about his timing so it was very easy co-odinated with him. Personally his nature is very friendly & professionally as well.

Rajani Naidu

Got to learn everything i expected and wanted to. Very friendly and easy going way of teaching. Worth spending money and time. Overall a very good learning experience. Would strongly suggest for those who wish to learn excel online

I

Ipsita Mohanty

Anil Sir is a very good trainer with excellent knowledge and teaching skills on Microsoft Office products, specially on MS Excel. His dedication, punctuality and commitments make him a perfect trainer. My overall learning experience with him is very good. I wish him all the best and recommend him for similar training.

S

Shalu Singh

Very Intelligent and Just what you need! Anil is a wonderful Excel Tutor, he came prepared and guided me to take the best suitable path for my work and provided me good training for basics and advance excel. His work with me was quite extraordinary! Thanks!

A

Anand Suri

Excellent way of teaching . The concepts were very well explained . Cooperative attitude.

S

Samreen

Excel classes taken by Anil Sir has been of great help to me. From basic to advanced excel, these classes have helped in getting well equipped with this tool. Even being Online course, Anil sir's way of teaching is really good; he makes it easy to learn even the most difficult function in excel. I would recommend this online course to fellow colleagues and students.

T

Tina Tuteja

The training was provided in a very simplified manner with relevant examples of day to day life. It was more of a practical session rather than theoretical. The language used in the session as well as in the text book was very easy to learn with graphics and tables. Overall a good experience with lot of learning.

P

Puranjai Kapoor

Anil is a great teacher. He knows all about excel. He makes sure that one understands whatever he is teaching. I highly recommend him for a person who needs to know about excel.

A

Arsh Sadana

Superb teacher! Explained everything very easily and fast. Very patient and goes out of the way to clear your doubts. Would highly recommend!

Discussions

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more