Learn 14 Advanced Formulas in Excel

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.