DAX for Power BI Part 7.2 - Creating a Financial Year Calendar

Wise Owl Answers - How do I copy slides from multiple PowerPoint files into one presentation in VBA?

DAX for Power BI Part 7.1 - Creating Basic Calendar Tables in DAX

Wise Owl Answers How do I save a shape as a picture in Excel VBA

Wise Owl Answers - How do I hide columns using parameters in SSRS?

Power Automate Part 13a - Automating Forms

DAX for Power BI Part 6.4 - Opening and Closing Balance Calculations

Power Automate Part 12 - Approvals

Power Automate Part 11 - Error Handling

DAX for Power BI Part 6.3 - Calculating Running Total or To Date Values

Power Automate Part 10 - Apply to Each loops

DAX for Power BI Part 6.2 - Comparing Date Ranges

Power Automate Part 9 - Sorting and Filtering using OData

DAX for Power BI Part 6.1 - Introduction to Time Intelligence Functions

Power Automate Part 8 - Working with tables

Wise Owl Answers - How do I draw a line in a cell in Excel VBA?

Power Automate Part 7 - Conditions

Wise Owl Answers - How do I calculate aggregates for recursive groups in SSRS?

Power Automate Part 6 - Tidying Up Flows

Wise Owl Answers - How do I calculate percentage of columns in a matrix with multiple groups?

Power Automate Part 5 - Variables and Basic Arrays

Wise Owl Answers - How do I refer to the previous column in a matrix in SSRS?

Power Automate Part 4 - The Compose action and debugging

Wise Owl Answers - How do I compare specific columns in a matrix in SSRS?

Power Automate Part 3 - Creating triggered flows

Wise Owl Answers - How do I sort tables on multiple sheets in Excel VBA?

Power Automate Part 2 - Creating Basic Flows

DAX for Power BI Part 5.4 - Removing Filters with AllSelected and AllExcept

Power Automate Part 1 - Power Automate Desktop versus Server

Wise Owl Answers - How do I import tab delimited files with ActiveX Data Objects?

Wise Owl Answers - How do I refer to an open Word document in Excel VBA?

Python Part 21b - Classes case study

DAX for Power BI Part 5.3 - Replacing and Keeping Filters in Measures

Python Part 21a - Classes

DAX for Power BI Part 5.2 - Removing Filters in Measures

DAX for Power BI Part 5.1 - The Calculate, Filter and CalculateTable Functions

Wise Owl Answers - How do I use Google Translate with Excel VBA?

Python Part 20 - Power BI Desktop

DAX for Power BI Part 4.5 - Quick Measures

Python Part 19 - Pandas

Python Part 18 - NumPy

Python Part 17b - VBA using pywin32

Python Part 17a- Excel using openpyxl

DAX for Power BI Part 4.4 - Using Variables

Python Part 16c - Linking to JSON files

Python Part 16b - Linking to CSV files

DAX for Power BI Part 4.3 - Counting Values and Rows

Wise Owl Does Wordle

Python Part 16a - Linking to SQL Server

DAX for Power BI Part 4.2 - Sum, SumX and Other Aggregate Functions

Python Part 15 - Scraping websites

Python Part 14d - Working with strings

Python Part 14c - Working with dates and times

Python Part 14b - Working with Booleans

Python Part 14a - Working with numbers

Python Part 13 - Error-trapping

DAX for Power BI Part 4.1 - Getting Started with Measures

Python Part 12b - Advanced Functions

Python Part 12a - Functions

DAX for Power BI Part 3.2 - The LookupValue Function