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 :)