【有料級】パワークエリでExcel全シートをまとめる秘訣を大公開【YT0215】

In this video, I will explain what *1 and +0 mean in Excel formulas, which at first glance seem meaningless. Yuichi Chiba ━━━━━━━━━━━━━━━━━━━━━━━━━ ■　Reference ━━━━━━━━━━━━━━━━━━━━━━━━━ 🔗LAMBDA helper functions "BYCOL" and "BYROW"    • 【Excel中･上級者向け】LAMBDAヘルパー関数とセットで始めてLAMBDAは実...   ━━━━━━━━━━━━━━━━━━━━━━━━ ■　Download the file ━━━━━━━━━━━━━━━━━━━━━━━━ [Members only] You can download it from the link below.    • Post   ━━━━━━━━━━━━━━━━━━━━━━━━━ ■　Membership ━━━━━━━━━━━━━━━━━━━━━━━━━ You can check out the member-only benefits from the link below.    / @exceldokatach   ━━━━━━━━━━━━━━━━━━━━━━━━━ ■　Excel Dokata Gathering Place ━━━━━━━━━━━━━━━━━━━━━━━━━ We post videos explaining Excel, including Power Query, Power Pivot, and DAX. https://excel-dokata.mish.tv/ ▼Latest video at time of posting Power Query Practical Techniques #0690. Rounding up and down with negative numbers 🎞️Watch on [Members Only Videos]    • #0690.マイナスの数値で切り上げ、切り捨てする   🎞️Watch on [Excel Dokata Gathering Place] https://excel-dokata.mish.tv/ja/video... ━━━━━━━━━━━━━━━━━━━━━━━━━ ■　X (formerly Twitter) ━━━━━━━━━━━━━━━━━━━━━━━━━━ I tweet about video updates, etc.   / chiba_u1   ━━━━━━━━━━━━━━━━━━━━━━━━ ■　Online individual consultation on Excel ━━━━━━━━━━━━━━━━━━━━━━━━ Apply for an online individual consultation on Excel using Zoom. https://bit.ly/3IZTwxF ━━━━━━━━━━━━━━━━━━━━━━━━ ■　Online lessons on Storaka ━━━━━━━━━━━━━━━━━━━━━━━━ Storaka is hosting an online course using Zoom where you can learn how to use Excel. ▼Excel Power Query [Beginner] https://bit.ly/3rrU3gB ▼Excel Power Query [Beginner] https://bit.ly/3cA0UQO ▼Excel Power Pivot [Beginner] https://bit.ly/3cA0UQO ▼Excel Pivot Table [For Beginners] https://bit.ly/36GoKXs ▼List of online courses https://bit.ly/3tvkMKG ━━━━━━━━━━━━━━━━━━━━━━━━━ ■　I post articles on note ━━━━━━━━━━━━━━━━━━━━━━━━━ I post articles about Excel functions, Power Query, Power Pivot, and DAX. https://note.com/excel_dokata ━━━━━━━━━━━━━━━━━━━━━━━━━ ■　Business-related inquiries ━━━━━━━━━━━━━━━━━━━━━━━━━ For business-related inquiries such as outsourcing, contract work, instructor requests, consulting, and private lessons, please contact us here. [email protected] ━━━━━━━━━━━━━━━━━━━━━━━━━ ■　Excel version ━━━━━━━━━━━━━━━━━━━━━━━━━ The Excel used in the video is Microsoft365 Personal (Office Insider Beta, latest version at the time of video release). ━━━━━━━━━━━━━━━━━━━━━━━━━ ■　Timestamp ━━━━━━━━━━━━━━━━━━━━━━━━━ [ 00:00 ] Introduction [ 00:29 ] Why can't I do SUM? [ 04:17 ] 『■*1』 and 『■+0』 [ 05:38 ] In the case of dates [ 11:35 ] In the case of Boolean values [ 14:02 ] Example of use with Boolean values [ 18:34 ] Conclusion #Excel #Excel #Formulas #Skill improvement #Video explanation #Formulas #Functions #Business #Working adults