Post #1317

Excel Cheat Sheet📔 This Excel cheatsheet is designed to be your quick reference guide for using Microsoft Excel efficiently. 1. Basic Functions - SUM: =SUM(range) - AVERAGE: =AVERAGE(range) - COUNT: =COUNT(range) - MAX: =MAX(range) - MIN: =MIN(range) 2. Text Functions - CONCATENATE: =CONCATENATE(text1, text2, ...) or =TEXTJOIN(delimiter, ignore_empty, text1, text2, ...) - LEFT: =LEFT(text, num_chars) - RIGHT: =RIGHT(text, num_chars) - MID: =MID(text, start_num, num_chars) - TRIM: =TRIM(text) 3. Logical Functions - IF: =IF(condition, true_value, false_value) - AND: =AND(condition1, condition2, ...) - OR: =OR(condition1, condition2, ...) - NOT: =NOT(condition) 4. Lookup Functions - VLOOKUP: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) - HLOOKUP: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) - INDEX: =INDEX(array, row_num, [column_num]) - MATCH: =MATCH(lookup_value, lookup_array, [match_type]) 5. Data Sorting & Filtering - Sort: *Data > Sort* - Filter: *Data > Filter* - Advanced Filter: *Data > Advanced* 6. Conditional Formatting - Apply Formatting: *Home > Conditional Formatting > New Rule* - Highlight Cells: *Home > Conditional Formatting > Highlight Cells Rules* 7. Charts and Graphs - Insert Chart: *Insert > Select Chart Type* - Customize Chart: *Chart Tools > Design/Format* 8. PivotTables - Create PivotTable: *Insert > PivotTable* - Refresh PivotTable: *Right-click on PivotTable > Refresh* 9. Data Validation - Set Validation: *Data > Data Validation* - List: *Allow: List > Source: range or items* 10. Protecting Data - Protect Sheet: *Review > Protect Sheet* - Protect Workbook: *Review > Protect Workbook* 11. Shortcuts - Copy: Ctrl + C - Paste: Ctrl + V - Undo: Ctrl + Z - Redo: Ctrl + Y - Save: Ctrl + S 12. Printing Options - Print Area: *Page Layout > Print Area > Set Print Area* - Page Setup: *Page Layout > Page Setup* Checklist for Data Analyst: https://dataanalytics.beehiiv.com/p/data I have curated best 80+ top-notch Data Analytics Resources 👇👇 https://t.me/DataSimplifier Like for more Interview Resources ♥️ Share with credits: https://t.me/sqlspecialist Hope it helps :)