
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