Use Excel to Count the Seconds in 2024 | Handling Belligerent Excel Requests
It's great when people ask for Excel help. It's not so great when the request is belligerent. In this video I show how I handled a belligerent request to count the number of seconds in the year 2024.
You'll see Dynamic Arrays, SEQUENCE, date formatting, the DAY function and COUNTA ... and insight on how to respond to nastiness.
For a list of my Excel courses at LinkedIn:
/ oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guer...
My old blog: http://datascopic.net/blog-2-2