|
1
|
|
|
|
Free Excel Basics Course at YouTube
|
|
|
3 listeners
|
|
2
|
|
|
|
Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468)
|
|
|
3 listeners
|
|
3
|
|
|
|
Excel IF Function. Everything You Need to Know. Excel Magic Trick 1634
|
|
|
2 listeners
|
|
4
|
|
|
|
.XMATCH with function argument array operation to compare two lists.
|
|
|
2 listeners
|
|
5
|
|
|
|
Excel Magic Trick 1473: Sequential Number Incrementor for Just The Middle Number: AA-0009-17
|
|
|
1 listener
|
|
6
|
|
|
|
Excel Formula to Lookup Cell Address Of Max Value: 12 Amazing Examples. Excel Magic Trick 1794
|
|
|
1 listener
|
|
7
|
|
|
|
INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3)
|
|
|
1 listener
|
|
8
|
|
|
|
Excel Magic Trick 448: OFFSET Function To Avoid #REF! Error
|
|
|
1 listener
|
|
9
|
|
|
|
3 Power Query Formulas: Hours Worked for Day & Night Shift from Time Values. Excel Magic Trick 1827
|
|
|
1 listener
|
|
10
|
|
|
|
Excel Magic Trick 302: Randomly Select Names No Repeats
|
|
|
1 listener
|
|
11
|
|
|
|
DAME 01: Data Analysis Terms & the Awesome Microsoft Power Tools
|
|
|
1 listener
|
|
12
|
|
|
|
Excel Formula for Lookup Adding with SUMIFS & SUM- Excel Magic Trick 1604
|
|
|
1 listener
|
|
13
|
|
|
|
Power Query M Code Custom Function to Convert 12 Cross Tabulated Data Sheets to PivotTable. EMT 1621
|
|
|
1 listener
|
|
14
|
|
|
|
Excel FIXED Function Easier than TEXT Function! (DOLLAR Function too). Excel Magic Trick 1635
|
|
|
1 listener
|
|
15
|
|
|
|
TEXTJOIN & MID? LEFT, 2 MID, RIGHT? Excel Formulas to Insert Dashes into Text Excel Magic Trick 1637
|
|
|
1 listener
|
|
16
|
|
|
|
REPLACE Function to Insert a Dash Into Text. Flash Fill Too. Excel Magic Trick 1639
|
|
|
1 listener
|
|
17
|
|
|
|
CHOOSE Function Beginner to Advanced 12 Examples (Excel VLOOKUP WEEK Video #5)
|
|
|
1 listener
|
|
18
|
|
|
|
Sparkling Christmas Tree in Excel! Build Conditional Format Christmas Tree: Excel Magic Trick 1361
|
|
|
1 listener
|
|
19
|
|
|
|
Excel Magic Trick 865: Data From Many Columns Into One: Recorded Macro & Paste All Clipboard
|
|
|
1 listener
|
|
20
|
|
|
|
Summarize Survey Results with PivotTable in One Minute - Excel Magic Trick 1577
|
|
|
1 listener
|
|
21
|
|
|
|
Excel Magic Trick 782: Find All Numbers With 4, 2, 3 ISNUMBER & SEARCH functions
|
|
|
1 listener
|
|
22
|
|
|
|
Excel Magic Trick 1267: PivotTable Automatic Date Grouping: New in Excel 2016
|
|
|
1 listener
|
|
23
|
|
|
|
Create Excel Database and Data Entry Form. Excel Magic Trick 1690.
|
|
|
1 listener
|
|
24
|
|
|
|
Excel Magic Trick #197: Grade Book with Weights
|
|
|
1 listener
|
|
25
|
|
|
|
Excel Magic Trick 1176: CONVERT Function to convert units in Excel (Excel CONVERT Joke at 05:27)
|
|
|
1 listener
|
|
26
|
|
|
|
Free Excel Data Analysis Basics Course at YouTube (E-DAB)
|
|
|
1 listener
|
|
27
|
|
|
|
Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704.
|
|
|
1 listener
|
|
28
|
|
|
|
.Introduction.
|
|
|
1 listener
|
|
29
|
|
|
|
Excel Table NOT Automatically Add New Column or Rows? Option Setting to Fix This. Magic Trick 1547
|
|
|
1 listener
|
|
30
|
|
|
|
.Introduction
|
|
|
1 listener
|
|
31
|
|
|
|
.Pattern 1,1,1,2,2,2,3,3,3…
|
|
|
1 listener
|
|
32
|
|
|
|
Excel FILTER Function with Partial Text Criteria or Contains Criteria. Extracting Records. EMT 1653
|
|
|
1 listener
|
|
33
|
|
|
|
.CELL Function
|
|
|
1 listener
|
|
34
|
|
|
|
.RELPACE and SEARCH functions.
|
|
|
1 listener
|
|
35
|
|
|
|
.XLOOKUP or VLOOKUP
|
|
|
1 listener
|
|
36
|
|
|
|
.Copy Lookup Formula
|
|
|
1 listener
|
|
37
|
|
|
|
.Key Column
|
|
|
1 listener
|
|
38
|
|
|
|
.FILTER and TEXTJOIN functions to get descriptions
|
|
|
1 listener
|
|
39
|
|
|
|
.Formula that uses LEFT, an array constant {“a”,”b”,”c”} and the SUM function
|
|
|
1 listener
|
|
40
|
|
|
|
.Why the two arrays must be in opposite directions
|
|
|
1 listener
|
|
41
|
|
|
|
PivotTables Are Easy! 30 Examples for Highline College Professional Development Day 2014
|
|
|
1 listener
|
|
42
|
|
|
|
Sorted Frequency Distribution with the LET Function. Excel Magic Trick 1675.
|
|
|
1 listener
|
|
43
|
|
|
|
Table of Data
|
|
|
1 listener
|
|
44
|
|
|
|
Free Advanced Excel Course at YouTube
|
|
|
1 listener
|
|
45
|
|
|
|
March 25, 2025 YouTube Subtotal Update
|
|
|
1 listener
|
|
46
|
|
|
|
.LET i LAMBDA razem, aby uprościć złożone raportowanie dla użytkownika końcowego.
|
|
|
1 listener
|