Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Learn 14 Advanced Formulas in Excel

person icon Shubham Pareek

4.7

Learn 14 Advanced Formulas in Excel

Learn advanced time saving formulas in excel and also learn how to create dynamic data

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Shubham Pareek

English [CC]

category icon Office Productivity,Microsoft,Excel

Lectures -13

Duration -1 hours

Lifetime Access

4.7

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Welcome to the Microsoft Excel Course. Here you will learn a lot of things right from scratch. Learn How to open a file, save a file, and then slowly move on to advanced topics like How to create Dynamic Data, Using Choose, Workday, Networkday, Index, Match, Proper and more.

As we all know Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

The following Formulas are covered:

  • UPPER function changes all text to CAPITALS

  • LOWER function changes all text to lowercase

  • PROPER function changes the first letter in each word to upper case and all other letters to lower case – Generally, this is useful for fixing names.

  • TRIM function removes all spaces from text except for single spaces between words.

  • INDEX function returns a value or the reference to a value from within a table or range. There are two ways to use the INDEX function: If you want to return the value of a specified cell or array of cells, see Array form. If you want to return a reference to specified cells, see the Reference form.

  • MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.

  • WORKDAY returns a number that represents a date that is the indicated number of working days before or after a date (the starting date).

  • More Formulas like- NETWORKDAY, CHOOSE, AVERAGEIFS, COUNTIFS, SUMIFS.INTL and more...

    Let's learn Microsoft Excel.

Goals

  • Learn Index and Match Formulas
  • Dynamic Table Creation Covered
  • SUMIFS, COUNTIFS, AVERAGEIFS Included
  • Learn Advanced Formulas in Excel
  • Learn How to save time using Excel
  • Handle complex Excel tasks with ease with Workday and Networkday Formulas

Prerequisites

  • No prior experience is required. Learn Everything From Scratch
Learn 14 Advanced Formulas in Excel

Curriculum

Check out the detailed breakdown of what’s inside the course

Learn Excel

13 Lectures
  • play icon UPPER-LOWER 04:27 04:27
  • play icon PROPER-TRIM 05:38 05:38
  • play icon Combined Formula 02:06 02:06
  • play icon VLOOKUP Limitation 03:48 03:48
  • play icon INDEX-MATCH 08:48 08:48
  • play icon Practice 1 03:49 03:49
  • play icon SUMIFS 05:54 05:54
  • play icon AVERAGEIFS-COUNTIFS 04:06 04:06
  • play icon Practice 2 02:41 02:41
  • play icon WORKDAY.INTL 05:01 05:01
  • play icon NETWORKDAY.INTL 02:35 02:35
  • play icon Presenting Data 02:27 02:27
  • play icon Dynamic Data 09:05 09:05

Instructor Details

Shubham Pareek

Shubham Pareek

I have expertise in Linux,Ethical Hacking,Cloud Computing,Hardware and Networking. I have 6+ years of Teaching Experience. I am a Ex Senior Trainer at one of India's top Computer Institute. I have many Certifications to prove my knowledge- RHCSA,RHCE,Openstack,Hybrid Cloud Storage,EC-COUNCIL CEH, CCAS CEH, CompTIA Strata, Virtualization, CHNA and many more other Certifications



Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515