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

Change loading destination from table to connection only

Importing data in a folder and sheets in the current or external Excel file with Power Query – L0021

How to copy an Excel sheet to a new workbook

How to use FILTER function with two criteria and return only selected columns

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

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

Make Power Query load all queries as Connection Only by default

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

How to automate Advanced Filter with VBA to search data automatically

Naming Excel Table Ranges and Navigating through Tables

How to Copy a Power Query query from one Excel workbook to another one

What are CSV files?

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