Top 100 Secret Excel And Advanced Excel Short keywords

SUM - =SUM(A1:A10)
AVG - =AVERAGE(B1:B5)
IF - =IF(C1>10, "Yes", "No")
VLOOKUP - =VLOOKUP(D1, E1:F10, 2, FALSE)
HLOOKUP - =HLOOKUP(G1, H1:I5, 2, FALSE)
INDEX - =INDEX(A1:A5, 3)
MATCH - =MATCH(B3, C1:C5, 0)
CONCATENATE - =CONCATENATE("Hello", " ", "World")
TODAY - =TODAY()
NOW - =NOW()
MIN - =MIN(D1:D10)
MAX - =MAX(E1:E10)
COUNT - =COUNT(F1:F10)
COUNTIF - =COUNTIF(G1:G5, ">50")
SUMIF - =SUMIF(H1:H10, "<3")
AVERAGEIF - =AVERAGEIF(I1:I5, "Red", J1:J5)
CONCAT - =CONCAT(B2:B4)
TEXT - =TEXT(A1, "dd-mmm-yyyy")
DATE - =DATE(2022, 12, 31)
LEFT - =LEFT(K1, 5)
RIGHT - =RIGHT(L1, 3)
MID - =MID(M1, 2, 4)
LEN - =LEN(N1)
SUBSTITUTE - =SUBSTITUTE(O1, "old", "new")
TRIM - =TRIM(P1)
PROPER - =PROPER(Q1)
LOWER - =LOWER(R1)
UPPER - =UPPER(S1)
RAND - =RAND()
RANDBETWEEN - =RANDBETWEEN(1, 100)
ROUND - =ROUND(T1, 2)
ROUNDUP - =ROUNDUP(U1, 0)
ROUNDDOWN - =ROUNDDOWN(V1, 1)
ABS - =ABS(W1)
SQRT - =SQRT(X1)
POWER - =POWER(Y1, 3)
LOG - =LOG(Z1, 10)
EXP - =EXP(AA1)
PI - =PI()
MOD - =MOD(AB1, 5)
QUOTIENT - =QUOTIENT(AC1, 2)
SUMIFS - =SUMIFS(AD1:AD10, AE1:AE10, "A", AF1:AF10, ">10")
COUNTIFS - =COUNTIFS(AG1:AG10, "Male", AH1:AH10, ">30")
IFERROR - =IFERROR(AI1/AI2, "Error")
INDEX-MATCH - =INDEX(AJ1:AJ10, MATCH(AK1, AK1:AK10, 0))
TABLE - =TABLE(B2:E10)
FILTER - =FILTER(AL1:AL10, AM1:AM10="Yes")
UNIQUE - =UNIQUE(AN1:AN10)
SORT - =SORT(AO1:AP10, 2, TRUE)
CHART - Create a chart based on selected data.
DATA VALIDATION - Set rules for data entry in cells.
PIVOT TABLE - Analyze and summarize data.
FORMULA AUDITING - Trace and evaluate formulas.
DATA TABLE - Perform multiple what-if analysis.
SCENARIO MANAGER - Create and manage scenarios.
GOAL SEEK - Find input to reach a desired result.
SOLVER - Solve optimization problems.
NAMED RANGE - Assign a name to a cell or range.
ABSOLUTE REFERENCE - $A$1, locks both row and column.
RELATIVE REFERENCE - A1, adjusts when copied to a new location.
FREEZE PANES - Keep specific rows/columns visible while scrolling.
CONDITIONAL FORMATTING - Format cells based on specific conditions.
DATA IMPORT - Import data from external sources.
DATA EXPORT - Export data to external files.
CELL STYLES - Apply predefined formatting to cells.
HYPERLINK - Create clickable links in cells.
COMMENTS - Add comments to cells for additional information.
HIDE/UNHIDE - Hide or unhide rows, columns, or sheets.
FORMS - Create data entry forms.
DATA FILTERING - Filter data based on specific criteria.
TEXT TO COLUMNS - Split text into separate columns.
DATA CONCATENATION - Combine data from multiple cells.
SPLIT FUNCTION - Split text into multiple cells.
DATE FUNCTIONS - Perform operations with dates.
CUSTOM NUMBER FORMAT - Define custom display formats for numbers.
PIE CHART - Create a pie chart to represent data proportions.
BAR CHART - Create a bar chart for comparing data.
LINE CHART - Create a line chart to show trends over time.
STACKED CHART - Create a stacked chart to show part-to-whole relationships.
BUBBLE CHART - Create a bubble chart for three-dimensional data.
RADAR CHART - Create a radar chart to display multivariate data.
GANTT CHART - Create a Gantt chart to show project timelines.
WATERFALL CHART - Create a waterfall chart for visualizing financial data.
SPARKLINES - Add small, in-cell charts for quick visual analysis.
MACROS - Automate repetitive tasks with VBA code.
FORM CONTROLS - Insert form controls like buttons and checkboxes.
DATA VALIDATION - Set rules for data entry in cells.
RIBBON - Access commands through the Ribbon interface.
PAGE LAYOUT - Set up how the worksheet will be printed.
PAGE BREAKS - Control where pages break when printing.
HYPERLINK - Create clickable links to external resources.
PROTECT WORKSHEET - Restrict editing and formatting in a worksheet.
GROUP/UNGROUP - Group and ungroup rows or columns.
FORMULA NESTING - Combine multiple formulas in a single cell.
ARRAY FORMULAS - Perform calculations on arrays of data.
DATA TABLE - Perform sensitivity analysis on a range of inputs.
CONDITIONAL SUM - Sum values based on specific conditions.
PASTE SPECIAL - Paste data with specific formatting or operations.
DATA CONSOLIDATION - Combine data from multiple ranges.
3D REFERENCING - Refer to cells across multiple worksheets.