Celia Alves - Solve & Excel

[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

PROPER FUNCTION (Celia Alves - Microsoft MVP & Certified Excel Expert)

How to ask Power Query to auto detect data types

Conditional Format to hightlight the weekend days in Excel

The best way to create Dependent Dropdown Lists in Excel

How to Refer to a Table Column in Excel

How to filter your data to show only the rows for the last 3 months Power Query in Excel

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

How to combine Tables using the M Language Function Table.Combine in Power Query

How to import data from sheets in the same Excel workbook as the Power Query query

How to make Power Query refresh on an Excel protected sheet

Fast and easy way to copy a query to another workbook

How to unpivot data with repeated column groups into tabular layout with Power Query in Excel

Power Query is a tool in Excel to automate data preparation procedures. snapreportschamp.com/course

How to import and clean data from a web page with Power Query into Excel | Excel Automation | L0023

How to Fix broken Conditional Formatting Rules with VBA

How to merge the content of several columns in Power Query in Excel

Excel Template file type - When you should use it

M Language Tips to achieve more with Power Query – T0020

How to transform data with multi-row headers into tabular format with Power Query

Power Query unpivoting techniques to shape data into a Tabular layout | Excel Automation - L0015

How to extract the Month and Year information from a date in Excel

Combining text from cells in the same column in Power Query without combining the whole rows T0031

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

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