Creatives (Advanced)
46 videos • 552 views • by ExcelMoments
1
Calculate the Number of "Mondays", "Tuesdays....." that are not Public Holidays
ExcelMoments
Download
2
TEXTJOIN and FILTER functions to concatenate cells that meet certain criteria
ExcelMoments
Download
3
Can Excel solve this? Solve a set of Linear Equations (MATRICES)
ExcelMoments
Download
4
SUM the Last "N" Non-Blank Numeric cells using the OFFSET function -Microsoft Excel
ExcelMoments
Download
5
SEQUENCE function to split one column into Rows & Columns (MICROSOFT EXCEL)
ExcelMoments
Download
6
Microsoft Excel: Split One Column of Data into Rows and Columns
ExcelMoments
Download
7
Microsoft Excel: Split One Column of Data into Rows and Columns
ExcelMoments
Download
8
Palindromes in Excel (TextJoin, Sequence, Mid Functions +Flash Fill - String Reversal)
ExcelMoments
Download
9
Palindromes in Excel (TextJoin, Sequence, Mid Functions +Flash Fill - String Reversal)
ExcelMoments
Download
10
Data Validation using UNIQUE and FILTER functions - The Spill Operator (#)
ExcelMoments
Download
11
Text Functions with multiple custom formats in Microsoft Excel- Part 2
ExcelMoments
Download
12
Who wants to be a Millionaire in Microsoft Excel using VBA
ExcelMoments
Download
13
List all Sheets in an Excel Workbook (NO VBA) - Get.Workbook(1)
ExcelMoments
Download
14
Theme Colors in Microsoft Excel (My headaches are gone!)
ExcelMoments
Download
15
Create HYPERLINKS to all subfolders in a folder (CMD to extract list, no PQuery ) - Microsoft Excel
ExcelMoments
Download
16
Filter function to group numbers into intervals
ExcelMoments
Download
17
How many months in the year end on a "Friday"? (Microsoft Excel)
ExcelMoments
Download
18
How many Fridays are there in a year? Microsoft Excel
ExcelMoments
Download
19
Formula expression for Palindromes in Excel
ExcelMoments
Download
20
FILES Function in Excel to List Files in a Folder
ExcelMoments
Download
21
Sum all sales on last day of the month - EOMONTH does not work
ExcelMoments
Download
22
Excel: 5 Ways to convert dates with a period separator to a proper date
ExcelMoments
Download
23
Customizing Quick Access toolbar (QAT) in Excel With XML Edits
ExcelMoments
Download
24
Fill Working days in a month dynamically - Microsoft Excel
ExcelMoments
Download
25
Second to last non-blank cell excel
ExcelMoments
Download
26
Conditional Formatting Challenge: Solution walkthrough
ExcelMoments
Download
27
Excel Oddity: Booleans in a formula context
ExcelMoments
Download
28
Conditionally format data labels - Excel Charts
ExcelMoments
Download
29
Dynamic row-by-row sum in Excel- different approaches
ExcelMoments
Download
30
VLOOKUP "Trick" in excel -Proving an "unnecessary" point
ExcelMoments
Download
31
Sum filtered rows - Excel dynamic array formulas
ExcelMoments
Download
32
Most Occurring item(s) in a List - Excel MODE.MULT
ExcelMoments
Download
33
Sneak Peek - view all worksheets in one worksheet
ExcelMoments
Download
34
Insert blank row at every value change dynamically
ExcelMoments
Download
35
Web scrape Flight Information (Power Automate Desktop+Excel)
ExcelMoments
Download
36
Dynamic Organizational Chart - Excel Image function
ExcelMoments
Download
37
Star ratings chart -Excel
ExcelMoments
Download
38
Formula: First non blank after last blank cell in Range
ExcelMoments
Download
39
Extract all comments in a workbook Excel VBA
ExcelMoments
Download
40
Excel Challenge: List numbers that are sum of squares of other numbers
ExcelMoments
Download
41
Hyperlink in excel to all subfolders in a folder+PowerQuery+VBA
ExcelMoments
Download
42
Sequence in descending order - Excel Formulas
ExcelMoments
Download
43
HOW to sort odd and even numbers in excel
ExcelMoments
Download
44
REGEX to reformat phone number - Excel
ExcelMoments
Download
45
Find and Replace dialog with REGEX in Google sheets
ExcelMoments
Download
46
Case (In)sensitive Sort in Excel -sort UPPER, then LOWERcase
ExcelMoments
Download