loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Excel Formulas & Functions - In depth

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid 10 digit Phone Number

Note: Please enter the phone number that you want to receive a call on.

Please enter the Pin Code.

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

Connect With Lokesh

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

Excel Formulas & Functions - In depth

Excel Formulas & Functions - In depth

Online Self Paced Class

799
5 Reviews
0 Interested

About the Course


In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training starts with how to write a Formula in Excel and starts with basic formulas like Sum and Count then gradually move to the complex one like IF, IF with And, IF with OR, Nested IF. Then it will cover the whole Lookup Functionality. Financial Functions will be covered there after with Date & Time Functions.

By the completion of this online training course, you will be fully versed, and capable of using most of the Formulas & Functions in Microsoft Excel 2007/2010/2013 in a commercial Environment.

Who should attend

Working Professionals & Students

Pre-requisites

Microsoft Excel 2007/2010/2013

Key Takeaways

- How to write a Formula in Excel
- How to use different Formulas & Function
- Learn different Functions from Microsoft Certified trainer from your own desk.
- Suitable for beginners to advanced users. ideal for users who learn faster when shown.
- Functions explained in most logical and simplest manner
Curriculum

Chapter 1 : An Introduction

  • An Introduction 1.23

Chapter 2 : First thing First - How to Write a Formula in Excel

  • How to Write a Formula in Excel 6.5

Chapter 3 : Sum Functions

  • Dealing with one condition - Using SumIF 3.75

  • For multiple conditions - SumIFs 5.92

Chapter 4 : Count Functions

  • Dont use Count!!!! Always use CountA 5.02

  • Count number of blank entries using CountBlank 2.6

  • Count with a condition using COUNTIF 4.4

  • Count with multiple conditions using COUNTIFS 5.8

Chapter 5 : Text Functions

  • An Into to Basic Text Functions 7.97

  • Some more Text Functions 7.88

  • Text to Column - A Complex Function 7.27

Chapter 6 : Logical Functions - If Functionality

  • Understanding IF Function 4.93

  • Merging IF with AND Function 6

  • Merging IF with OR Function 6.53

  • Creating a chain of IF functions - Using NESTED IF 11.03

Chapter 7 : Lookup Functionality - Vlookup%2C Hlookup%2C Lookup%2C etc.

  • FIRST THING FIRST - REFERENCES IN EXCEL 7.38

  • Vlookup with False 10.68

  • Vlookup with True 5.35

  • Vlookup with Mixed References 5.33

  • Vlookup with a Condition 5.32

  • Hlookup with False 4.07

  • No "V" No "H" just Lookup 4.2

  • Index and Match - The power of two 9.47

Chapter 8 : Date & Time Functions

  • The Basics of Date %2526 Time Functions 11.43

  • Understanding how Excel records and stores dates 4.7

  • Understanding how Excel records and stores time 1.67

  • Looking at standard date time entry options and acceptable alternatives 3.13

  • Using instant date time entry 2.08

  • Using TODAY and NOW functions for dynamic date time entry 3.42

  • Using Auto Fill to enter date and time series 4.05

  • Exploring keystroke shortcuts 1.68

  • Formatting time for hours over 24 2.23

  • Creating custom date formatting 2.77

Chapter 9 : Financial Functions

  • Calculate an Installment of a loan using PMT Function 3.68

  • Calculate Interest Per Period Using IPMT 3.15

  • Calculate Principal per period Using PPMT 4.15

  • Calculate Rate of Interest if not known 2.45

  • Calculate the Term of a Loan Using NPER Function 3.1

  • Calculate the Present Value Using PV Function 2.42

  • Create a Loan Table Using above Financial Functions 12.58

  • Calculate Depreciation in Excel 5.4

Chapter 10 : Misc. Functions

  • Misc. Functions 4.07

Reviews

Hemant Singh Dangi

"It was a good experience learning MS OFFICE. It will help in working in office and outside office also. "

attended Excel Formulas & Functions - In depth


Saurabh Rana

"The way to express the scenario of all the things is much better to understand, he is using dual ways according to the candidates to understand them which very helpful for each candidate. In functionality of using formulas to solve the queries is understandable due to his way to express. All over very much satisfactory. "

attended Excel Formulas & Functions - In depth


Lalit Kumar

"We have a gd experience of learning advance excel formula & shortcut key used in excel. Experience was awesome!!!!! "

attended Excel Formulas & Functions - In depth


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 4 of 4
M

Murali 21/01/2015

I registered and paid money - but unable to see the online training now - please advice

0 0

Answer

You can add upto 6 Images

Daragaiah 18/08/2014

I am interested

0 0

Answer

You can add upto 6 Images

U

24/07/2014

i want to learn MIS OR EXCEL TRAINING

0 0

Answer

You can add upto 6 Images

J

Joydeep 18/07/2014

Does this course covers Excel Macro as well?

1 0

Lokesh | 04/09/2014

Dear Joydeep, this course doesn't contain Macros. If you are interested you can just enroll for my Macros.

0 0

Answer

You can add upto 6 Images


Recommendations & reviews from previous Customers:

Hemant Singh Dangi

"It was a good experience learning MS OFFICE. It will help in working in office and outside office also. "

attended Excel Formulas & Functions - In depth


Saurabh Rana

"The way to express the scenario of all the things is much better to understand, he is using dual ways according to the candidates to understand them which very helpful for each candidate. In functionality of using formulas to solve the queries is understandable due to his way to express. All over very much satisfactory. "

attended Excel Formulas & Functions - In depth


Lalit Kumar

"We have a gd experience of learning advance excel formula & shortcut key used in excel. Experience was awesome!!!!! "

attended Excel Formulas & Functions - In depth


Ashish Sharma

"Overall experience was excellent. Lokesh explained very well. i came to know more deeply about the excel formulas.looking forward to have more training with lokesh on different areas "

attended Excel Formulas & Functions - In depth


Kunal Chhabra

"Firstly, I would thanks Lokesh sir for his service. He's an amazing trainer. I had a great time in his class. Solved my problems very patiently. The course content was also very good as it helped me a lot with my business. "

attended Excel Formulas & Functions - In depth


Content

10 Chapters

42 Video Lectures

digital certificate Get Digital Certificate after course completion

cash back LifeTime Access. No Limits!

cash back100% Money Back Guarentee

About the Trainer

Lokesh Lalwani picture

Lokesh Lalwani

Microsoft Certified Trainer


I have been taking Core & Advanced Excel and VBA classes for more then 6 years. I also provide corporate training. Few of the companies i have given training in are Fortis (Gurgaon), Fortis (Amritsar), Ingersoll (Gurgaon), Ceragon (Delhi), Greaves Cotton (Delhi) etc.

Students Interested 0

Students Attending 4

100% Money Back
Guarentee
Call at 080-46614806
to book on phone

Course Id: 20985