Excel custom sort and more

Learn all about sorting in Excel. Simple sort, multi-level, custom order, formatting and more … Two detailed videos. First one is about native Excel features. Second one is about automating using Power Query. And both use Word!

Excel Sort – Part 1

Sample data, Macro source code and Excel Add-in file (XLAM)

Contents

1. Intro – 00:00
2. How to keep the original order – 00:14
3. Simple sorting – 00:54
4. Sort left to right – 01:24
5. Custom sorting order – 01:38
6. Create the list in correct order – 01:57
7. Reordering the list – in Word – 02:42
8. Add Custom List to Excel – 03:28
9. Use Custom Sort on data – 04:18
10. Using custom sort across PCs – 04:34
11. Custom sort in Pivot Tables – 05:26
12. Sorting charts – 06:15
13. Sort on formatting – 06:35
14. CellFormat function (macro) – 07:45
15. Fun: Deal playing cards – 08:25
16. Summary – 09:41

Custom sort using Power Query

Contents

1. Introduction – 00:00
2. Recap – 00:09
3. Automating custom sort – 00:23
4. Import using CSV and Power Query – 00:43
5. Get data from CSV – 00:51
6. Create duplicate table – 01:07
7. Keep only product column – 01:12
8. Remove duplicates – 01:17
9. Reorder in Word – 01:24
10. Add index column – 01:44
11. Merge tables – 02:09
12. Sort on index column – 02:28
13. Mistake – import unwanted tables – 02:39
14. Import data – 02:54
15. Handling more data – 03:18
16. Remove index column – 04:39
17. Summary – 05:19

Related content

• Power Pivot Month Sorting using Time Table – Part 3
• Repairing Month Sorting Order in Power Pivot – Part 1
• Custom sorting in Pivot Table using Custom Lists
• Repairing Month Sorting Order in Power Pivot – Part 2
• Create short version of a long presentation with Custom Show