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 17

⭐️ Beginner

Easy challenges for newcomers.

Draw Inverted Triangle Shape
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Draw Inverted Triangle Shape

Challenge No. 372: Draw inverted right angled triangles as shown for an r value.
Solved using: Python.

September 4, 2025July 22, 2025
List Cyclops Palindromic Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

List Cyclops Palindromic Numbers

Challenge No. 370: A Cyclops number is a number that has a zero in the center (so, it needs to have odd number of digits).
Solved using: Python.

September 3, 2025July 22, 2025
Perform Faro Shuffle Types
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Perform Faro Shuffle Types

Challenge No. 369: Faro Shuffle – Divide the data in two equal parts (data will always be even, so two equal parts).
Solved using: DAX.

September 2, 2025July 21, 2025
Find Word by Exact Index
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️ Beginner

Find Word by Exact Index

Challenge No. 367: Capture the word starting at given index.
Solved using: Python.

September 1, 2025July 21, 2025
Alternate Letters and Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Alternate Letters and Numbers

Challenge No. 366: Arrange the given characters in such a fashion that alphabets occupy all odd positions and numbers occupy even position in the order in which they appear.
Solved using: Python.

September 1, 2025July 21, 2025
One Digit Equals Other Sum
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

One Digit Equals Other Sum

Challenge No. 365: List the numbers where one digit is equal to sum of other digits.
Solved using: R.

August 31, 2025July 21, 2025
Sequential Digit Difference Match
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Sequential Digit Difference Match

Challenge No. 364: List the numbers where absolute difference between two succeeding digits is 1, 2, 3, 4.
Solved using: Python.

August 31, 2025July 21, 2025
Uppercase Letters Around Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Uppercase Letters Around Numbers

Challenge No. 362: Convert the English letters around a number to upper case.
Solved using: Python in Excel.

August 30, 2025July 21, 2025
Stack Matrix Diagonals Horizontally
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Stack Matrix Diagonals Horizontally

Challenge No. 358: Stack both the diagonals of n x n metrices horizontally.
Solved using: Python in Excel.

August 28, 2025July 21, 2025
Build Dictionary Excluding Vowels
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Build Dictionary Excluding Vowels

Challenge No. 357: Prepare dictionary entries from Key Value pairs.
Solved using: Python in Excel.

August 27, 2025July 21, 2025

Posts pagination

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