Excel Challenges
36 videos • 1,760 views • by ExcelMoments
1
find names starting with certain character -Excel
ExcelMoments
Download
2
Excel Challenge Solution: Are digits in increasing order?
ExcelMoments
Download
3
Excel formula challenge: Words with all vowels (MMULT)
ExcelMoments
Download
4
Excel formula challenge: Valid IP excel formula
ExcelMoments
Download
5
Excel Formula Challenge - Reduce function to Align Cities
ExcelMoments
Download
6
Excel Formula Challenge: List repeated Alphabets from text string
ExcelMoments
Download
7
Excel Formula Challenge: Minimum absolute difference between columns
ExcelMoments
Download
8
Excel Formula Challenge - REDUCE function for Pascal Case to Snake Case
ExcelMoments
Download
9
Excel formula challenge: Reverse words in a string
ExcelMoments
Download
10
Excel formula Challenge - Most country pairs in FIFA WorldCup Finals
ExcelMoments
Download
11
Frequency function for odd occurrences -Excel challenge
ExcelMoments
Download
12
Excel formula challenge - Top 2 Runners up (No wins)
ExcelMoments
Download
13
Excel Challenge: Formulas to extract and match acronyms
ExcelMoments
Download
14
Excel Formula Challenge: Most frequently starting alphabet
ExcelMoments
Download
15
Excel Formula Challenge: missing alphabets
ExcelMoments
Download
16
Excel formula challenges - Isograms
ExcelMoments
Download
17
Excel formula challenges - Isograms with MMULT
ExcelMoments
Download
18
Excel formula Challenge -Greatest common divisor (CoPrimes)
ExcelMoments
Download
19
Excel formula Challenge: Count Consecutive 1s in a string
ExcelMoments
Download
20
Excel Challenge -Is the string sorted??
ExcelMoments
Download
21
Python solution to Excel Challenge -Is the string sorted?
ExcelMoments
Download
22
Excel Challenge Solution - Pronic numbers
ExcelMoments
Download
23
Python Solution - Pronic numbers Excel Challenge
ExcelMoments
Download
24
Excel Challenge - Create sequential numbers with a twist (SCAN)
ExcelMoments
Download
25
Excel Formula Challenge: "Amicable numbers"
ExcelMoments
Download
26
Excel Challenge: Python GroupBy and Aggregate
ExcelMoments
Download
27
Excel Challenge: GroupBy and Subtotal
ExcelMoments
Download
28
Sort "Messy" Excel Data - Bob Umlas Excel challenge
ExcelMoments
Download
29
Excel Challenge: FREQUENCY OF ALPHABETS IN A STRING
ExcelMoments
Download
30
Excel Challenge: Expand grouped Intervals -Reduce Function
ExcelMoments
Download
31
Excel Challenge: List numbers that are sum of squares of other numbers
ExcelMoments
Download
32
Excel Challenge - Top N filter in excel using GROUPBY
ExcelMoments
Download
33
Excel Challenge - Summarize results in a grid+MAKEARRAY
ExcelMoments
Download
34
Excel Challenge: Extract uncommon words from 2 strings
ExcelMoments
Download
35
Pivot data challenge- Excel
ExcelMoments
Download
36
List all last sundays of the months - ExcelChallenge
ExcelMoments
Download