Skip to content
OmidBI Logo – Expert in Power Query, Excel, and Business Intelligence Solutions

OmidBI

  • By Difficulty
    • ⭐️ Beginner
    • ⭐️⭐️ Easy
    • ⭐️⭐️⭐️ Intermediate
    • ⭐️⭐️⭐️⭐️ Advanced
    • ⭐️⭐️⭐️⭐️⭐️Expert
    • ⭐️⭐️⭐️⭐️⭐️⭐️Complex
  • By Topic
    • Advanced Mathematics Problem
    • Aggregation & Summarization
    • Column Splitting
    • Column Transformation
    • Custom Grouping
    • Data Cleaning
    • Data Transformation
    • Date & Time Handling
    • Financial Problems
    • Indexing & Ranking
    • Merging & Joining
    • Missing Values
    • Pivot & Unpivot
    • Text Processing
  • By Creator
    • Omid Challenges
    • ExcelBI Excel Challenges
    • ExcelBI Power Query Challenges
    • Crispo Challenges
  • By Software
    • DAX Challenges
    • Excel Challenges
    • Excel VBA Challenges
    • Google Sheets Challenges
    • Office Script Challenges
    • Power Query Challenges
    • Python Challenges
    • R Challenges
    • SQL Challenges
  • Books
    • 96 Common Challenges in Power Query
Home » Challenges » By Difficulty » ⭐️ Beginner » Page 5

⭐️ Beginner

Easy challenges for newcomers.

Match Names with Same Initials
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Match Names with Same Initials

Challenge No. 612: List the names if first character of first name and first character of last name are same.
Solved using: Python.

January 2, 2026July 11, 2025
Count Unique Uncommon Words
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Count Unique Uncommon Words

Challenge No. 610: Find the number of un-common unique words between Sentence1 and Sentence2.
Solved using: Python.

January 1, 2026December 31, 2025
Find Missing AP Sequence
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Find Missing AP Sequence

Challenge No. 609: The first and last terms in an Arithmetic Progressions (AP) are given in each row.
Solved using: Python in Excel.

December 31, 2025December 31, 2025
Extract Zip and Country Info
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Extract Zip and Country Info

Challenge No. 608: Extract zip code (5 or 6 digits in length) and country names.
Solved using: Python.

December 31, 2025July 11, 2025
Merge and Sort Name Rows
Posted in
  • ExcelBI Excel Challenges
  • Merging & Joining
  • ⭐️ Beginner

Merge and Sort Name Rows

Challenge No. 606: Merge rows on the basis of names.
Solved using: Python.

December 30, 2025
Count Alphabetically Sorted Words
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Count Alphabetically Sorted Words

Challenge No. 601: Find the count of words in columns A through C if the words have sorted alphabets.
Solved using: Python in Excel.

December 27, 2025July 11, 2025
Match Words in Column Data
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Match Words in Column Data

Challenge No. 599: Look up the Words (in column D) in Column1 and list the Result from Column2.
Solved using: Python.

December 26, 2025July 11, 2025
Transpose table, summing values from
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️ Beginner

Transpose table, summing values from

Challenge No. 275: Transpose the problem table into result table where value is sum of Values from problem table.
Solved using: Python.

December 25, 2025July 14, 2025
Reapply Original Capitalization
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️ Beginner

Reapply Original Capitalization

Challenge No. 594: Work out the indexes where capital letters are.
Solved using: Python in Excel.

December 24, 2025July 11, 2025
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Sum of Numbers following Hashes

Challenge No. 591: .
Solved using: Python.

December 22, 2025July 11, 2025

Posts pagination

Previous 1 … 4 5 6 … 41 Next
  • 96 Common Challenges in Power Query
  • Advanced Mathematics Problem
  • Aggregation & Summarization
  • Books
  • Column Splitting
  • Column Transformation
  • Crispo Challenges
  • Custom Aggregation & Summarization
  • Custom Grouping
  • Data Cleaning
  • Data Transformation
  • data validation
  • Date & Time Handling
  • Excel Challenges
  • ExcelBI Excel Challenges
  • ExcelBI Power Query Challenges
  • Financial Problems
  • Indexing & Ranking
  • Merging & Joining
  • Missing Values
  • Omid Challenges
  • Pivot & Unpivot
  • Power Query Challenges
  • Python Challenges
  • Text Processing
  • ⭐️ Beginner
  • ⭐️⭐️ Easy
  • ⭐️⭐️⭐️ Intermediate
  • ⭐️⭐️⭐️⭐️ Advanced
  • ⭐️⭐️⭐️⭐️⭐️Expert
  • ⭐️⭐️⭐️⭐️⭐️⭐️Complex

BYROW CHAR CODE CONCAT DROP FILTER HSTACK IF IFERROR INDEX LAMBDA LEFT LEN LET List.Distinct List.Transform LOOKUP MAP MATCH MAX MID MONTH Python Python Automation Python for Data Analysis Python for Excel REDUCE ROW ROWS SCAN SEQUENCE SORT SUBSTITUTE Table.AddColumn Table.Group Table.SelectRows TAKE Text.Combine Text.Split TEXTJOIN TEXTSPLIT TOCOL UNIQUE VSTACK XLOOKUP

Recent Posts

  • Max Total on Consecutive Days
  • Extract Valid Year Ranges
  • Swap Grid Diagonals
  • Pivot with Total Line
  • Remove One Letter Palindrome

Recent Comments

No comments to show.
Copyright © 2026 OmidBI.
Powered by WordPress and HybridMag.
  • By Difficulty
    • ⭐️ Beginner
    • ⭐️⭐️ Easy
    • ⭐️⭐️⭐️ Intermediate
    • ⭐️⭐️⭐️⭐️ Advanced
    • ⭐️⭐️⭐️⭐️⭐️Expert
    • ⭐️⭐️⭐️⭐️⭐️⭐️Complex
  • By Topic
    • Advanced Mathematics Problem
    • Aggregation & Summarization
    • Column Splitting
    • Column Transformation
    • Custom Grouping
    • Data Cleaning
    • Data Transformation
    • Date & Time Handling
    • Financial Problems
    • Indexing & Ranking
    • Merging & Joining
    • Missing Values
    • Pivot & Unpivot
    • Text Processing
  • By Creator
    • Omid Challenges
    • ExcelBI Excel Challenges
    • ExcelBI Power Query Challenges
    • Crispo Challenges
  • By Software
    • DAX Challenges
    • Excel Challenges
    • Excel VBA Challenges
    • Google Sheets Challenges
    • Office Script Challenges
    • Power Query Challenges
    • Python Challenges
    • R Challenges
    • SQL Challenges
  • Books
    • 96 Common Challenges in Power Query