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

Batch 1

Date : 14 Dec, 17 - 21 Dec, 17

Timings : 08:03 PM-08:03 PM

Seats Left : 10000

Students Interested : 0

Students Attended : 0

Register

Have a Question? Enquire Now

Lokesh Lalwani picture
Lokesh Lalwani

Microsoft Certified Trainer

6 Years of Experience

About Lokesh Lalwani

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

Hemant Singh Dangi

Attended Excel Formulas & Functions - In depth

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

S

Saurabh Rana

Attended Excel Formulas & Functions - In depth

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.

L

Lalit Kumar

Attended Excel Formulas & Functions - In depth

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

A

Ashish Sharma

Attended Excel Formulas & Functions - In depth

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

K

Kunal Chhabra

Attended Excel Formulas & Functions - In depth

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.

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

    • 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 (5) See all Reviews

H

Hemant Singh Dangi

Attended Excel Formulas & Functions - In depth

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

S

Saurabh Rana

Attended Excel Formulas & Functions - In depth

The way to express the scenario of all the things is much better to understand, he is using dual ways...

L

Lalit Kumar

Attended Excel Formulas & Functions - In depth

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

A

Ashish Sharma

Attended Excel Formulas & Functions - In depth

Overall experience was excellent. Lokesh explained very well. i came to know more deeply about the excel...

K

Kunal Chhabra

Attended Excel Formulas & Functions - In depth

Firstly, I would thanks Lokesh sir for his service. He's an amazing trainer. I had a great time in his...

Discussions (3)

I am interested

By DARAGAIAH MENDAM

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

By Joydeep

Lokesh Lalwani

Top Answer

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

0 Dislike
Comment
View all answers

10 Chapters

42 Video Lectures

Students Interested 0

Students Attending 4

₹ 799

Register

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

Enquire

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.

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