Signup as a Tutor

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

Excel Formulas & Functions - In depth

5 Reviews

Course type: Online Self Paced Class

Course ID: 20985

Course type: Online Self Paced Class

10 Chapters

42 Video Lectures

Students Interested 0

Students Attending 4

₹ 799

5 Reviews

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


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 for this Course

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

    • 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

Batch 1

Date : 14 Nov, 18 - 21 Nov, 18

Timings : 11:34 AM-11:34 AM

Seats Left : 10000

Students Interested : 0

Students Attended : 0


Have a Question? Enquire Now

About the Trainer

Lokesh Lalwani picture

4.85 Avg Rating

542 Reviews

806 Students

5 Courses

Lokesh Lalwani

Microsoft Certified Trainer

6 Years of Experience

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.

Student Feedback


Average Rating




Hemant Singh Dangi

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


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.


Lalit Kumar

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


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


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.

Discussions (3)

I am interested

By Daragaiah

Write an answer
Does this course covers Excel Macro as well?

By Joydeep


Top Answer

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

10 Chapters

42 Video Lectures

Students Interested 0

Students Attending 4

₹ 799


Have a Question? Enquire Now

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 799 Register


Submit your enquiry for Excel Formulas & Functions - In depth

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

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 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 the OTP sent to your registered mobile number.

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 is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on 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