Celia Alves - Solve & Excel
8.67K subscribers
30:34
Refreshing twice in Power Query in Excel? Why? Fix it now.
Celia Alves - Solve & Excel
6.1K views • 10 months ago
36:41
Comparing Two Lists in Excel with Functions - all Power Query Merge Joins - T0033
Celia Alves - Solve & Excel
3.2K views • 1 year ago
1:31
The best way to create Dependent Dropdown Lists in Excel
Celia Alves - Solve & Excel
748 views • 1 year ago
29:44
Dynamic Dependent Dropdown Lists in Excel: create and manage all the categories you need - T0032
Celia Alves - Solve & Excel
25K views • 1 year ago
15:56
Combining text from cells in the same column in Power Query without combining the whole rows T0031
Celia Alves - Solve & Excel
6.5K views • 2 years ago
31:13
How to combine in a folder multiple files with different column headers - T0030
Celia Alves - Solve & Excel
34K views • 2 years ago
31:13
How to rename columns in Power Query that change the name on each data updating - T0029
Celia Alves - Solve & Excel
22K views • 2 years ago
10:24
How to combine pivoted data from multiple sheets in an Excel file
Celia Alves - Solve & Excel
1.4K views • 2 years ago
11:51
Ways of recycling work in Power Query and saving time T0028
Celia Alves - Solve & Excel
8.7K views • 2 years ago
17:02
Easy way to import messy CSV files into Excel The importance of defining data types in Power Query
Celia Alves - Solve & Excel
7.9K views • 2 years ago
5:24
How to unstack data in repeated groups of rows in the same column with Power Query in Excel
Celia Alves - Solve & Excel
7.7K views • 2 years ago
3:00
Find out where you can use Power Query and the data sources it can connect to
Celia Alves - Solve & Excel
652 views • 3 years ago
5:49
How to make Power Query deal with a variable number of columns in a text source file
Celia Alves - Solve & Excel
4.5K views • 3 years ago
6:54
When does it make sense to use Power Query in Excel?
Celia Alves - Solve & Excel
1.6K views • 3 years ago
8:31
How to import data from sheets in the same Excel workbook as the Power Query query
Celia Alves - Solve & Excel
25K views • 3 years ago
4:02
Why you must learn Power Query if your work involves importing data into Excel
Celia Alves - Solve & Excel
476 views • 3 years ago
1:22
Simplify M language code by eliminating hashtag sign and double quote characters from step names
Celia Alves - Solve & Excel
906 views • 3 years ago
7:32
How to prevent data entry errors in Excel with a dynamic Data Validation Dropdown List - T0025
Celia Alves - Solve & Excel
997 views • 3 years ago
11:10
How to connect to an Excel sheet with Power Query without importing extra columns or rows – T0024
Celia Alves - Solve & Excel
4.8K views • 3 years ago
18:50
How to sort data in an Excel Table following any sorting criteria – T0023
Celia Alves - Solve & Excel
2.4K views • 3 years ago
1:56
Things to keep in mind when connecting to an Excel sheet with Power Query
Celia Alves - Solve & Excel
620 views • 3 years ago
32:21
Two automations to share Power Query results without allowing to refresh the query – T0022
Celia Alves - Solve & Excel
4.9K views • 3 years ago
15:38
How to make Table.Combine include extra column from the previous query step
Celia Alves - Solve & Excel
3.7K views • 3 years ago
4:04
How to combine Tables using the M Language Function Table.Combine in Power Query
Celia Alves - Solve & Excel
6.6K views • 3 years ago
2:05
Why it is important to save the data source file before importing data with Power Query
Celia Alves - Solve & Excel
433 views • 3 years ago
4:03
Define the portion that you want to print in Excel using Page breaks and print selection
Celia Alves - Solve & Excel
231 views • 3 years ago
3:13
Importing data from external sources with Power Query directly into a Pivot Table in Excel
Celia Alves - Solve & Excel
3.4K views • 3 years ago
28:40
M Language Tips to achieve more with Power Query – T0020
Celia Alves - Solve & Excel
11K views • 3 years ago
36:18
How to add a File Picker in Excel to select the data source file for Power Query – T0019
Celia Alves - Solve & Excel
5.4K views • 3 years ago
25:35
How to combine pairs of rows in Power Query with different criteria per column - T0018
Celia Alves - Solve & Excel
5.5K views • 3 years ago
Load More