Use Excel to Count the Seconds in 2024 | Handling Belligerent Excel Requests

/in /by

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:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guerrilla-data-analysis-3rd-edition/
My old blog: http://datascopic.net/blog-2-2