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 16

⭐️ Beginner

Easy challenges for newcomers.

Validate Point Connectivity Rule
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Validate Point Connectivity Rule

Challenge No. 395: Coordinates for points are given in x, y format.
Solved using: DAX.

September 15, 2025July 23, 2025
Generate Axis for Four Quadrants
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Generate Axis for Four Quadrants

Challenge No. 389: Generate X and Y axes of all 4 quadrants for value given in A1.
Solved using: R.

September 12, 2025July 22, 2025
Last Weekday of Each Month
Posted in
  • Date & Time Handling
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Last Weekday of Each Month

Challenge No. 387: For a date given in cell A1, generate the last Mon through Sun of the month
-1 : Last
-2 : 2nd Last.
Solved using: Python.

September 11, 2025July 22, 2025
Extract Signed Numbers from Text
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Extract Signed Numbers from Text

Challenge No. 383: Extract the unique positive and negative numbers if they are immediately preceded by either plus or minus sign.
Solved using: Python.

September 9, 2025July 22, 2025
Draw Square With X Pattern
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Draw Square With X Pattern

Challenge No. 380: Draw an N x N square where sides and diagonals are filled with x.
Solved using: Python.

September 8, 2025July 22, 2025
Numbers With Larger Successors
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Numbers With Larger Successors

Challenge No. 379: List all the numbers where all succeeding numbers are larger than the number.
Solved using: Python.

September 7, 2025July 22, 2025
Multiply Fibonacci and Lucas Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Multiply Fibonacci and Lucas Numbers

Challenge No. 376: Lucas Numbers – A term is sum of immediate previous two terms.
Solved using: Python.

September 6, 2025July 22, 2025
Convert Marks to Grade Points
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Convert Marks to Grade Points

Challenge No. 375: Calculate the grade points for given marks.
Solved using: Python in Excel.

September 5, 2025July 22, 2025
Find Palindromes by One Deletion
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Find Palindromes by One Deletion

Challenge No. 374: A Palindrome word is that which is same even read backwards.
Solved using: Python in Excel.

September 5, 2025July 22, 2025
Count Digits in Square Range
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Count Digits in Square Range

Challenge No. 373: Count the number of of Ds into square of numbers from N1 to N2 (both inclusive).
Solved using: Python.

September 4, 2025July 22, 2025

Posts pagination

Previous 1 … 15 16 17 … 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