solveandexcel

How to change the display language in Excel

What is an Excel Table and what are the advantages of using Excel Tables

Simplify M language code by eliminating hashtag sign and double quote characters from step names

How to sort a table by multiple criteria with Power Query

Separating text in one cell into multiple columns - Power Query vs Excel Features | L0025

How to prevent data entry errors in Excel with a dynamic Data Validation Dropdown List - T0025

Create awesome custom Headers and Footers on your Excel reports with Page Layout View

M Language Tips to achieve more with Power Query – T0020

How to combine pairs of rows in Power Query with different criteria per column - T0018

When the columns to import are not always the same – Easy solution with Power Query - L0008

How to automate Printing in Excel with VBA

Importing data from external sources with Power Query directly into a Pivot Table in Excel

Dynamic Dependent Dropdown Lists in Excel: create and manage all the categories you need - T0032

How to Enable the Formula Bar in Power Query Editor in Excel

Data Layout vs Report Layout - Pivot Table - Part 2 | Excel Report Automation - L0011

Excel Table – One of the most important concepts in Excel [L0004]

How to disable automatic detection of Data Types in Power query in Excel

How to Refresh Power Query in Excel Protected Sheets | Excel Report Automation [L0007]

Using Table Structured References in Excel functions

'Exponential Functions Made Easy: Learn, Solve, and Excel!'

[L0002] Excel Report Automation w/ Power Query and VBA - PART 2: VBA - Snap Reports

How to get the data from the 1st of the current month onwards with Power Query T0015

What is Option Explicit for in VBA and how to enable it?

Data Layout vs Report Layout - The best way to organize data: Part 1| Excel Report Automation -L0010