Gain Mastery of over 135+ MS Excel Functions (Office 2021)

Gain Mastery of over 135+ MS Excel Functions (Office 2021)

You are welcome to this Microsoft Excel Functions course. You will be guided step by step on how to be an excellent formula analyst with Microsoft Excel. This course uses Microsoft Excel 2021 as a tool to learn and master Excel functions.

In this course you will:

Learn how to work with Excel functions from scratch (absolute beginner) to a comfortable professional

The New Excel 365/Excel 2021 Dynamic Array Functions - SORT function, FILTER function, RANDARRAY function, SEQUENCE function, UNIQUE function, XLOOKUP function, SORTBY function

Master the skill of tracing dependents and precedents of data

Flourish in the skill of nesting functions

Learn how to map data with VLOOKUP and INDEX function

Master how to combine VLOOKUP and HLOOKUP functions to perform one function

Understand how to manipulate and combine INDEX/MATCH functions and  VLOOKUP/MATCH functions and VLOOKUP/INDIRECT functions and HLOOKUP/MATCH functions and more combinations of functions to maximize efficiency.

Understand how to create lists of items with Data Validation

Automate data entry with Auto-Fill and Flash-fill.

Master the tool of evaluating data

Creating and Deleting and Editing Defined Names

Understand how to work with Statistical Functions - AVERAGEIFS, COUNTA, COUNTIF, COUNTIFS, MEDIAN, MODE,  MAX, MIN, AVERAGE, LARGE, SMALL, etc

Understand how to work with Maths & Trig Functions - TRUNC, POWER, SUM, SUMIF, SUMIFS, QUOTIENT, SUMX2PY2, SUMX2MY2, LCM, GCD, SIN, COS, TAN, etc

Understand how to work with Lookup & Reference Functions - XLOOKUP, XMATCH, VLOOKUP, HLOOKUP, ROW, ROWS, TRANSPOSE, COLUMN, COLUMNS, SORTBY, FILTER, MATCH, UNIQUE, etc

Understand how to work with Date & Time Functions - DAYS360, NOW, TODAY, DATE, TIME, WEEKDAYS, etc

Understand how to work with Logical Functions - IF, IFS, IFERROR, NOT, OR, AND, etc

Understand how to work with Text Functions - CONCAT, MID, REPT, TEXT, ARRAYTOTEXT, TRIM, LEN, LEFT, RIGHT, etc

Be a professional in MS Excel Functions (Excel 2021) - Dynamic Array functions, Formula Auditing, Evaluating data, etc

Url: View Details

What you will learn

• Excel 365/Excel 2021 Dynamic Array Functions - XMATCH, XLOOKUP, SORT, FILTER, RANDARRAY, SEQUENCE, UNIQUE, SORTBY
• Understand how to manipulate INDEX/MATCH functions and VLOOKUP/MATCH functions and HLOOKUP/MATCH function
• Get a good grip on how to work with Maths & Trig Functions - TRUNC, POWER, SUM, SUMIF, SUMIFS, QUOTIENT, SUMX2PY2, SUMX2MY2, ,LCM, SIN, COS, TAN, etc

Rating: 0

Level: Beginner Level

Duration: 25 hours

Instructor: Pamch Tutor