Sign up at the link…
2 Likes
I signed up, I’ll see how many puns I can make when we get to the Q&A portion.
3 Likes
Oh! I didn’t even think of that! BRILLIANT!
2 Likes
I don’t suppose that it’s possible to attend without joining LinkedIn.
Not to my knowledge but uh you don’t need to sign up to LinkedIn with your real name/address iykwim.
I hope meep doesn’t steal all of T-Roy’s material
2 Likes
Here is the zoom registration link without having to go through LinkedIn:
Enjoy!
I’ll be mentioning ASOPs! (the intended audience is not actuarial, but I -am- trying to infect non-actuaries with our standards)
1 Like
Good stuff, meep! I had my fingers crossed you were about to show the ‘mistaking something for a date’ meme and you delivered, lol.
1 Like
Where is the setting to turn off the date problems in Excel?
Thank you meep!
That whack-ass formula you posted was amazing. Straight to jail!
2 Likes
I’m using Excel 365, so maybe you don’t have this setting, but here goes:
Under Options → Data
There’s an “Automatic Data Conversions” section, and I unchecked that whole thing.
By default, those are the conversions that occur when you open a .csv or text file or whatever in Excel. I DON’T WANT THAT.
Often, I do want leading zeroes (these are ID numbers, not actual numerals), etc. So I don’t want things to change.
That came from the old AO. I forget who posted it… but I did archive that thread, so I could probably find out.
Here’s the YouTube link of the recording
1 Like
And here are the slides
Preventing_Errors_in_Financial_Worksheets.pdf (862.3 KB)
Thanks!