Thread by @_Datagirlie__

FUNCTION ARGUMENT WINDOW IN EXCEL📊.
To get a basic understanding of excel formulas and funtion( SUM,COUNT,MIN, MAX etc) as a beginner in data analysis learning excel, the use of the Fucntion argument window is relevant and will also be a guide to gain understanding.

A Thread🧵

-The Function Argument Window or Dialog box is helpful when building a formula. It helps to list the argument required for the function, identify which arguments are required or optional, show the result of a calculation or initial result of the function.
#data #excel

-It also help with understanding and using Nested functions-for example, when you want to put a MATCH function inside of a VLOOKUP function. It isn't easily understood for the first time trying it out, but you can use the function argument dialog for each function in the formula.

The function Argument dialog box would open by clicking on the 'fx-insert icon" in the Formulas tab of the ribbon and is also at the left of the Formula Bar.

-Keyboard Shortcut: Insert the Function name you want to use in a cell, then Click Ctrl + A.

How to use without keyboard shortcut:
Click on the cell you are working on, then the "Fx" icon that is beside the Formula Bar on your excel work sheet.

I hope you find this helpful in trying to understand excel Formulas and Functions📊.
Retweet, Like and Share your thoughts❤

@UnrollHelper