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!*