Data can arrive at us in many different layouts, but we know that the most convenient one is the tabular layout because that's the one that makes our lives easier in Excel when we need to do data analysis. Learn how to recognize that your data is pivoted and how to unpivot it using Power Query.
----------------------
Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
LIVE CLASSES on YouTube every week: https:www//youtube.com/celiaalvessolveexcel
Get access to the Live Classes EXERCISE FILES by joining our Telegram Group at [ Ссылка ]
Subscribe to my NEWSLETTER for exciting news about the Excel world: [ Ссылка ]
Solve & Excel Consulting - [ Ссылка ]
LinkedIn: [ Ссылка ]
Facebook: [ Ссылка ]
Twitter: @celia_excel
Instagram: @solveandexcel
#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA
-------------------------
#Excel #shorts #solveandexcel #microsoft365 #toronto #torontobusiness #wit #msexcel #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #canada
Ещё видео!