Complete MS Excel course for Data Analyst | Job Oriented

Product/Course Being Reviewed

The video is a walkthrough/promotion of a “Complete MS Excel course for Data Analyst | job oriented.” It focuses on Excel workflows for data analysts, with mentions of combining Excel with Python/Pandas/Power BI concepts for broader roles.

---

Main Features Taught (as presented in the subtitles)

1) Beginner-to-Intermediate Excel Fundamentals

• Workbooks vs. worksheets (spreadsheet concept)
• Ribbons/tabs/groups/menus
• Quick Access Toolbar customization
• Status bar and zoom
• Cells, rows, columns and naming convention (e.g., B2, C3)
• Selecting ranges and navigating within sheets

2) Core Usability Skills

• Column/row sizing via auto-adjust (double-click boundaries)
• Editing cells using 3 methods
  • Formula bar
  • F2
  • Double-click (preferred)
• Formatting
  • Font/background
  • Alignment
  • Text wrap
• Clear options
  • Clear All
  • Clear Contents
  • Clear Formats
• Insert/delete rows/columns using shortcuts (e.g., Ctrl + Shift + + / -)

3) Data Operations for Analysis

• Merge & Center concept, plus warning that it breaks table structure
  • Recommendation: use “Center Across Selection” instead
• Copy/paste + Paste Special
  • values only, formats only
• Arithmetic operations including:
  • Static vs dependent outputs
  • Cell referencing types: Relative, Absolute, Mixed
• AutoFill techniques:
  • duplicate
  • series/patterns
  • series with start/step/stop
• Built-in functions via AutoSum
  • SUM, AVERAGE, COUNT, MIN, MAX
• Drag behavior and referencing
  • relative referencing when dragging
  • locking constants (absolute referencing)

4) Data Wrangling / Cleaning (Excel Transformations)

“Wrangling” is framed as making messy data usable.

• Trim
• Remove Duplicates
• Find & Replace
• Case transformation: Upper / Lower / Proper
• Text processing for emails:
  • LEFT / RIGHT / MID
  • Text to Columns (delimiters and fixed width)
• Concatenation:
  • &
  • CONCATENATE
  • TEXTJOIN
• Flash Fill
  • AI-assisted extraction based on examples
  • described as fast but “dangerous” if data isn’t consistent

5) Date & Time Functions

• TODAY
• “Yesterday/tomorrow” via +/- 1 (no direct “yesterday” function mentioned)
• YEAR, MONTH, DAY
• HOUR / MINUTE / SECOND
• Date difference via DATEDIF (mentioned as possibly deprecated)
• Workday calculations:
  • NETWORKDAYS
  • WORKDAY

6) Charts for Timelines

• Gantt chart/timeline tracking
  • using stacked/bars chart approach
• Start/end, duration, and visual tracking
• Basic styling and axis adjustments

7) Logic and Decision Functions

• IF, IFS, SWITCH
• AND / OR for multi-condition logic
• Examples:
  • salary status (high/low)
  • performance based on rating
  • bonuses by department
• Comparison:
  • Switch described as less repetitive than IFS for many discrete mappings

8) Lookup Functions & Best Practices

• VLOOKUP (called “older” and discouraged if overused)
• HLOOKUP
• INDEX + MATCH (recommended alternative)
• XLOOKUP (presented as preferred “single” method)
• IFERROR for graceful handling of “not found”
• Approximate match with LOOKUP
  • requires sorting to avoid random results
• Recommendation:
  • prefer XLOOKUP, then INDEX/MATCH
  • avoid excessive VLOOKUP/HLOOKUP

9) Advanced Excel Data Prep

• Sorting (single and multi-level)
• Filtering:
  • standard filter
  • Advanced Filter with criteria ranges
• Grouping and subtotal:
  • sorting first
  • grouping by change in a category
  • Subtotals by department using SUM/AVERAGE/etc.

10) Power Query / Query Editor (Advanced Wrangling)

• “Crawling” concept: transformations performed automatically instead of manually with formulas
• Workflow:
  • Data → Get Data → transform → Power Query Editor
• Transform operations (examples):
  • remove columns
  • split columns
  • change data types
  • replace values
  • pivots
• Quality checks/profiling:
  • nulls, distinct values, errors
• Applied Steps history
  • renaming tables
  • promoting headers
• Cleaning inside Power Query:
  • trim text
  • replace errors (#…/hash error) with NA
  • replace nulls with NA/not available
  • convert data types (dates, currency)
• Add columns:
  • index column
  • conditional/custom columns
  • extract from email using “before @”
• Merge Queries and Append Queries
  • merge on common key (e.g., department)
  • append adds rows; warns columns must align to avoid issues
• Reshaping:
  • transpose (row↔column concept)
  • unpivot (columns → attribute/value rows)
  • pivot (attribute/value rows → columns)

11) Modeling Concept (Start of Later Module)

