102 subscribers
116 videos
61 - Creating variables in Power Query, using inner queries
29 - Replace the values in a column on a condition (Power Query)
21 - Grab URL and title from all browser tabs (Power Automate Desktop)
61 - Using a calculated table as a list of eg definitions
51 - Dealing with tables with varying column names and number of columns
47Python.2 - HoloCure Collabs tool, using python and pandas
63 - Fixing the Formula.Firewall-error (Power Query)
07 - Filter a table using a variable (VBA)
59 - Inner query (Power Query)
27.1 - Split a table into tables with 50 rows (Power Query)
69 - Function scope in Power Query
Factorio, a train stop with dynamic train limits
64 - Use VBA to update queries, and measure the time it took
84 - Storing and accessing metadata, eg count rows of steps (Power Query)
79 - Handling a weird data structure (blanks and transpose) (Power Query)
64.1 - Time to update a query, pure M
Oops, all ants
97 - List Generate
66 - Playing with lists in Power Query
Factorio, having a train deposit to multiple stations
78 - Fixing spelling mistakes, Text Replace vs If (Power Query)
79 - Function to turn weeks into years and months (Excel, Excel 365 and VBA)
80 - Recursion in VBA (find the next valid day)
81- Aggregate, to e.g. find the next birthday (Excel)
79.1 - Python, Weeks to years and months
71 - Indirect
68 - Creating a cumulative sum column in Power Query
73 - Making an Excel sheet Very Hidden
72 - Dynamically updating a title + changing y axis (Power BI)
65 - \d{3} regex in Power Query
37 - Removing duplicates ignores your sort order (Power Query)
24 - Group by and Text Combine in Power Query
47SQL.1 - HoloCure Collabs tool, using Postgres and SQL
10 - Count duplicates (Power Query/Pivot table/VBA)
86 - Split columns, varying number of columns (Power Query)
75 - Recursion in Power Query
76 - As and Is (Power Query)
49 - Playing with Summarize and max sales (DAX)
83 - Days between, remove weekends (Power Query)
48 - Playing with Summarize and Groupby (Power Pivot)
58 - Using CalculateTable to simulate slicers (DAX)
47SQL.2 - HoloCure Collabs tool, using Postgres and SQL
67 - Cumulative sum, List Generate and function scope
53 - Print a table, then load it
12 - Using RegEx in Excel (VBA)
01 Using Power Automate to log on to your Runescape account
26 - Combining steps into one step in Power Query
18 - Archive table(s) with Power Query (Excel)
