Signup as a Tutor

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


"Microsoft Excel Workshop - Advanced Techniques" is no longer available

No Reviews Yet


Course ID: 3022

You can not pay for your own class.

About the Course

Microsoft Excel is the most used office productivity software today. Almost all companies depend on Excel and people well-versed in Excel are in great demand always. However, knowing excel is one thing and getting things done in excel is another thing. For example:

• Do you know how to squeeze data amounting to thousand of rows in ten or even one row?
• Do you know how to do a statistical analysis of your data?
• Do you know how to use advanced, interactive charts to visually present your data?
• Do you know how to construct a dashboard?

Not many people have these skills and even fewer people would ever be willing to teach these precious stuffs to you. Demand for professionals with advanced knowledge of Excel has never been greater. Getting these skills will give you an enviable edge over others. Attend this course and dazzle your friends and colleagues with your new found talent. Believe it or not, this is no less than magic!!!

Topics Covered:

• Naming ranges and using them to manipulate data and formula
• Use of Advanced Filter and Data validation methods
• Use of little-used but powerful functions
• Data protection
• Hyper linking within workbook and outside
• Advanced conditional formatting
• Advanced use of form controls
• Interactive charts
• Recording Macros and assigning Buttons
• Introduction to dashboards

Who should attend:

• Any average Excel user who wants to learn advanced stuff
• Management students
• Professionals working in BPO/KPO sector
• MIS professionals


Prior exposure and experience with Microsoft Excel 2003 or 2007
What you need to bring
Students need to bring laptops (and chargers) with MS Excel 2007 (at least MS Excel 2003) installed. Students can also attend the course without a laptop in which case you need to write down certain steps and tricks. The softcopies of training material will be distributed to students through e-mail after the completion of the course.

Key takeaways:

After attending the course
• You will be able to use excel to analyze and arrange your data in an advanced and professional fashion
• You will learn the basics of MIS reporting, Dashboard and statistical analysis using excel
• You will learn tricks to perform your daily tasks in a much more efficient way

Topics Covered

Mentioned above


Date and Time

Not decided yet.

About the Trainer

Ranjan M picture

Avg Rating




Ranjan M.

Excel Expert

He has provided solutions for process improvement and automations in internal projects in MNCs and HR consultancies

Mr. Ranjan has recognized expertise in Financial Modeling and Data Visualization using MS Excel as a tool. He also has extensive experience is creating business and analytical dashboards.

Mr. Ranjan has provided training at management institutes like ICFAI Business School, Alliance Business School, Krupajala Engineering School and Dayanand Sagar Business School. He has also conducted internal training workshops in MNCs like FIS, Oracle, VMware and Outsource Partners International.


No reviews currently

Discussions (3)

3 months.

By Jayanta S.

Write an answer
I provide personalised training.

By Jayanta S.

Write an answer
Ranjan M picture

Ranjan M.

No Reviews Yet

Batches conducted 2

Total Students 23

₹ 1,000


Post your requirement and let us connect you with best possible matches for Computer Software Classes Post your requirement now

Register for Free Master Class

tickYou have successfully registered

Class Scheduled at


To join, click

Add to Google Calendar

Share this Master class

Message copied

How to join a Class?
  • For Mobile phone, download the UrbanPro app for Learners

    The UrbanPro Learner app is your study app for this course. You can attend the Demo Class on the app and also get access to the course material, course schedule and ability to communicate with the Tutor. To learn more, watch this video.

    Play Store App Store
  • For Laptop, download the Zoom app

    Download the Zoom app for your laptop. The link to join the class will launch the meeting with the tutor on this Zoom app. To learn more, watch this video.

Verify you Mobile Number

Please verify your Mobile Number to continue and book a FREE Demo class.


Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.


Please enter OTP.

Or, give a missed call and get your number verified


This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 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 7.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