Signup as a Tutor

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

Enquire

Submit your enquiry for Functional MS-Excel - Master Basics and Functions

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

Functional MS-Excel - Master Basics and Functions

Functional MS-Excel - Master Basics and Functions

Sarjapur Road, Bangalore

5,000

10 Reviews
1 Interested

About the Course


******************************************** Learn From Industry Expert. If you want to excel in MS-Excel, then you should know Formula and Functions are basic building block to MS-Excel. In this training session, I am going to cover, how you can improve work performance by using numerous formulas and functions in MS- Excel. How to use formula with other formulas? What component can be replaced with other components? How to write formulas to avoid error? Evaluation of formula. And 20 MOST IMPORTANT SHORTCUT KEYS IN EXCEL 2007 and EXCEL 2010. NOTE: Excel Training is all about hands-on session. Guided learning. Practice Exercises. Post Training Support. Don't hesitate to clear your queries.


Topics Covered


Module 1: Overview of the Basics Difference between Excel 2003 and Excel 2007 Screen Interacting with Excel(2007) screen Special feature in MS-Excel that can help you excel. Module 2: Cell Reference and its usage in formulas Absolute and Relative and Mixed cells reference Preferred References in Formula Module 3 A: Working with Functions Writing conditional expressions (using IF, NESTED IF) Using logical functions (AND, OR, NOT, COMPOUND IF) Other Functions: Date and time functions: Date Today Now Day Month Year Time Hour Minute Second Weekday DateDif Networkdays WORKDAY Text Functions: Upper Lower Proper Left Right Mid Concatenate Len Exact Search Find Clean Replace Substitute Char Code Dollar T TEXT Database functions: DAVERAGE DSUM DCOUNT DCOUNTA DGET DMAX DMIN Mathematical Functions: Abs Int Mod Sqrt Power Round Trunc Fixed Sum Sumif Count Statistical Functions CountA Countblank Min Max Small Large Information Functions IsBlank IsError Isnumber Istext VLOOKUP, HLOOKUP, NESTED VLOOKUP, VLOOKUP WITH APPROX MATCH & EXACT MATCH Module 3 B: Evaluation of Formula Understanding Formula Evaluation concept Using "Evaluate Formula" Module 4: Handling Errors Types of Error Ways of handling Errors Module 5: 20 Shortcut keys combination for professionals


Who should attend


Management Professional BPO/KPO employee HR, MIS personnel Business person Commerce field, Would be C.A. Sales/HR.


Pre-requisites


-


What you need to bring


Laptop


Key Takeaways


Knowledge to manage your data. Knowledge specific to Business Solution no matter which field you are in.

Gallery
Content
Reviews

Rita Dutt

"Patient, understanding and knowledgeable...good teacher."

attended Functional MS-Excel - Master Basics and Functions on 10 Aug, 2013


Shailesh Agarwal

"She has trained in the most perfect manner and very practical."

attended Functional MS-Excel - Master Basics and Functions on 09 Jun, 2013


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 Functional MS-Excel - Master Basics and Functions


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

Showing 1 to 10 of 67
R

Rubina 06/09/2014

Don't you have classes in Mumbai

0 0

Answer

You can add upto 6 Images

R

Rashmi 04/05/2014

Dear Neha,

Thanks for showing interest in my courses. You can register for the course. If you are available on schedule dates, you can attend it later.

At present, there is early bird discount of Rs 1000 on Advance Excel course.

In case of any clarification, call me @95353-28913.

Regards
Rashmi S.

0 0

Answer

You can add upto 6 Images

N

Neha 04/05/2014

hi,
is it an online traing programme or class room training

0 0

Answer

You can add upto 6 Images

R

Rashmi 19/04/2014

Rajeev,

If you are not available on asked dates. You can attend class in next batch, or depending upon availability, I'll schedule class for you.

Regards
Rashmi S.

0 0

Answer

You can add upto 6 Images

U

Rajeev Singh 17/04/2014

Is this the date or you have other dates as well?

0 0

Answer

You can add upto 6 Images

R

Rashmi 17/04/2014

Dear Rajeev,

You will be glad to know, I provide all of my training courses online. And also you can register for the course using credit card.

Click on Regsiter button, and you will have all options for payments Credit card/Debit card etc.

See you in class.

Regards
Rashmi S.

0 0

Answer

You can add upto 6 Images

U

Rajeev Singh 16/04/2014

I'm intersted to take the course remotely. Can I pay using my credit card? Thanks,
Rajeev

0 0

Answer

You can add upto 6 Images

R

Rashmi 21/01/2014

Dear Monica, Macro are covered in separate outline. Click on the link below. http://www.urbanpro.com/bangalore/excel-vba-introductory-session-training/464714 This Excel VBA training an hour of Introductory training. You can attend the same. And in case you want to have customize outline, you can contact me at 95353-28913. Thanks. Regards Rashmi S.  more » Dear Monica,

Macro are covered in separate outline. Click on the link below.

http://www.urbanpro.com/bangalore/excel-vba-introductory-session-training/464714

This Excel VBA training an hour of Introductory training. You can attend the same. And in case you want to have customize outline, you can contact me at 95353-28913.

Thanks.

Regards
Rashmi S. «less

0 0

Answer

You can add upto 6 Images

U

Monica 21/01/2014

Hi,
I wanted to know if macros are also taught.

0 0

Answer

You can add upto 6 Images

R

Rashmi 01/01/2014

Wish You All A Very Happy Prosperous New Year..
Happy Learning !!!!

Regards
Rashmi S.

0 0

Answer

You can add upto 6 Images


Recommendations & reviews from previous Customers:

Rita Dutt

"Patient, understanding and knowledgeable...good teacher."

attended Functional MS-Excel - Master Basics and Functions on 10 Aug, 2013


Shailesh Agarwal

"She has trained in the most perfect manner and very practical."

attended Functional MS-Excel - Master Basics and Functions on 09 Jun, 2013


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 Functional MS-Excel - Master Basics and Functions


Vijay Kanneganti

"Was a very informative class. Rashmi was very patient and open with me. She answered all my questions and has a good grasp of the subject. I recommend all students and professionals to take this class. "

attended Functional MS-Excel - Master Basics and Functions


Vijay Kanneganti


Sandeep Kuma


Ramesh

"Very Interesting and good teaching."

attended Functional MS-Excel - Master Basics and Functions on 03 Mar, 2013


Abhi

"Rashmi is very helpful and has a good knowledge of MS excel and i recommend her as a trainer......!! :)"

attended Functional MS-Excel - Master Basics and Functions on 05 Jan, 2013


Amit Sengupta


Sneha Das

"Overall a good class, her concepts are clear and the coaching was nice."

attended Functional MS-Excel - Master Basics and Functions on 11 Nov, 2012


Date and Time

Not decided yet.

cash back100% Money Back Guarentee

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 1

Lifetime Stats

Batches conducted 12

Total Students 29

Course Id: 3820