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 13

⭐️ Beginner

Easy challenges for newcomers.

Custom String Sorting
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Custom String Sorting

Challenge No. 461: Sort the given strings as given in the answer.
Solved using: Python.

October 18, 2025July 23, 2025
Insert Dashes After N Characters
Posted in
  • Custom Grouping
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Insert Dashes After N Characters

Challenge No. 460: Insert the dashes after every N characters.
Solved using: Excel VBA.

October 18, 2025July 23, 2025
Next Perfect Square Finder
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Next Perfect Square Finder

Challenge No. 459: Find the next perfect square numbers.
Solved using: Excel VBA.

October 17, 2025July 23, 2025
Monthly Running Max Total
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️ Beginner

Monthly Running Max Total

Challenge No. 198: Find the running total on the basis of max value for the month.
Solved using: Python.

October 17, 2025July 14, 2025
Longest Uppercase Substring
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Longest Uppercase Substring

Challenge No. 458: Extract the substrings which have longest sequence of capital (uppercase) letters in given words.
Solved using: Python.

October 17, 2025July 23, 2025
Extract Numbers in Parentheses
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Extract Numbers in Parentheses

Challenge No. 457: Extract the numbers if they are within parenthesises.
Solved using: Python in Excel.

October 16, 2025July 23, 2025
Extract Special Characters Only
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Extract Special Characters Only

Challenge No. 456: Extract special characters from given strings.
Solved using: R.

October 16, 2025July 23, 2025
Group Per Month
Posted in
  • Crispo Challenges
  • Custom Grouping
  • ⭐️ Beginner

Group Per Month

Challenge No. 60: Group the customers per month.
Solved using: Python.

October 15, 2025July 11, 2025
Count Numbers from Ranges
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Count Numbers from Ranges

Challenge No. 454: Today’s challenge is contributed by Sunny Baggu
Extract the total numbers in the problem strings.
Solved using: Python in Excel.

October 15, 2025July 23, 2025
Common Entries and Count
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Common Entries and Count

Challenge No. 453: Today’s challenge is contributed by Mehmet Çiçek
Find the common entries in List1 and List2 and common count.
Solved using: Excel VBA.

October 14, 2025July 23, 2025

Posts pagination

Previous 1 … 12 13 14 … 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