50 𝐨𝐟 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐢𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐄𝐱𝐜𝐞𝐥… — Data Analytics & AI | SQL Interviews

Data Analytics & AI | SQL Interviews | Power BI Resources@data_visual · 27.5K subscribers Open in TelegramOpen

50 𝐨𝐟 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐢𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐄𝐱𝐜𝐞𝐥 𝐟𝐨𝐫𝐦𝐮𝐥𝐚𝐬 𝐭𝐡𝐚𝐭 𝐜𝐚𝐧 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐩𝐞𝐫𝐟𝐨𝐫𝐦 𝐯𝐚𝐫𝐢𝐨𝐮𝐬 𝐭𝐚𝐬𝐤𝐬 𝐞𝐟𝐟𝐢𝐜𝐢𝐞𝐧𝐭𝐥𝐲.

S𝐔𝐌: Adds up numbers in a range.
𝐀𝐕𝐄𝐑𝐀𝐆𝐄: Calculates the average of numbers in a range.
𝐌𝐀𝐗: Returns the largest number in a range.
𝐌𝐈𝐍: Returns the smallest number in a range.
𝐂𝐎𝐔𝐍𝐓: Counts the number of cells that contain numbers in a range.
𝐂𝐎𝐔𝐍𝐓𝐀: Counts the number of non-empty cells in a range.
𝐈𝐅: Checks if a condition is met and returns one value if true and another value if false.
𝐕𝐋𝐎𝐎𝐊𝐔𝐏: Searches for a value in the first column of a table and returns a value in the same row from another column.
𝐇𝐋𝐎𝐎𝐊𝐔𝐏: Similar to VLOOKUP, but searches for a value in the first row of a table.
𝐈𝐍𝐃𝐄𝐗: Returns the value of a cell in a specific row and column of a range.
𝐌𝐀𝐓𝐂𝐇: Returns the relative position of an item in a range.
𝐂𝐎𝐍𝐂𝐀𝐓𝐄𝐍𝐀𝐓𝐄: Joins two or more text strings into one string.
𝐋𝐄𝐅𝐓: Returns the leftmost characters from a text string.
𝐑𝐈𝐆𝐇𝐓: Returns the rightmost characters from a text string.
𝐋𝐄𝐍: Returns the number of characters in a text string.
𝐓𝐑𝐈𝐌: Removes leading and trailing spaces from a text string.
𝐔𝐏𝐏𝐄𝐑: Converts text to uppercase.
𝐋𝐎𝐖𝐄𝐑: Converts text to lowercase.
𝐏𝐑𝐎𝐏𝐄𝐑: Capitalizes the first letter of each word in a text string.
𝐓𝐄𝐗𝐓: Formats a number or date value as text using a specified format.
𝐃𝐀𝐓𝐄: Returns the serial number of a particular date.
𝐓𝐎𝐃𝐀𝐘: Returns the current date.
𝐍𝐎𝐖: Returns the current date and time.
𝐃𝐀𝐓𝐄𝐃𝐈𝐅: Calculates the difference between two dates in years, months, or days.
𝐄𝐎𝐌𝐎𝐍𝐓𝐇: Returns the last day of the month, n months before or after a given date.
𝐑𝐎𝐔𝐍𝐃: Rounds a number to a specified number of digits.
𝐑𝐎𝐔𝐍𝐃𝐔𝐏: Rounds a number up, away from zero, to the nearest multiple of significance.
𝐑𝐎𝐔𝐍𝐃𝐃𝐎𝐖𝐍: Rounds a number down, toward zero, to the nearest multiple of significance.
𝐈𝐅𝐄𝐑𝐑𝐎𝐑: Returns a value you specify if a formula evaluates to an error, otherwise returns the result of the formula.
𝐒𝐔𝐌𝐈𝐅: Adds the cells specified by a given condition or criteria.
𝐒𝐔𝐌𝐈𝐅𝐒: Adds the cells in a range that meet multiple criteria.
𝐀𝐕𝐄𝐑𝐀𝐆𝐄𝐈𝐅: Calculates the average of cells specified by a given condition or criteria.
𝐀𝐕𝐄𝐑𝐀𝐆𝐄𝐈𝐅𝐒: Calculates the average of cells that meet multiple criteria.
𝐂𝐎𝐔𝐍𝐓𝐈𝐅: Counts the number of cells specified by a given condition or criteria.
COUNTIFS: Counts the number of cells that meet multiple criteria.
RAND: Returns a random number between 0 and 1.
RANDBETWEEN: Returns a random number between the numbers you specify.
PI: Returns the value of pi (3.14159265358979).
POWER: Raises a number to a power.
SQRT: Returns the square root of a number.
LOG: Returns the logarithm of a number to the base you specify.
EXP: Returns e raised to the power of a given number.
MOD: Returns the remainder of a division operation.
INT: Rounds a number down to the nearest integer.
ABS: Returns the absolute value of a number.
AND: Returns TRUE if all its arguments are TRUE, and FALSE otherwise.
OR: Returns TRUE if any argument is TRUE, and FALSE otherwise.
NOT: Returns the opposite of a logical value.
SUMPRODUCT: Multiplies corresponding components in the given arrays, and returns the sum of those products.
TRANSPOSE: Transposes rows and columns in a range of cells.

t.me/data_visual/884