I just got my second failed attempt at the MOS Excel Expert exam and I'm honestly pretty demoralized. Both times I've scored around 680, and you need 700 to pass. I've been using a MOS practice test from a couple different sites but I keep getting tripped up on the same stuff — advanced formulas, specifically the nested IFs and some of the data validation tasks where you have to configure specific error messages.
My study routine has been maybe 2-3 hours a week for about six weeks, which in hindsight probably wasn't enough. I found a solid MOS study guide on Reddit that covers all the objective domains, but I feel like reading about it and actually doing the timed tasks in the real exam are totally different animals. The live-in-application format really throws me off.
Has anyone else struggled with the hands-on task format? I'm thinking I need to shift from reading to just doing practice tasks constantly. Any exam tips on how you structured your last few weeks before passing would be huge.