Abhishek

Day 1 of Posting on X consistently until I become eligible for payout

Stop wasting time pasting rows manually. Try using VSTACK instead to combine your tables instantly! #ExcelTips #SpreadsheetHacks #OfficeProductivity

Filter out department name in seconds in Excel #excel #exceltips #excelformulas #exceltricks

Slicer in Excel #excel #exceltips

Top 15 Excel functions XLOOKUP - looks any direction, no column counting, optional fallback for missing values VLOOKUP - old, still everywhere. Forgetting the FALSE argument returns a wrong value silently INDEX-MATCH - more flexible than VLOOKUP, doesn't need the return column to be on the right IF - the backbone every other advanced formula is built on SUMIFS - add up numbers across multiple conditions at once COUNTIFS - same structure as SUMIFS, counts instead of sums IFERROR - turns a raw error into something that looks finished TRIM - strips invisible spaces that silently break lookups TEXTJOIN - combines cells with a separator, skips blanks automatically ROUND - changes the actual stored value, not just how it displays DATEDIF - years, months, or days between two dates. Hidden from autocomplete, still works RANK - ranks a value against a full list SUMPRODUCT - multiplies and sums in one shot, no helper column UNIQUE - pulls distinct values instantly, updates live CONCATENATE or & - stitches text and numbers together for a couple of cells

Lookup family in Excel

Flashfill in Excel

If i had to prepare for interview for data analyst in 7 days this is what I will do

Q: Table orders(order_id, customer_id, order_date, amount). Find customers who ordered in every month of 2024. A) GROUP BY customer_id HAVING COUNT(*)=12 B) GROUP BY customer_id HAVING COUNT(DISTINCT MONTH(order_date))=12 C) GROUP BY customer_id, MONTH(order_date) HAVING COUNT(*)=12 D) SELECT DISTINCT customer_id WHERE YEAR(order_date)=2024 Answer: B - counts distinct months per customer; A/C/D don't enforce all 12 months. #sql #sqlbasics #sqlinterview #sqldatatypes

Top 15 Excel Formulas