How to combine text with date values to create a dynamic Title in Excel

Опубликовано: 01 Октябрь 2024
на канале: Celia Alves - Solve & Excel

1,440

I met this lady once whose task every year was to create 24 copies of the same Excel file and update dates and date-related titles on each one of the files manually. One file for each pay period in that year. Then, she also had to send each pay period files to the employees in her company.

I feel so sad when I see people wasting time with tasks like these. With a couple of very simple adjustments, we can make that spreadsheet valid forever, for any pay period, without us needing to keep making copies, adapting them manually and sending out new versions every month.

----------------------

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer

LIVE CLASSES on YouTube every week: https:www//   / celiaalvessolveexcel

Get access to the Live Classes EXERCISE FILES by joining our Telegram Group at https://t.me/celiaalvessolveexcel

Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia

Solve & Excel Consulting - https://solveandexcel.ca
LinkedIn:   / celiajordaoalves
Facebook:   / solveandexcel
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