Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel Formulas and Functions

Excel Formulas & Functions - In depth

Learn to Use right formula at right place
Rating: 4.6 out of 54.6 (16 ratings)
564 students
Created by Nurture Tech Academy
Published 1/2014
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • 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
  • Downloadable exercise files for practical learning

Requirements

  • Microsoft Excel 2007/2010/2013

Description

In this Excel Formulas and Functions - In depth video course, Nurture Tech Academy introduces you to the most simplest and logical way to understand most of the Excel functions.

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 this course is for:

  • Working Professionals & Students

Course content

11 sections • 43 lectures • 3h 36m total length

  • Preview01:13

  • Preview06:29

  • Preview03:44
  • For multiple conditions - SumIFs
    05:54

  • Dont use Count!!!! Always use CountA
    05:00
  • Count number of blank entries using CountBlank
    02:35
  • Count with a condition using COUNTIF
    04:24
  • Count with multiple conditions using COUNTIFS
    05:47

  • An Into to Basic Text Functions
    07:57
  • Some more Text Functions
    07:52
  • Text to Column - A Complex Function
    07:15

  • Understanding IF Function
    04:55
  • Merging IF with AND Function
    05:59
  • Merging IF with OR Function
    06:31
  • Creating a chain of IF functions - Using NESTED IF
    11:01

  • FIRST THING FIRST - REFERENCES IN EXCEL
    07:22
  • Vlookup with False
    10:40
  • Vlookup with True
    05:20
  • Vlookup with Mixed References
    05:19
  • Vlookup with a Condition
    05:18
  • Hlookup with False
    04:03
  • No "V" No "H" just Lookup
    04:11
  • Index and Match - The power of two
    09:27

  • The Basics of Date & Time Functions
    11:25
  • Understanding how Excel records and stores dates
    04:41
  • Understanding how Excel records and stores time
    01:39
  • Looking at standard date time entry options and acceptable alternatives
    03:07
  • Using instant date time entry
    02:04
  • Using TODAY and NOW functions for dynamic date time entry
    03:24
  • Using Auto Fill to enter date and time series
    04:02
  • Exploring keystroke shortcuts
    01:40
  • Formatting time for hours over 24
    02:13
  • Creating custom date formatting
    02:45

  • Calculate an Installment of a loan using PMT Function
    03:40
  • Calculate Interest Per Period Using IPMT
    03:08
  • Calculate Principal per period Using PPMT
    04:08
  • Calculate Rate of Interest if not known
    02:26
  • Calculate the Term of a Loan Using NPER Function
    03:05
  • Calculate the Present Value Using PV Function
    02:24
  • Create a Loan Table Using above Financial Functions
    12:34
  • Calculate Depreciation in Excel
    05:23

  • Misc. Functions
    04:03

Instructor

Nurture Tech Academy
Microsoft Office Specialist
Nurture Tech Academy
  • 4.4 Instructor Rating
  • 2,374 Reviews
  • 39,752 Students
  • 5 Courses

    Nurture Tech Academy was founded in 2009. Its a Microsoft Authorised Testing Centre, providing a blend of instructor-led and online training programs in Basic Excel, Advanced Excel, VBA, Macros, and other MS Office applications. It has a team of Microsoft Certified Trainers who are specialist in their respective fields. All trainers have a 9+ yrs. of training experience.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.