Ctrl+` will show the underlying formula, or you could use conditional formatting to apply whatever style you want to static values =NOT(ISNUMBER(FIND("=",FORMULATEXT(A1)))), or you could write a VBA macro to do that and more (e.g. find all the formula that have been zeroised, etc).
I did exactly that with a VBA macro, that indicated whether something was a formula, a constant, or empty. I would just put it next to my column of calculations. It was not what I would call "clean code" but sure made it easier to follow my thought process and find bugs.
The macro was the first thing that came to mind. Your formula is cleaner.
You could make it a matter of style discipline. In my non-trivial spreadsheets I typically have cell formatting conventions, e.g. light yellow background is input, light green is formula, etc. You do have do it manually but it's worth the effort in my case.
I've never seen that particular claim about the museum - it was set up to hold Sloane's collection alongside the Cottonian and Harleian libraries. Where is it from? Is this a misremembering of the tale about the discovery of the flood tablet?
I'd guess war is usually excluded from insurance policies.
I wonder if the 1 in 200 year example wasn't communicated very well; it could be the actuaries view a long-lasting 10% increase to be the 1 in 200 year event; it does sound low for a single year stress.
Article lead: The overall risk of children becoming severely ill or dying from Covid is extremely low, a new analysis of Covid infection data confirms.
As far as I can tell the linked report mentions nothing about severity of illness, only mortality.
Edit: Second study is linked to further down the page which addresses the severe illnesses, as ricardobeat points out.
Looks like they are reporting on multiple studies. There is a second paper that includes hospitalization rates linked under the “Hospital stays are rare” section.
Also mentions nothing at all about the rapidly-rising Delta strain that appears to hit younger people much harder than other/earlier strains and in preference to older folk. Ugh. This virus is horrible.
I'd like to think that was accounted for in the analysis.
We can compare children infected last year when other strains were dominant, with children infected this year in UK (likely to get the Delta variant).
You can open separate Excel instances by holding ALT when starting it up (second time onwards). Not quite the same thing as you want, but think the undo behaviour you describe makes sense if you're working in two sheets that are linked in some way.
Can you elaborate on this? It sounds like it would solve my "I can't open two files with the same name" problem too, but I hold down ALT and double-click my second file in explorer and I get the "Properties" dialogue for that file. If I instead hold ALT and click on Excel itself, it opens a new window but it still seems to be linked to the same process (and gives the same error when trying to open the second file of the same name).
This should work on windows - I'm not sure about Macs: you press and hold the ALT key, then right-click the Excel icon in the Windows taskbar and click the Excel icon above the taskbar, but keep holding ALT down. It should pop up a window saying "do you want to start a new instance of Excel". You can then open your (same named) file in the new instance.
I suspect your example is only for context, but just in case it saves you time in future, if you can sort the data first then you can use something like: if(vlookup(value,range,1,TRUE)=value, vlookup(value,range,column,TRUE), error_marker). The TRUE returns next nearest match, the IF ensures you have an exact match, and it takes a few seconds to lookup over hundreds of thousands of rows.
I found early-on that MOOCs were terrible for learning because of the barriers they put up. Locked-in time schedules, a trend towards very short "bitty" and simplistic videos that don't tend to offer any direction when they're done.
Youtube lectures on the other hand have been immensely valuable, especially if you can find a relevant (university) reading list and/or problem sets if they're applicable. All you really need as a self-learner is someone to say "head in this direction". After that I agree with op that finding something fun to do is the best way to learn.
On an aside, as a text highlighter (I highlight the text I'm reading), the javascript "tweet this" pop-up on this site is horrific.
I wouldn't worry that it's your failure, you're just not into it.
I loved Windup Bird Chronicle. I struggled with 1Q84. I find the same thing in every creative field (art, film, lit, games); a favourite author/artist/director/company will release something I think is a real stinker while everyone else praises it, and vice versa.
Of course it can help to build up a vocab/grammar/approach to appreciate particular works or what something is referencing, but there are too many fish you'll never even see to be worrying about one author. Just hunt down the stuff you like and don't be afraid to give up halfway through if you're not enjoying it. It sounds like you've already figured that part out.
Interesting. That's the second one I read, but I put it down 5 chapters in and never picked it back up. So it sits in my 'to read' pile. I even confiscated the bookmark the last time I rearranged my books, because I'd have to start over at this point.
