fbpx
Site logo white shadow

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

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,758 other subscribers

Popular articles

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.