Excel Challenges
90 videos • 427 views • by excelwithExcel
Explained Excel Challenges (mostly LinkedIn Challenges from Excel BI, Omid Motamedisedeh, Crispo Mwangi & Dinc Doga)
1
Excel BI Challenge 040 - Common Characters
excelwithExcel
Download
2
Excel BI Challenge 043 - Skills Checker 2
excelwithExcel
Download
3
Excel BI Challenge 044 - Pair Finding Lowest Difference
excelwithExcel
Download
4
Excel BI Challenge 046 - Teams Won
excelwithExcel
Download
5
Excel BI Challenge 047 - Palindrome
excelwithExcel
Download
6
Excel BI Challenge 048 - Sort Cities
excelwithExcel
Download
7
Excel BI Challenge 049 - Numbers in Increasing Order
excelwithExcel
Download
8
Excel BI Challenge 050 - Anagram
excelwithExcel
Download
9
Excel BI Challenge 071 - No of Wins
excelwithExcel
Download
10
Excel BI Challenge 072 - Runners Up but Never Won Top 2
excelwithExcel
Download
11
Excel BI Challenge 074 - Avg Span of Winning
excelwithExcel
Download
12
Excel BI Challenge 075 - Goals Scored in Finals
excelwithExcel
Download
13
Excel BI Challenge 076 - Newcomers
excelwithExcel
Download
14
Excel BI Challenge 077 - Elo Ratings
excelwithExcel
Download
15
Excel BI Challenge 078 - Top 4 Teams including Runners Up
excelwithExcel
Download
16
Excel BI Challenge 111 - Number of English Alphabets
excelwithExcel
Download
17
Excel BI Challenge 115 - Beautiful Strings
excelwithExcel
Download
18
Excel BI Challenge 116 - Sort the String
excelwithExcel
Download
19
Excel BI Challenge 117 - Highest Medals
excelwithExcel
Download
20
Excel BI Challenge 118 - Binary to Decimal
excelwithExcel
Download
21
Excel BI Challenge 123 - US Presidents 3
excelwithExcel
Download
22
Excel BI Challenge 128 - Split the Words
excelwithExcel
Download
23
Excel BI Challenge 130 - Capitalize First & Last Letters
excelwithExcel
Download
24
Easy Excel Challenge 21st July 24
excelwithExcel
Download
25
Excel BI Challenge 504 - US Presidents All First Chars Same
excelwithExcel
Download
26
Excel BI Challenge 138 - US Presidents 4
excelwithExcel
Download
27
Excel BI Challenge 139 - Vowel Finish Start
excelwithExcel
Download
28
Excel BI Challenge 140 - Common Letters
excelwithExcel
Download
29
Excel BI Challenge 143 - Harshad Number
excelwithExcel
Download
30
Mutliple Criteria XLOOKUP - Every Other Day Excel and Power Query Challenges No.87 by Omid
excelwithExcel
Download
31
Excel BI Challenge 146 - Pangram
excelwithExcel
Download
32
Excel BI Challenge 147 - Narcissistic Number
excelwithExcel
Download
33
Excel BI Challenge 152 - Remove Words
excelwithExcel
Download
34
Excel BI Challenge 158 - Highest Duration
excelwithExcel
Download
35
2D Lookups in Excel (practical use) - Every Other Day Excel and Power Query Challenges No.90 by Omid
excelwithExcel
Download
36
Excel BI Challenge 172 - Missing Alphabets or "Two ways to solve a common MEWC/MECC bonus question"
excelwithExcel
Download
37
Excel BI Challenge 180 - Maximum Items Purchased (use of the SCAN function for running totals)
excelwithExcel
Download
38
Excel BI Challenge 178 - Route Cipher
excelwithExcel
Download
39
Easy Excel Challenge 4th August 24
excelwithExcel
Download
40
Excel BI Challenge 187 - Second Word Anagram
excelwithExcel
Download
41
Excel BI Challenge 514 - Sub Grid Maximum Sum (use of the OFFSET function)
excelwithExcel
Download
42
SCAN function (practical use) - Every Other Day Excel and Power Query Challenges No. 95 by Omid
excelwithExcel
Download
43
Excel BI Challenge 201 - Next Number Distinct Digit
excelwithExcel
Download
44
Excel BI Challenge 209 - Numbering of Characters
excelwithExcel
Download
45
Excel BI Challenge 211 - Ascending Descending
excelwithExcel
Download
46
Data Cleaning - Every Other Day Excel and Power Query Challenges No. 98 by Omid + REDUCE explanation
excelwithExcel
Download
47
Excel BI Challenge 523 - Alphabets Staircase (MAKEARRAY USE)
excelwithExcel
Download
48
Random Selection Part 2 - Every Other Day Excel and Power Query Challenges No. 99 by Omid
excelwithExcel
Download
49
Duplicate Values - Every Other Day Excel and Power Query Challenges No. 100 by Omid (REDUCE usage)
excelwithExcel
Download
50
Excel Esports (MEWC) - Road to Las Vegas Round 8 - Treasure Hunt by Peter Scharl (Case Solution)
excelwithExcel
Download
51
Character Repetition - Every Other Day Excel and Power Query Challenge No. 105 by Omid
excelwithExcel
Download
52
Excel BI Challenge 533 - ASCII Star (MAKEARRAY USE)
excelwithExcel
Download
53
Excel BI PQ Challenge 214 - solved in Excel
excelwithExcel
Download
54
Excel BI Challenge 532 - Grid where each is sum of already filled in surrounding cells
excelwithExcel
Download
55
Excel BI Challenge 244 - Super Palindromes (LAMBDA inside LET-Function)
excelwithExcel
Download
56
Custom Grouping - Every Other Day Excel and Power Query Challenge No. 109 by Omid (REDUCE + SCAN)
excelwithExcel
Download
57
INCREASED SALES - Every Other Day Excel and Power Query Challenge No. 111 by Omid
excelwithExcel
Download
58
Excel BI Challenge 543 - Top 2 Salaries
excelwithExcel
Download
59
Excel BI Challenge 249 - Mulitply Till... (wrapped SCAN function to omit the REDUCE function)
excelwithExcel
Download
60
Excel BI Challenge 260 - Alphabets Grid
excelwithExcel
Download
61
Gary Knott prime number grid challenge - Hard Excel challenge by @DimEarly
excelwithExcel
Download
62
Excel BI Challenge 555 - Order Cities
excelwithExcel
Download
63
Excel BI Challenge 561 - Maximum Profit - MAP:reference - technique
excelwithExcel
Download
64
Add Index Column - Every Other Day Excel and Power Query Challenge No. 127 by Omid
excelwithExcel
Download
65
Excel BI Challenge 568 - Fill in the Alphabets
excelwithExcel
Download
66
Excel BI Challenge 569 - Diff of Common Counts (LAMBDA inside LET use)
excelwithExcel
Download
67
Table Transformation - Every Other Day Excel and Power Query Challenge No. 137 by Omid
excelwithExcel
Download
68
Column Splitting - Every Other Day Excel and Power Query Challenge No. 136 by Omid
excelwithExcel
Download
69
Periodic Sales Summary - Every Other Day Excel and Power Query Challenge No. 138 by Omid
excelwithExcel
Download
70
Excel BI Challenge 576 - Sort only Consonants
excelwithExcel
Download
71
Excel BI Challenge 578 - Find Maximum Product
excelwithExcel
Download
72
Excel BI Challenge 581 - Increment Sequences
excelwithExcel
Download
73
Golden Period - Every Other Day Excel and Power Query Challenge No. 140 by Omid
excelwithExcel
Download
74
Excel BI PQ Challenge 233 - solved in Excel (the first time the PIVOTBY-function on this channel)
excelwithExcel
Download
75
Filtering - Every Other Day Excel and Power Query Challenge No. 174 by Omid
excelwithExcel
Download
76
Remove consecutive X - Every Other Day Excel and Power Query Challenge No. 175 by Omid
excelwithExcel
Download
77
Custom Grouping - Every Other Day Excel and Power Query Challenge No. 176 by Omid (three solutions)
excelwithExcel
Download
78
Replace consecutive X - Every Other Day Excel and Power Query Challenge No. 185 by Omid
excelwithExcel
Download
79
Two ways to solve Custom Grouping - Every Other Day Excel and Power Query Challenge No. 187 by Omid
excelwithExcel
Download
80
Excel BI Challenge 637 - Insert Dash At Non Consecutive Character
excelwithExcel
Download
81
Free Excel Esports Case from the Global Excel Summit - Excel Ninja (2025) by Andrew Grigolyunovich
excelwithExcel
Download
82
Excel BI Challenge 635 - Sorting Years Month Days
excelwithExcel
Download
83
Excel BI Challenge 667 - Pivot Problem
excelwithExcel
Download
84
Excel BI Challenge 671 - Word Pairs Having All Vowels
excelwithExcel
Download
85
Excel BI Challenge 673 - Star Pattern - MAKEARRAY use
excelwithExcel
Download
86
Unique code! - Every Other Day Excel and Power Query Challenge No. 212 by Omid
excelwithExcel
Download
87
Column Splitting - Every Other Day Excel and Power Query Challenge No. 218 by Omid
excelwithExcel
Download
88
Excel BI Challenge 713 - Split and Extract
excelwithExcel
Download
89
Excel BI Challenge 715 - Alphabetic Triangle - MAKEARRAY Use
excelwithExcel
Download
90
Excel BI Challenge 725 - Animal Count - PIVOTBY
excelwithExcel
Download