📊 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 __
══════════════
📱 Connect With Us
Ⓣ Tiktok:
https://www.tiktok.com/@techaihub2?_r=1&_t=ZS-98yARrQhX0S
Ⓣ Telegram:
https://t.me/TechAIHub1
ⓕ Facebook:
https://www.facebook.com/TechandAIHub
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 __
══════════════
📱 Connect With Us
Ⓣ Tiktok:
https://www.tiktok.com/@techaihub2?_r=1&_t=ZS-98yARrQhX0S
Ⓣ Telegram:
https://t.me/TechAIHub1
ⓕ Facebook:
https://www.facebook.com/TechandAIHub