loading......

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Advance Excel

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 Rashmi

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

Share

Advance Excel

Advance Excel

Carmelaram, Bangalore

5,000

2 Reviews
2 Interested

About the Course


This class will be arranged at 2 different locations in Bangalore City. Please send your preferred location.
And this class is only for thinkvidya registered users. If not registered, Please register it will take less than 5 minutes

Course Content Details
1. Excel Overview

2. Excel (2003-2007) Interface discussion

3. Customizing Excel 2007 Interface and Its control over application
a) Display options for Toolbar
b) Customized Settings for a new workbook.
c) Changing Calculation mode from Automatic to Manual and Vice Versa, Benefits of doing that
d) Different kinds of Error, and Enabling/disabling the same.
e) Customizing Control to Excel form Proofing, Save option, Auto recover option, Different display option for Excel workbook, Excel Worksheet
f) Customizing access toolbar
g)Add-Ins
h)Enabling/Disabling Macro, Making their execution specific to some folder

4. Regular Data formatting and writing customized data format.

5. Decision Structures. eg if..else.., For..Next Loop.

6. Filters: conditions and its usage. Prioritizing Advanced filters over other.

7. Writing Formulas and Evaluation: Mathematical, Date, Text
Difference between different functions like (Count and CountA), (Sum, SumIf), and few date function that mislead

8. Defining named ranges, Its Usage and Benefits

9. Making sheet communicate: Using formulas HLookup, VlookUp

10. Data Validation. (Drop Down combo box fetching data from a list.

11. Protecting Excel Workbook, Worksheet and Cell level of protection. Usage and its Benefits.

Excel is an MS-Office application, caters to need of individual, from beginner level Sales-Marketing person to Higher Management.


This course is beneficial for Student yet to start their career, From Beginner in a Profession to Higher Management Personnel.

Interested candidates need to send following details. Need to maintain data for interest received, to arrange classes accordingly in future.

1. Name:
2. Student Or In job:
3. Entry level/Mid Management/Sr. Position:
4. Preferred Day:
5. Preferred Location:

Topics Covered

As mentioned

Who should attend

HR,
Finance,
MIS,
Sales
Students
SAP

Pre-requisites

How to open MS-Excel:)

What you need to bring

Your Laptops"

Key Takeaways

You will be self sufficient in MS-Excel usage.
Knowledge and great memories
Reviews

Recommendations & reviews from previous Customers:

Mahesh Sn

"It was very gud time with rashmi to learn more thhing abt excel SPL thanks to rashmi"

attended Advance Excel


Girish Jamdar

"I am IT professional. It is worth joining class at Rashmi Madam.I have learned from Rashmi Madam. I found Rashmi madam as Highly professional, Good Subject knowledge, very good teacher. Perfectly designed course material. Really focused, excellent Teacher. Course and teaching is exactly according to my expectations. I am very happy. I will recommend people to join the class. "

attended Advance Excel


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Recommendations & reviews from previous Customers:

Mahesh Sn

"It was very gud time with rashmi to learn more thhing abt excel SPL thanks to rashmi"

attended Advance Excel


Girish Jamdar

"I am IT professional. It is worth joining class at Rashmi Madam.I have learned from Rashmi Madam. I found Rashmi madam as Highly professional, Good Subject knowledge, very good teacher. Perfectly designed course material. Really focused, excellent Teacher. Course and teaching is exactly according to my expectations. I am very happy. I will recommend people to join the class. "

attended Advance Excel


Date and Time

Not decided yet.

About the Trainer

Rashmi Sachdeva

MS in Information Technology, MS-BI


I have Total 9.5years of experience in IT field.

->I am rendering my services as Freelance Technical Consultant ( Business Solutions & Analysis) & Corporate Trainer.

->As a Techical Consultant I am harnessing the power of Excel for MIS(Management Information System), Business Decisions.

->Presently I am assisting three companies one from each US,Uk and Europe in their Business.

->As a Corporate Trainer, helping others to achieve their goal.
Seats Left-

Students Interested 2

Course Id: 2646