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 22

⭐️ Beginner

Easy challenges for newcomers.

Max Call Duration Pair
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Max Call Duration Pair

Challenge No. 298: Work our the pair of persons for whom the sum of call duration is the highest.
Solved using: Python in Excel.

July 29, 2025July 21, 2025
Evaluate Reverse Polish Notation
Posted in
  • ExcelBI Excel Challenges
  • Text Processing
  • ⭐️ Beginner

Evaluate Reverse Polish Notation

Challenge No. 297: Simplified version of Reverse Polish Notation (RPN) – The math operator will come at the end of the Text and you need to evaluate the expression.
Solved using: Python in Excel.

July 28, 2025July 21, 2025
Lookup Date When Target was Hit
Posted in
  • Crispo Challenges
  • Date & Time Handling
  • ⭐️ Beginner

Lookup Date When Target was Hit

Challenge No. 49: Lookup the date when the staff total sales hit or exceeded the target
Current target is 800, but needs to be dynamic
e.
Solved using: Python.

July 27, 2025July 11, 2025
Generate Remaining Count Sentences
Posted in
  • ExcelBI Excel Challenges
  • Text Processing
  • ⭐️ Beginner

Generate Remaining Count Sentences

Challenge No. 295: Generate the given text from cell A2 onwards as per value given in cell A1.
Solved using: Python in Excel.

July 27, 2025July 21, 2025
List Tautonym words
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

List Tautonym words

Challenge No. 294: List Tautonym words.
Solved using: Python in Excel.

July 27, 2025July 21, 2025
Words in Alphabetical Order
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Words in Alphabetical Order

Challenge No. 293: Provide a formula to list all words from A2:A10 where English alphabets appear in alphabetical order.
Solved using: Python in Excel.

July 26, 2025July 21, 2025
Find Perfect Square Dates
Posted in
  • Date & Time Handling
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Find Perfect Square Dates

Challenge No. 292: List all dates in 21st century which are perfect square dates.
Solved using: Python.

July 26, 2025July 21, 2025
Reverse data given in rows
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Reverse data given in rows

Challenge No. 291: Reverse data given in rows.
Solved using: Python in Excel.

July 25, 2025July 21, 2025
Matches With Equal Goal Difference
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Matches With Equal Goal Difference

Challenge No. 290: List the matches where goal difference is same.
Solved using: Python in Excel.

July 25, 2025July 21, 2025
Pair and Sort People
Posted in
  • Custom Grouping
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Pair and Sort People

Challenge No. 288: Make groups of 2 persons each in sequence and sort them.
Solved using: Python in Excel.

July 24, 2025July 21, 2025

Posts pagination

Previous 1 … 21 22 23 … 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