Power Query and Multiple Files 2023
Neale Blackwood
Power Query and Multiple Files 2023
1:06:01
Introduction to Excel Power Query 2023
Neale Blackwood
Introduction to Excel Power Query 2023
1:06:15
Excel Format As Table January 2023
Neale Blackwood
Excel Format As Table January 2023
1:01:41
24 - Create 1000 Random Dates
Neale Blackwood
24 - Create 1000 Random Dates
2:55
23 - Text Numbers to Real Numbers Again
Neale Blackwood
23 - Text Numbers to Real Numbers Again
3:03
22 - Normalise a Budget Layout
Neale Blackwood
22 - Normalise a Budget Layout
3:15
21 - Show Blank Cells for Zeroes
Neale Blackwood
21 - Show Blank Cells for Zeroes
2:40
20 - Create a Custom List
Neale Blackwood
20 - Create a Custom List
3:59
19 - Skip Blanks
Neale Blackwood
19 - Skip Blanks
1:35
18 - Convert Real Numbers to Text Numbers
Neale Blackwood
18 - Convert Real Numbers to Text Numbers
4:48
17 - A technique to fix text numbers in Excel
Neale Blackwood
17 - A technique to fix text numbers in Excel
3:43
16 - Create a useful macro
Neale Blackwood
16 - Create a useful macro
5:26
15 - Find and Replace with Colours in Excel
Neale Blackwood
15 - Find and Replace with Colours in Excel
2:37
14 - Flash Fill - Excel's super hero
Neale Blackwood
14 - Flash Fill - Excel's super hero
3:26
Excel Yourself 2022 review
Neale Blackwood
Excel Yourself 2022 review
58:15
13 - Create and use a check box in Excel
Neale Blackwood
13 - Create and use a check box in Excel
3:30
12 - Hide a value in cell in Excel
Neale Blackwood
12 - Hide a value in cell in Excel
2:11
11 - Add a % to a Pivot Table
Neale Blackwood
11 - Add a % to a Pivot Table
1:51
Excel Mouse Shortcuts 2022
Neale Blackwood
Excel Mouse Shortcuts 2022
59:52
Excel What If Techniques
Neale Blackwood
Excel What If Techniques
1:01:57
10 - Create PivotTable in Excel
Neale Blackwood
10 - Create PivotTable in Excel
3:42
09 - Drop down list in a cell
Neale Blackwood
09 - Drop down list in a cell
4:51
08 - Incremental dates in a long list in Excel
Neale Blackwood
08 - Incremental dates in a long list in Excel
1:46
07 - Enter a date down a long list in Excel
Neale Blackwood
07 - Enter a date down a long list in Excel
1:54
06 Subtotal a list in Excel
Neale Blackwood
06 Subtotal a list in Excel
3:11
05 - Extract Unique Entries in Excel
Neale Blackwood
05 - Extract Unique Entries in Excel
2:35
04 - Copy anything in Excel
Neale Blackwood
04 - Copy anything in Excel
1:55
03_Filling_In_The_Blanks
Neale Blackwood
03_Filling_In_The_Blanks
2:05
02_Identify_ Duplicates
Neale Blackwood
02_Identify_ Duplicates
2:27
01_Remove Duplicates
Neale Blackwood
01_Remove Duplicates
2:48
Dragging The Fill Handle
Neale Blackwood
Dragging The Fill Handle
4:11
Create range names quickly in Excel
Neale Blackwood
Create range names quickly in Excel
2:28
Handling Relative References in Excel
Neale Blackwood
Handling Relative References in Excel
3:10
Format As Table in Excel
Neale Blackwood
Format As Table in Excel
3:43
Unbreakable Sheet Hyperlink
Neale Blackwood
Unbreakable Sheet Hyperlink
2:59
Outlook 2010 Macro to print first page of email
Neale Blackwood
Outlook 2010 Macro to print first page of email
2:35
You too can be unique in Excel
Neale Blackwood
You too can be unique in Excel
1:25
Sum Top 5 values in an Excel range
Neale Blackwood
Sum Top 5 values in an Excel range
5:37
Excel Line Charts
Neale Blackwood
Excel Line Charts
3:07
In The Black Excel Yourself - RANK Function
Neale Blackwood
In The Black Excel Yourself - RANK Function
6:26
Convert Excel Column Chart to Bar chart
Neale Blackwood
Convert Excel Column Chart to Bar chart
2:51
RANK and RANK.AVG in Excel
Neale Blackwood
RANK and RANK.AVG in Excel
6:26
Customize Excel's Quick Access Toolbar
Neale Blackwood
Customize Excel's Quick Access Toolbar
4:36
Unhide groups of sheets with a macro
Neale Blackwood
Unhide groups of sheets with a macro
4:39
Input an entry in an Excel range
Neale Blackwood
Input an entry in an Excel range
1:55
Create a Custom List in Excel
Neale Blackwood
Create a Custom List in Excel
2:53
Data Cleanse
Neale Blackwood
Data Cleanse
3:25