Uploaded November 2024 | Updated September 2026, 1 day ago
Join 400,000+ professionals in our courses here π link.xelplus.com/yt-d-all-courses
This video covers a cool Excel checkbox trick. Make a tweak to your settings to apply a timestamp to your Excel sheets. This is perfect for checking off tasks.
π¨ Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
Join 400,000+ professionals in our courses here π link.xelplus.com/yt-d-all-courses
This video covers a cool Excel checkbox trick. Make a tweak to your settings to apply a timestamp to your Excel sheets. This is perfect for checking off tasks.
π¨ Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
β‘οΈ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
πβ Get the Official XelPlus MERCH: xelplus.creator-spring.com
π Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
π₯ RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
π©Letβs connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel








![The 1-Formula Fix for Excelβs Messiest Tables
Learn Python in Excel: https://www.xelplus.com/course/python-in-excel/
Sales data split across monthly columns? Heres how to reshape it into one clean table, with month, sales, and units each in their own column, using Python inside Excel.
=PY
pd.wide_to_long(sales_data, stubnames=[sales,units], i=sales rep, j=month, sep , suffix=.+).reset_index()
- Type =PY and press Tab to activate Python mode
- wide_to_long turns repeated column groups (like sales_Jan, units_Jan) into rows
- stubnames lists the values youre tracking
- i is your identifier column, like sales rep
- j names the new column that holds the month
- sep matches the separator in your source headers
- suffix=.+ means the leftover text can be anything
- reset_index() keeps everything aligned
- Right-click the Python output and choose Excel Value to drop it into cells
Add a new month to your source data and the table updates on its own.
Uses the pandas wide_to_long function. Check the pandas docs for the full reference.
π¨ Subscribe to Between the Sheets newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter
π Join this channel to get access to perks:
https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
π² Letβs connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/in/leilagharani
#Excel The 1-Formula Fix for Excelβs Messiest Tables](https://i.ytimg.com/vi/aUlGfk7kst0/mqdefault.jpg)

