{"id":365141,"date":"2026-08-19T12:58:26","date_gmt":"2026-08-19T09:58:26","guid":{"rendered":"https:\/\/menhj.com\/videos\/?post_type=watch&#038;p=365141"},"modified":"2026-08-19T12:58:26","modified_gmt":"2026-08-19T09:58:26","slug":"integrating-several-different-working-papers-into-a-simultaneous-dynamic-table-using-power-query-in-the-excel-programme","status":"publish","type":"watch","link":"https:\/\/menhj.com\/videos\/watch\/integrating-several-different-working-papers-into-a-simultaneous-dynamic-table-using-power-query-in-the-excel-programme\/","title":{"rendered":"\u062f\u0645\u062c \u0639\u062f\u0629 \u0623\u0648\u0631\u0627\u0642 \u0639\u0645\u0644 \u0645\u062e\u062a\u0644\u0641\u0629 \u0641\u064a \u062c\u062f\u0648\u0644 \u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a \u0645\u062a\u0632\u0627\u0645\u0646 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0623\u062f\u0627\u0629 Power Query \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0627\u0644\u0625\u0643\u0633\u064a\u0644"},"content":{"rendered":"<p>1. \u062f\u0645\u062c \u0639\u062f\u0629 \u0623\u0648\u0631\u0627\u0642 \u0639\u0645\u0644 \u0645\u062e\u062a\u0644\u0641\u0629 \u0641\u064a \u062c\u062f\u0648\u0644 \u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a \u0645\u062a\u0632\u0627\u0645\u0646 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0623\u062f\u0627\u0629 Power Query \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0627\u0644\u0625\u0643\u0633\u064a\u0644 \u2014 \u0627\u0644\u0645\u062c\u0644\u0629 \u0627\u0644\u062b\u0642\u0627\u0641\u064a\u0629<br \/>\n2. \u062f\u0645\u062c \u0639\u062f\u0629 \u062c\u062f\u0627\u0648\u0644 \u0641\u064a \u0623\u0648\u0631\u0627\u0642 \u0639\u0645\u0644 \u0645\u062e\u062a\u0644\u0641\u0629 \u0641\u064a \u062c\u062f\u0648\u0644 \u062a\u0632\u0627\u0645\u0646\u064a \u0648\u0627\u062d\u062f \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0627\u0644\u0625\u0643\u0633\u064a\u0644 Power Query \u2014 \u0627\u0644\u0645\u062c\u0644\u0629 \u0627\u0644\u062b\u0642\u0627\u0641\u064a\u0629<br \/>\n3. 3 \u062f\u0648\u0631\u0629 Power Query \u0627\u0644\u062e\u0627\u0635\u064a\u0629 Append \u062a\u062c\u0645\u064a\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0639\u062f\u0629 \u0623\u0648\u0631\u0627\u0642 \u0639\u0645\u0644 \u0648\u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u0627\u0644\u0645\u062a\u0646\u0648\u0639\u0629 \u0645\u0646\u0647\u0627 \u2014 Samir Tobeil<br \/>\n4. \u062a\u062c\u0645\u064a\u0639 \u0627\u0644\u0645\u0644\u0641\u0627\u062a \u0641\u064a \u0627\u0644\u0625\u0643\u0633\u0644 \u0628\u0637\u0631\u064a\u0642\u0629 \u0627\u0644\u0628\u0648\u0631 \u0643\u0648\u064a\u0631\u064a Combine Data using Power Query \u2014 ALMUNTHIR SAFFAN (\u202b\u0627\u0644\u0645\u0646\u0630\u0631 \u0633\u0641\u0627\u0646\u202c\u200e)<br \/>\n5. A Secret Method to Automatically Merge Multiple Excel Sheets or Tables into One Combine Excel F \u2014 \u0627\u0644\u0645\u062c\u0644\u0629 \u0627\u0644\u062b\u0642\u0627\u0641\u064a\u0629<br \/>\n6. \u062f\u0645\u062c \u0639\u062f\u0629 \u062c\u062f\u0627\u0648\u0644 \u0641\u064a \u0623\u0648\u0631\u0627\u0642 \u0639\u0645\u0644 \u0645\u062e\u062a\u0644\u0641\u0629 \u0641\u064a \u062c\u062f\u0648\u0644 \u062a\u0632\u0627\u0645\u0646\u064a \u0648\u0627\u062d\u062f Power Query \u2014 \u0645\u0633\u062a\u0631 \u062f\u063a\u064a\u062f\u0649<br \/>\n7. \u062f\u0645\u062c \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0623\u0648\u0631\u0627\u0642 Excel \u0645\u062a\u0639\u062f\u062f\u0629 \u0641\u064a \u062c\u062f\u0648\u0644 \u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a \u2014 Learn Excel Online<br \/>\n8. \u0623\u0633\u0631\u0627\u0631 \u0627\u0644\u0625\u0643\u0633\u064a\u0644 \u062f\u0645\u062c \u0648\u062a\u062c\u0645\u064a\u0639 \u0639\u062f\u0629 \u0635\u0641\u0648\u0641 \u0641\u064a \u0635\u0641 \u0648\u0627\u062d\u062f \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0627\u0644\u0625\u0643\u0633\u064a\u0644 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0623\u062f\u0627\u0629 Power Query \u2014 \u0627\u0644\u0645\u062c\u0644\u0629 \u0627\u0644\u062b\u0642\u0627\u0641\u064a\u0629<br \/>\n9. \u062f\u0645\u062c \u0639\u062f\u0629 \u0648\u0631\u0642\u0627\u062a \u0623\u0648 \u062c\u062f\u0627\u0648\u0644 \u0645\u0646 \u0645\u0644\u0641 \u0648\u0627\u062d\u062f Merge Multible Sheets Tables \u2014 ALMUNTHIR SAFFAN (\u202b\u0627\u0644\u0645\u0646\u0630\u0631 \u0633\u0641\u0627\u0646\u202c\u200e)<br \/>\n10. \u0627\u0643\u062a\u0634\u0627\u0641 \u0627\u0644\u062a\u0643\u0631\u0627\u0631\u0627\u062a \u0628\u064a\u0646 \u062c\u062f\u0648\u0644\u064a\u0646 \u0648\u0639\u0631\u0636\u0647\u0627 \u0641\u064a \u062c\u062f\u0648\u0644 \u0645\u062a\u0632\u0627\u0645\u0646 \u0628\u0637\u0631\u064a\u0642\u0629 \u0627\u062d\u062a\u0631\u0627\u0641\u064a\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0623\u062f\u0627\u0629 Power Query \u2014 \u0627\u0644\u0645\u062c\u0644\u0629 \u0627\u0644\u062b\u0642\u0627\u0641\u064a\u0629<br \/>\n11. \u062f\u0645\u062c \u0639\u062f\u0629 \u0623\u0648\u0631\u0627\u0642 \u0639\u0645\u0644 \u0641\u064a \u0648\u0631\u0642\u0629 \u0639\u0645\u0644 \u0648\u0627\u062d\u062f\u0629 \u0639\u0646 \u0637\u0631\u064a\u0642 \u0627\u0644\u0628\u0648\u0631 \u0643\u0648\u064a\u0631\u064a \u2014 Excel Masterwork<br \/>\n12. \u062a\u062c\u0645\u064a\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0639\u062f\u0629 \u0645\u0644\u0641\u0627\u062a \u0625\u0643\u0633\u064a\u0644 \u0641\u064a \u0645\u0644\u0641 \u062a\u0632\u0627\u0645\u0646\u064a \u0648\u0627\u062d\u062f \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0643\u0648\u064a\u0631\u064a power query \u2014 \u0627\u0644\u0645\u062c\u0644\u0629 \u0627\u0644\u062b\u0642\u0627\u0641\u064a\u0629<br \/>\n13. \u062e\u062f\u0639 \u0648\u0623\u0633\u0631\u0627\u0631 \u0627\u0644\u0625\u0643\u0633\u064a\u0644 \u062a\u062c\u0645\u064a\u0639 \u0639\u062f\u0629 \u0623\u0648\u0631\u0627\u0642 \u0639\u0645\u0644 \u0648\u062a\u0637\u0628\u064a\u0642 \u062a\u063a\u064a\u064a\u0631\u0627\u062a \u0639\u0644\u064a\u0647\u0627 \u0628\u0634\u0643\u0644 \u0645\u062a\u0632\u0627\u0645\u0646 \u2014 \u0627\u0644\u0645\u062c\u0644\u0629 \u0627\u0644\u062b\u0642\u0627\u0641\u064a\u0629<br \/>\n14. Merging Two Lists Using Power Query Create All Possible Combinations from 2 Lists Using Power Q \u2014 Emad Khalil<br \/>\n15. \u062f\u0645\u062c \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0623\u0648\u0631\u0627\u0642 \u0639\u0645\u0644 \u0645\u062e\u062a\u0644\u0641\u0629 \u0644\u0648\u0631\u0642\u0629 \u0639\u0645\u0644 \u0648\u0627\u062d\u062f\u0629 \u062f\u0627\u062e\u0644 \u0627\u0644\u0625\u0643\u0633\u0644 \u2014 Bayanat School I \u0645\u062f\u0631\u0633\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<br \/>\n16. \u062a\u062c\u0645\u064a\u0639 \u0639\u062f\u0647 \u0645\u0644\u0641\u0627\u062a \u0627\u0643\u0633\u0644 \u0641\u064a \u0645\u0644\u0641 \u0648\u0627\u062d\u062f power query \u0633\u0644\u0633\u0644\u0629 \u0634\u0631\u062d \u0628\u0627\u0648\u0631 \u0643\u0648\u064a\u0631\u0649 \u0627\u0644\u062c\u0632\u0621 2 \u2014 ( Excel Online )  Mr Excel Academy<br \/>\n17. \u062a\u062c\u0645\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0639\u062f\u0629 \u0645\u0644\u0641\u0627\u062a \u0627\u0643\u0633\u064a\u0644 \u0641\u064a \u0645\u0644\u0641 \u0627\u0643\u0633\u064a\u0644 \u0648\u0627\u062d\u062f Power Query Pivot Table \u062a\u0642\u0627\u0631\u064a\u0631 \u0627\u0644 HR \u2014 \u062f\u0631\u0648\u0633  hr  \u0623\u0648\u0646\u0644\u0627\u064a\u0646<br \/>\n18. \u062a\u062c\u0645\u064a\u0639 \u0623\u0643\u062b\u0631 \u0645\u0646 \u0645\u0644\u0641 \u0627\u0643\u0633\u0644 \u0641\u064a \u0645\u0644\u0641 \u062a\u0632\u0627\u0645\u0646\u064a \u0648\u0627\u062d\u062f \u0623\u062f\u0627\u0629 power query \u2014 \u0627\u0644\u0645\u062c\u0644\u0629 \u0627\u0644\u062b\u0642\u0627\u0641\u064a\u0629<br \/>\n19. \u062a\u062c\u0645\u064a\u0639 \u0627\u0643\u062b\u0631 \u0645\u0646 \u0634\u064a\u062a \u0641\u0649 \u0634\u064a\u062a \u0648\u0627\u062d\u062f Append \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 power query \u0633\u0644\u0633\u0644\u0629 \u0634\u0631\u062d \u0628\u0627\u0648\u0631 \u0643\u0648\u064a\u0631\u0649 \u0627\u0644\u062c\u0632\u0621 3 \u2014 ( Excel Online )  Mr Excel Academy<\/p>\n","protected":false},"featured_media":365142,"template":"","meta":[],"categories":[],"tags":[],"class_list":["post-365141","watch","type-watch","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/menhj.com\/videos\/wp-json\/wp\/v2\/watch\/365141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/menhj.com\/videos\/wp-json\/wp\/v2\/watch"}],"about":[{"href":"https:\/\/menhj.com\/videos\/wp-json\/wp\/v2\/types\/watch"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/menhj.com\/videos\/wp-json\/wp\/v2\/media\/365142"}],"wp:attachment":[{"href":"https:\/\/menhj.com\/videos\/wp-json\/wp\/v2\/media?parent=365141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/menhj.com\/videos\/wp-json\/wp\/v2\/categories?post=365141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/menhj.com\/videos\/wp-json\/wp\/v2\/tags?post=365141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}