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 26

⭐️ Beginner

Easy challenges for newcomers.

Find All Happy Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Find All Happy Numbers

Challenge No. 255: List all the Happy numbers.
Solved using: Excel VBA.

July 7, 2025July 11, 2025
Strings With Asterisks Between Letters
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Strings With Asterisks Between Letters

Challenge No. 254: List those strings which contain at least 3 asterisks between English alphabets.
Solved using: Power Query.

July 7, 2025July 11, 2025
Convert Numbers to Expanded Form
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Convert Numbers to Expanded Form

Challenge No. 252: Write the numbers in expanded form.
Solved using: Python in Excel.

July 6, 2025July 11, 2025
Classify Password Strength
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Classify Password Strength

Challenge No. 250: Classify the given passwords as
Invalid – If less than 8 characters
If >= 8 Characters
Weak – Contains only alphabets or only numbers or only special characters
Strong – Contains either alphabets+numbers or alphabets+special characters or numbers+special characters
Very Strong – Contains all 3 i.
Solved using: Excel VBA.

July 5, 2025July 11, 2025
Month and Quarter by Index
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Month and Quarter by Index

Challenge No. 248: Print the name of month & quarter as per position of 1.
Solved using: Power Query.

July 4, 2025July 11, 2025
Case-Sensitive Reverse Cipher
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Case-Sensitive Reverse Cipher

Challenge No. 247: This problem is an extension of first challenge.
Solved using: Excel VBA.

July 3, 2025July 11, 2025
Sort Words by End Digit
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Sort Words by End Digit

Challenge No. 246: All words have a one digit number as its last character.
Solved using: Power Query.

July 3, 2025July 11, 2025
Identify Diamond Strings
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Identify Diamond Strings

Challenge No. 245: List all Diamond strings from column A.
Solved using: R.

July 2, 2025July 11, 2025
Find Super Palindromes
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Find Super Palindromes

Challenge No. 244: List all Super-palindromes from column A.
Solved using: Python in Excel.

July 2, 2025July 11, 2025
Decrypt Polybius Cipher Grid
Posted in
  • ExcelBI Excel Challenges
  • Text Processing
  • ⭐️ Beginner

Decrypt Polybius Cipher Grid

Challenge No. 243: Polybius Cipher Decrypter –
Decrypt the text in column I as per grid in A2:G8.
Solved using: Excel VBA.

July 1, 2025July 11, 2025

Posts pagination

Previous 1 … 25 26 27 … 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