Excel For Data Analytics
June 18, 2025 at 07:49 AM
*📊 Master Microsoft Excel :*
The Excel Tree 👇
|
|── *Basics*
| ├── Workbook / Worksheet
| ├── Rows & Columns
| └── Cells & Ranges
|
|── *Data Entry & Formatting*
| ├── Text / Numbers / Dates
| ├── Cell Formatting (bold, color, borders)
| ├── Conditional Formatting
| └── Cell Styles & Themes
|
|── *Formulas & Functions*
| ├── `=SUM()`, `=AVERAGE()`
| ├── `=IF()`, `=AND()`, `=OR()`
| ├── `=VLOOKUP()` / `=HLOOKUP()` / `=XLOOKUP()`
| ├── `=INDEX()` / `=MATCH()`
| └── `=COUNT()`, `=COUNTA()`, `=COUNTIF()`
|
|── *Charts & Graphs*
| ├── Bar / Line / Pie / Column
| ├── Combo Charts
| └── Sparklines
|
|── *Data Tools*
| ├── Data Validation
| ├── Remove Duplicates
| ├── Text to Columns
| └── Flash Fill
|
|── *Sorting & Filtering*
| ├── AutoFilter
| ├── Custom Sort
| └── Advanced Filter
|
|── *Pivot Tables & Pivot Charts*
| ├── Summarize large data
| ├── Drag & drop interface
| └── Slicers for filtering
|
|── *Tables & Named Ranges*
| ├── Excel Tables (Insert > Table)
| └── Named Ranges for easy reference
|
|── *Date & Time Functions*
| ├── `=TODAY()`, `=NOW()`
| ├── `=DATEDIF()`, `=EDATE()`
| └── `=TEXT()` for formatting
|
|── *Text Functions*
| ├── `=LEFT()`, `=RIGHT()`, `=MID()`
| ├── `=LEN()`, `=FIND()`, `=SEARCH()`
| └── `=CONCAT()` / `=TEXTJOIN()`
|
|── *Logical & Lookup Functions*
| ├── `=IFERROR()`
| ├── `=CHOOSE()`
| └── `=SWITCH()`
|
|── *Keyboard Shortcuts*
| ├── Ctrl + Arrow → Jump
| ├── Ctrl + Shift + L → Filter
| └── F2 → Edit Cell
|
|── *Macros & Automation*
| ├── Record Macros
| └── VBA (Visual Basic for Applications)
|
|── *Data Analysis Tools*
| ├── Goal Seek
| ├── Solver
| └── What-If Analysis
|
|── *Best Practices*
| ├── Use tables for dynamic data
| ├── Use comments & named ranges
| └── Avoid merged cells in data tables
|
|── END __
💬 *Double Tap ❤️ if this helped you!*
❤️
❤
👍
♥
👏
🙏
🇵🇸
🔥
😂
😢
123