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 8

⭐️ Beginner

Easy challenges for newcomers.

Rank Players by Uppercase
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️ Beginner

Rank Players by Uppercase

Challenge No. 545: There are 6 players (q, w, e, r, t, y) and if a player wins, it appears in upper case and if it loses, then it appears in lower case.
Solved using: Python.

November 29, 2025July 30, 2025
Prepare the result table on
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️ Beginner

Prepare the result table on

Challenge No. 247: Prepare the result table on the basis of problem tables 1 & 2.
Solved using: Python.

November 29, 2025July 14, 2025
First and Last Number Sum
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

First and Last Number Sum

Challenge No. 544: Extract the first and last set of numbers appearing in A2:A10 and sum them.
Solved using: R.

November 29, 2025July 30, 2025
Top Two Department Salaries
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Top Two Department Salaries

Challenge No. 543: Find out the top 2 salaries in all departments.
Solved using: Python in Excel.

November 28, 2025July 30, 2025
Create Text-Based Square
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Create Text-Based Square

Challenge No. 542: Generate the given squares from the given strings.
Solved using: Excel VBA.

November 28, 2025July 30, 2025
Find Triangle with Given Area
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Find Triangle with Given Area

Challenge No. 540: Find the perpendicular and base for a right angled triangle where Hypotenuse and Area are given.
Solved using: Python in Excel.

November 27, 2025July 30, 2025
Sum and Sort Student Marks
Posted in
  • ExcelBI Power Query Challenges
  • Merging & Joining
  • ⭐️ Beginner

Sum and Sort Student Marks

Challenge No. 244: Merge both problem tables into one by summing marks for common entries.
Solved using: Python.

November 26, 2025July 14, 2025
Fill 5×5 Grid with Index
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Fill 5×5 Grid with Index

Challenge No. 536: Put values in a 5×5 grid as per their rows and columns positions.
Solved using: R.

November 25, 2025July 30, 2025
Draw Grid by Rows/Columns
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Draw Grid by Rows/Columns

Challenge No. 535: This problem was contributed by Mehmet Çiçek.
Solved using: Python in Excel.

November 24, 2025July 30, 2025
Max Sale Date and Amount
Posted in
  • Date & Time Handling
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Max Sale Date and Amount

Challenge No. 530: Find the dates when maximum sales was made for a person and also list the corresponding amount.
Solved using: Python.

November 22, 2025July 30, 2025

Posts pagination

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