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

17 Reviews

Course type: Online Instructor led Course

Platform: Skype/Hangout

Course ID: 30689

Course type: Online Instructor led Course

Platform: Skype/Hangout

17 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.9 Avg Rating

61 Reviews

80 Students

0 Courses

Anil Dhawan

BA and MCA*

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

94%
6%
0%
0%
0%

Reviews

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.

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.

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.

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.

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.

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.

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.

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