• Fact vs dimension/lookup tables:
  • Fact table (main measurements)
  • Dimension/lookup table (descriptions)
• Begins “data modeling” and relationship building, but stops mid-explanation in the subtitles

---

Pros Mentioned (Explicit/Implicit)

• Job-oriented, end-to-end coverage
  • beginner foundations → analytical workflows (functions, wrangling, Power Query, charts, logic, lookups, date/time)
• Practical focus with examples
  • email parsing, salary/performance logic, lookups, Gantt/timeline
• Best-practice guidance
  • avoid Merge & Center breaking structure (use Center Across Selection)
  • prefer efficient lookups (XLOOKUP, then INDEX/MATCH)
  • use IFERROR for cleaner results
  • Power Query reduces manual formula work

---

Cons Mentioned (Explicit)

• Merge & Center is called problematic:
  • breaks structure/table flow
  • may cause cells/formatting “disappear” below
• Flash Fill is “dangerous” if patterns aren’t clear/inconsistent
• Some functions are discouraged:
  • VLOOKUP described as older/time-consuming
  • LOOKUP approximate match can be random if data isn’t sorted first
• No formal “negative rating” system; criticism is mostly about misuse of features

---

Comparisons Made

• Excel + Python/Pandas/Power BI referenced as part of a broader analyst/data scientist pipeline (Python suggested for deeper roles)
• Lookups:
  • VLOOKUP/HLOOKUP vs INDEX+MATCH vs XLOOKUP
  • XLOOKUP presented as the preferred approach
• Logic:
  • IF vs IFS vs SWITCH
  • Switch less repetitive when mapping many discrete cases

---

User Experience / Learning Style

• Described as a long course (~6 hours video length mentioned)
• Teaches both:
  • concepts (definitions/why)
  • step-by-step operations (menus, shortcuts, where to click)
• A breadth-first approach: many topics covered with examples and warnings

---

Numerical Info / Ratings

• Course length: about 6 hours (video length mentioned)
• No star rating or score-out-of-10 style metric provided in subtitles

---

Unique Points List (Distinct Topics/Claims Mentioned)

• Job-oriented Excel course for data analysts
• Beginner → intermediate progression
• Mentions Excel as “no-code” alongside Power BI; Python for expanded roles
• Workbook vs worksheet; ribbons/navigation; Quick Access Toolbar
• Cells/rows/columns and naming conventions (A1/B2 etc.)
• Selection/navigation (keyboard/mouse)
• Auto-adjust sizing via double-click boundaries
• Editing methods (formula bar vs F2 vs double-click)
• Formatting basics (alignment, wrap, fonts/colors)
• Clear All / Contents / Formats
• Merge & Center vs Center Across Selection
• Paste Special shortcuts (values/formats)
• Undo/Redo and saving concepts
• AutoFill (duplicates/series/pattern generation)
• Referencing types (relative/absolute/mixed) with $
• Core aggregates via AutoSum (SUM/AVERAGE/COUNT/MIN/MAX)
• Derived metric example using multiplication
• Date wrangling and functions (TODAY, +/-1, YEAR/MONTH/DAY, HOUR/MINUTE/SECOND, DATEDIF)
• Workday functions (NETWORKDAYS, WORKDAY)
• Gantt/timeline tracking using bar charts
• IF/AND/OR/IFS/SWITCH comparisons
• Lookup guidance (VLOOKUP/HLOOKUP discouraged; prefer XLOOKUP/INDEX-MATCH; IFERROR; approximate match sorting warning)
• Sorting/filtering/subtotals (including Advanced Filter)
• Wrangling definition + transformation concepts (Trim/Remove Duplicates/Find & Replace)
• Email parsing with LEFT/RIGHT/MID and Text to Columns
• Concatenation with &, CONCATENATE, TEXTJOIN (including delimiter behavior)
• Flash Fill with a risk warning
• Power Query end-to-end steps (Get Data → Editor), profiling, Applied Steps, merges/append, pivot/unpivot/transpose
• Modeling begins (fact vs dimension tables and relationships)

---

Speaker Contribution Views (as Inferred from Subtitles)

• Main instructor (Dhanesh Bhaiya):
  • core instruction, examples, and best-practice guidance (merge warning, lookup recommendations, Power Query workflow)
• Host/intro speaker:
  • frames the course as complete job-oriented learning
  • positions it alongside ML/Python/Pandas/Power BI
  • introduces the instructor

---

Concise Verdict / Recommendation

Recommended if you want a job-oriented, practical, end-to-end Excel-to-analyst workflow, including:

• formulas (referencing + logic + lookups)
• data cleaning (wrangling)
• Power Query (merge/append/pivot/unpivot)

It appears especially useful for beginners moving toward intermediate data analyst tasks, with clear “how-to” steps and cautions about common pitfalls like Merge & Center, Flash Fill misuse, and VLOOKUP overuse.