TGViewer
MS Excel for Data Analysis MS Excel for Data Analysis @excel_analyst ยท 73.3K subscribers
Post #2027 5.67K
๐Ÿ“Š Learn Microsoft Excel in 14 Days:

๐ŸŸข Day 1 โ€“ Excel Interface & Basics
Understand Excel layout, ribbons, cells, rows, columns, and basic navigation.

๐Ÿ“ Day 2 โ€“ Data Entry & Formatting
Learn to enter/edit data, use formatting tools (bold, color, borders, alignment).

โž• Day 3 โ€“ Basic Formulas
Use SUM(), AVERAGE(), MIN(), MAX(), and simple arithmetic formulas.

๐Ÿ” Day 4 โ€“ Cell Referencing
Understand relative, absolute, and mixed references using $.

๐Ÿ“‹ Day 5 โ€“ Sorting & Filtering
Sort data (A-Z, Z-A) and apply filters to analyze specific data quickly.

๐Ÿ“ Day 6 โ€“ Conditional Formatting
Highlight data using rules (greater than, color scales, data bars).

๐Ÿ“Š Day 7 โ€“ Charts & Graphs
Create and customize pie, bar, line charts for data visualization.

๐Ÿ” Day 8 โ€“ Logical Functions
Learn IF(), AND(), OR(), IFERROR() for decision-making in formulas.

๐Ÿ“ˆ Day 9 โ€“ Lookup Functions
Use VLOOKUP(), HLOOKUP(), and XLOOKUP() to fetch data from tables.

๐Ÿงฉ Day 10 โ€“ Text Functions
Learn CONCAT(), TEXT(), LEFT(), RIGHT(), LEN(), TRIM().

๐Ÿ“† Day 11 โ€“ Date & Time Functions
Work with TODAY(), NOW(), DATEDIF(), TEXT() for date/time formatting.

๐Ÿ” Day 12 โ€“ Data Validation
Restrict data input using drop-downs, number/text rules, and error messages.

๐Ÿ“Ž Day 13 โ€“ Pivot Tables
Summarize large datasets using Pivot Tables for quick insights.

๐Ÿš€ Day 14 โ€“ Final Dashboard Project
Build a simple Excel dashboard using charts, pivot tables & conditional formatting.

โค๏ธ React for more!
  • โค 43
More from @excel_analyst
  1. Oct 13, 2026๐Ÿ“Š Excel Interview Questions โ€” Part 1 1๏ธโƒฃ What is the difference between VLOOKUP and XLOOKโ€ฆ
  2. Oct 13, 2026๐—ง๐—ข๐—ฃ ๐—™๐—ฅ๐—˜๐—˜ ๐—–๐—ข๐—จ๐—ฅ๐—ฆ๐—˜๐—ฆ ๐—ง๐—ข ๐—•๐—ข๐—ข๐—ฆ๐—ง ๐—ฌ๐—ข๐—จ๐—ฅ ๐—ฆ๐—ž๐—œ๐—Ÿ๐—Ÿ๐—ฆ ๐—œ๐—ก ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฒ! Explorโ€ฆ
  3. Oct 12, 2026๐Ÿ“Š Excel Shortcuts โ€” Part 7 This part focuses on Paste Special, Go To Special & Advanced Pโ€ฆ
  4. Oct 12, 2026๐Ÿš€ ๐—ช๐—ต๐—ถ๐—ฐ๐—ต ๐—ง๐—ฒ๐—ฐ๐—ต ๐—ฆ๐—ธ๐—ถ๐—น๐—น ๐—ช๐—ถ๐—น๐—น ๐—ฌ๐—ผ๐˜‚ ๐— ๐—ฎ๐˜€๐˜๐—ฒ๐—ฟ ๐—ถ๐—ป ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฒ? Want to builโ€ฆ
  5. Oct 10, 2026๐Ÿ“Š Excel Shortcuts โ€” Part 6 This part focuses on Worksheet & Sheet Management shortcuts โ€”โ€ฆ
  6. Oct 9, 2026Hey guys, Today, Iโ€™m covering some Excel interview questions that often pop up in data anaโ€ฆ
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook โ†’Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 โ†’