102 подписчиков
116 видео
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)
10 - Count duplicates (Power Query/Pivot table/VBA)
75 - Recursion in Power Query
90 - Highlight the active cell (VBA)
86 - Split columns, varying number of columns (Power Query)
83 - Days between, remove weekends (Power Query)
53 - Print a table, then load it
32 - Wednesday checker + making your python file run on startup (Python)
28 - Coalesce is a simpler way to find the first non-null column (Power Query)
13 - Dealing with variable column names in Power Query (Excel)
Uruka loves christmas
58 - Using CalculateTable to simulate slicers (DAX)
76 - As and Is (Power Query)
23 - Dealing with changing column headers in Power Query
102 - Using PAD and PowerShell to execute VBA
27.2 - Split a table into tables with 50 rows, via VBA
47SQL.2 - HoloCure Collabs tool, using Postgres and SQL
116.1 - regex via pandas, Extract first match
43 - Replace values in a column based on conditions
18 - Archive table(s) with Power Query (Excel)
