98 тысяч подписчиков
137 видео
[L0001] Excel Report Automation w/ Power Query and VBA - PART 1: ETL - Snap Reports
[L0002] Excel Report Automation w/ Power Query and VBA - PART 2: VBA - Snap Reports
[L0003] How to compare two data sets in Excel – Join Kind Types in Power Query | Excel Snap Reports
Excel Table – One of the most important concepts in Excel [L0004]
I cannot automate My Excel Reporting Process - the process is too Complex | Snap Reports [L0005]
How to Automate an Excel Invoice Template | Snap Reports [L0006]
How to Refresh Power Query in Excel Protected Sheets | Excel Report Automation [L0007]
When the columns to import are not always the same – Easy solution with Power Query - L0008
Import the first and last 3 columns w/ PQ from a data set that gets new columns all the time - L0009
Data Layout vs Report Layout - The best way to organize data: Part 1| Excel Report Automation -L0010
Data Layout vs Report Layout - Pivot Table - Part 2 | Excel Report Automation - L0011
FILTER Data Automatically in Excel, with and without Dynamic Arrays | Excel Automation - L0012
Importing data from external sources with Power Query directly into a Pivot Table in Excel
How to make the Currency Format stick in the Excel sheet after refreshing a Power Query table
How to make Power Query deal with a variable number of columns in a text source file
How to combine text with date values to create a dynamic Title in Excel
How to rename columns in Power Query that change the name on each data updating - T0029
How to Enable the Formula Bar in Power Query Editor in Excel
Import data from a Google Sheets file into Excel with Power Query without making the file public
How to combine pivoted data from multiple sheets in an Excel file
How to combine in a folder multiple files with different column headers - T0030
What is Option Explicit for in VBA and how to enable it?
How to make dynamic the path to the data source files in Power Query in Excel | L0027
How to make a Pivot Table always display all the field values even when they contain no data
Create awesome custom Headers and Footers on your Excel reports with Page Layout View
How to automate Printing in Excel with VBA
How to change the Loading Destination of a Power Query query in Excel
Understand the Enable Background Refresh property in Power Query in Excel
How to unstack data in repeated groups of rows in the same column with Power Query in Excel
The easiest Excel Formula to get a sorted list of unique values . | Celia Alves - Microsft MVP
How to customize the Design of a Pivot Table to match your preferences
How to change the display language in Excel
How to add columns to the left of an Excel Table
How to get data from the most recent file in a Folder with Power Query in Excel
How to Refer to a Table Column in Excel
How to ask Power Query to auto detect data types
How to automate Advanced Filter with VBA to search data automatically
How to sort a table by multiple criteria with Power Query
How to transform data with multi-row headers into tabular format with Power Query
Separating text in one cell into multiple columns - Power Query vs Excel Features | L0025
How to unpivot data with repeated column groups into tabular layout with Power Query in Excel
Excel Template file type - When you should use it
How to make Power Query refresh on an Excel protected sheet
How to combine Tables using the M Language Function Table.Combine in Power Query
How to extract the Month and Year information from a date in Excel
How to combine pairs of rows in Power Query with different criteria per column - T0018
Fast and easy way to copy a query to another workbook
How to import data from sheets in the same Excel workbook as the Power Query query
Advanced Filter with VBA
How to filter your data to show only the rows for the last 3 months Power Query in Excel
Change loading destination from table to connection only
How to add a File Picker in Excel to select the data source file for Power Query – T0019
How to create a button to run a macro in Excel using a shape and an icon
Using Table Structured References in Excel functions
How to add slicers to an Excel table and how to use them
How to Sum columns by criteria on the column header in Power Query | L0024
Importing data in a folder and sheets in the current or external Excel file with Power Query – L0021
How to make Table.Combine include extra column from the previous query step
Two automations to share Power Query results without allowing to refresh the query – T0022
