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 9

⭐️ Beginner

Easy challenges for newcomers.

Signed Number String Sum
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Signed Number String Sum

Challenge No. 529: Extract the numbers and sum them along with their signs.
Solved using: Python in Excel.

November 21, 2025July 30, 2025
Index-wise Base Encoding Sort
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️ Beginner

Index-wise Base Encoding Sort

Challenge No. 527: Convert every digit from right to left in the base of its index + 1 reading index 1, 2.
Solved using: Python.

November 20, 2025July 30, 2025
Build Alphabet Staircase
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Build Alphabet Staircase

Challenge No. 523: Make the staircase of alphabets.
Solved using: Excel VBA.

November 18, 2025July 30, 2025
List Dates with Unique Digits
Posted in
  • Date & Time Handling
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

List Dates with Unique Digits

Challenge No. 521: List all dates containing unique digits between 1900-01-01 to 2999-12-31.
Solved using: Python in Excel.

November 17, 2025July 30, 2025
Rank by Student Grade
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️ Beginner

Rank by Student Grade

Challenge No. 518: Rank the students on the basis of grades.
Solved using: Python.

November 16, 2025July 30, 2025
Normalize Tabular Data
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Normalize Tabular Data

Challenge No. 515: Normalize the data given in columns A to B as given in Answer Expected.
Solved using: Python.

November 14, 2025
Max 2×2 Grid Sum
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Max 2×2 Grid Sum

Challenge No. 514: Find the 2×2 grids in the given 5×5 grid where sum is the maximum.
Solved using: Python in Excel.

November 14, 2025July 23, 2025
Sort by Unit Digit
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Sort by Unit Digit

Challenge No. 513: Sort the numbers on the basis of unit digit (last digit).
Solved using: Python.

November 13, 2025July 23, 2025
Shift Rows into Columns
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️ Beginner

Shift Rows into Columns

Challenge No. 225: Transpose the problem table into result table.
Solved using: Python.

November 13, 2025July 14, 2025
Extract and SuM
Posted in
  • Crispo Challenges
  • ⭐️ Beginner

Extract and SuM

Challenge No. 71: Extract the buying and selling prices, then calculate profit/loss.
Solved using: R.

November 11, 2025July 11, 2025

Posts pagination

Previous 1 … 8 9 10 … 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