As a tutor you can connect with more than a million students and grow your network.
Kalyan Nagar HRBR Layout, Bangalore
Course ID: 56717
Kalyan Nagar HRBR Layout, Bangalore
Students Interested 0 (Seats Left 0)
₹ 3,000
Corporate IT Trainer
This Excel Course will Cover the below Topics :
Interface and Navigation
All Navigation Shortcuts
All Ribbon Menu Accessor Keys
Data Entry in Excel
Copy Paste Operations/Paste Special Formats
Sorting/Filtering
Printing
Basic Formulas operations
Enter a Formula in a Cell
Cell References
Relative Reference
Absolute Reference
Functions used to consolidate Data(Reporting Techniques with formulas )
Creating Range Names to use in Formulas/Data Tables
SUM/SUMIF/SUMIFS/AVERAGE/ AVERAGEIF/ AVERAGEIFS
COUNT/COUNTA/COUNTIF/COUNTIFS
Referencing Functions In Excel
Nested Ifâ??s with Logical Operators(AND/OR/NOT)
VLOOKUP/HLOOKUP
Date and Text Functions
Visual Formatting With
Conditional Formatting Concepts
Data Represenatation With Charts
Create Charts
Understanding the Chart Elements
Modifying The chart elements
Data Consolidation With Pivots
Create /Edit/Format a Pivot Tabe
Change Summary Calculations
Add A Calculation
Add a Pivot Chart
Add Filters
Create An Example of a Dashboard with Pivots
Product Analysis or
Call Center Analysis or
Employee Performance Analysis
Introduction to Macros
Create a Recorded Macro
Storage Loactions
Editing a macro
Calling/Executing a Macro
================================================
You will receive certificate after completion of the course.
Duration of the Course:
You have options of weekdays and weekends - (2 hrs * 10 days)
To Register, 100% payment is mandatory, before starting the classes
Please note: You will need to carry your laptop with MSOffice installed version 2010 or above.
Let us know your time slots and frequency of classes required(daily, weekends).
we have other courses for Excel with macros, Power BI, SQL, etc.
Message copied
Copy
Not decided yet.
4.9 Avg Rating
10 Reviews
108 Students
14 Courses
4.9
Average Rating
Sunita Devi
I have attended Bhavna's MS Excel Classes and found it to be very useful. She has in-depth knowledge of MS Excel and helps understand Excel with live examples. Her classes are totally worth the time and money. Thank You, Bhavna.
Tarun Poonacha
It's my pleasure to strongly recommend Bhavna to any prospective person who wants to learn about MS Excel, VBA and SQL. The way she planned the entire course with various examples was definitely easy to understand and her practice exercises,notes ensured I was always well versed with the previous days lessons before coming to the current day's class. She is very patient and highly knowledgeable on the subjects that she covered during the whole course.With constant practice through her guided classes, one can certainly master the topics she covers without difficulties. She also offered me to come back for a couple of extra classes to run through any topic that I wished for which showcases her passion towards making her students for additional assistance at any given point of time.She even goes to the extent of giving additional time in each class to cover back topics that would need more attentiveness.I highly recommend Bhavna for her dedication,exceptional skills of teaching as well as on the technical front, for being reachable to students even after the official course is completed and most importantly for being a wonderful person and having an exciting classroom atmosphere.
Sathish
I was at the right place at the right time. Bhavna has helped me to learn excel from the scratch. She has been so patient to guide me; even when I was asking her to repeat few topics. She is a great mentor. Will take up another course.
Tejas More
I was looking forward for learning Advanced excel course and was searching for coaching stuff in mumbai. I got to know about bhavna and her effective teaching techniques and most importantly Online training sessions. At Start, i was tentative to go for online sessions due to two different cities and technical issues. But the way these sessions were designed/conducted changed my perception and helped me learn advanced excel in short period of time. She has in-depth knowledge of the subject and ensure all modules to be professionally covered within the allocated time and with effective communications and training skills. We worked our schedules in better way and ensured the course finished as per the timelines. The content shared was effective and assignments are to the point that will cover basics and in-depth knowledge while working with excel. Thumbs up from me for getting me up to speed on Advanced excel and thanks for your support.
Vijay
Excellent, would recommend it to all beginners and advanced user's. Met my expectations and very professional approach on teaching skills. Would rate 9 out of 10.
Trupti Sagwekar
Bhavna is an excellent trainer. Very professional, skilled & competent. The course structure and content is very well contained. The program structure helped me getting insights of almost all facets of MS EXCEL. It covers differences from the older versions of Excel to the latest available. In every topic she pointed out the difference and this indeed helps you, as you might be dealing with any version at time or in future. She helped me in some work related queries as well. About Bhavna, she is very nice and friendly. Understands your requirements and schedules the sessions accordingly. Trains people at their comfort zone and their pace. Overall, it was worth the time and efforts. I recommend it for anyone who wants to learn Advanced Excel skills.
Musheer Al Zaman Lahori
To describe Bhavna as a trainer in two words – “Simply Excellent”. She displays the clear acumen for teaching and understands the art of teaching in line with the requirements of the corporate world today (which is exactly what makes the course very practical, informative and something that you can immediately apply in your day to day work and fetch great results). I had enrolled for the Advanced Excel course with her in April 2016. The course content was well designed to take the student through a logical flow of thought process to understand the basics and build a strong foundation of the subject. The training methodology had clear steps to grasp the “what’s” “why’s” and “how’s” of Advanced Excel with real time examples from the corporate perspective. The course gave me a clear understanding and practice of the formulas, functions, pivots, charts, etc. which I could incorporate in my day-to-day work. Bhavna’s friendly nature and flexibility with time makes the class even more interesting, interactive, easy to learn and clear the small doubts you have every now and then. Would totally recommend this course to anyone looking to build a strong foundation and a clear understanding of the subject. Very Satisfied! Highly Recommend!
Charanya M
Bhavna is a very friendly professional. Understands our requirements and schedules sessions accordingly to match with our needs. Flexible with our schedules. THE BEST part of the course was the Course content. It is well structured and contained. Covers up almost all the vital essentials of the Excel along with the differences and updates from the older versions. We get to learn a lot more than what a power user would be knowing. Recommended for anyone who wants to learn ADVANCE EXCEL. I would recommend this course. Worthy content!
Charanya M
Bhavna is an excellent trainer. Well skilled and very professional even though I had been for a home based training. THE BEST part of the course was the Course content which was well structured and contained. The program structure helped me getting insights of almost all vital aspects of MS EXCEL. We get to know the differences from the older versions of Excel to the latest available. Which is essential for person who works on it. We get to know a lot more than what a power user would be knowing. About Bhavna, she is very nice and friendly Professional. Understands our requirements and schedules the sessions accordingly. Trains people at their comfort zone and their pace. Overall, it was a worthy content to look for! I recommend it for anyone who wants to learn advanced Excel skills. Thanks.
Ask a Question
Corporate IT Trainer
Students Interested 0 (Seats Left 0)
₹ 3,000
Message copied
Copy
Register for Free Master Class
You have successfully registered
Class Scheduled at
hour
Share this Master class
Message copied
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.
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.
080-66-0844-42