Signup as a Tutor

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

Basic to AdvancedXL Course

10 Reviews

Course type: Online Instructor led Course

Platform: Skype/Hangout

Course ID: 30689

Course type: Online Instructor led Course

Platform: Skype/Hangout

Students Interested 0 (Seats Left 0)

10 Reviews

Date and Time

Not decided yet.

Anil Dhawan picture
Anil Dhawan

BA and MCA*

About Anil Dhawan

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".
D

Daljeet Singh

Attended Basic to AdvancedXL Course

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

Attended Basic to AdvancedXL Course

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

Attended Basic to AdvancedXL Course

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

Attended Basic to AdvancedXL Course

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

Attended Basic to AdvancedXL Course

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

Attended Basic to AdvancedXL Course

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

Attended Basic to AdvancedXL Course

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

Attended Basic to AdvancedXL Course

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

Attended Basic to AdvancedXL Course

"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

Attended Basic to AdvancedXL Course

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.

View more 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



Reviews (10) See all Reviews

D

Daljeet Singh

Attended Basic to AdvancedXL Course

This has been a great learning throughout. I am a working professional in F&A department in one of the...

R

Rinky Dang

Attended Basic to AdvancedXL Course

First, I would like to thanks UrbanPro which helped me in finding the good tutor according to my need....

S

Snehal Bindra

Attended Basic to AdvancedXL Course

Anil Sir is a fantastic teacher. The course is designed extremely well with proper examples and tons...

T

Tia Guptta

Attended Basic to AdvancedXL Course

Mr. Dhawan is a wonderful teacher. His course covered all the necessary topics and he was highly professional...

M

Mohit

Attended Basic to AdvancedXL Course

I loved the way Anil conducted the training. He was thorough professional, punctual and knowledgeable...

A

Ajay Anand

Attended Basic to AdvancedXL Course

First of all i have to say that when i started my training i was very nervous at that time but with time...

Discussions

Students Interested 0 (Seats Left 0)

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

Enquire

Submit your enquiry for Basic to AdvancedXL Course

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Anil

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer