Financial Modeler's Corner
00:22:49 · Giles Male, Paul Barnhurst
[00:22:49] S1: But you're very... How can I describe this? Like, when you deliver training, like I said, we've we've done stuff together. You put a lot of effort into making it fun as well as educational. And I feel like that's such a huge part of what a trainer or a good trainer is. It's not just technically being aware of the content. It's actually, like, thinking about the experience across half a day a day for people, which I I think you do as as well as anyone I've seen, really. [00:23:18] S0: Well, thank you. So I think, you know, speaking to that, I'll I'll I'll... I'm gonna flip it back to you and ask a question. If I asked you to think of top speeches or presentations you've been to, some of the best presenters, what percentage or how many use some kind of humor in their speech? [00:23:32] S1: All of them. [00:23:33] S0: All of them. Right there. What do you remember? And so that keeps people engaged, and it makes them realize we can have fun while doing this. And so it just lightens the entire mood. Cause let's face it, probably anywhere from 20 to 80% of the people in the room don't wanna be there. [00:23:51] S1: Yep. It's so true with team training. Right? With team... Yeah. It's different when people have paid their own money to be on a boot camp or something. But when it's team, yeah, it's very different.
00:23:51 · Giles Male, Paul Barnhurst
[00:23:51] S1: Yep. It's so true with team training. Right? With team... Yeah. It's different when people have paid their own money to be on a boot camp or something. But when it's team, yeah, it's very different. [00:24:03] S0: Yeah. When they've been told... They've been voluntold that they will attend this training. And if you're doing Excel training, the reality is one person knows everything you're talking about and may even be better at Excel than you. One person probably should have one on one training because they may not have ever used a spreadsheet, and then you got a range everywhere in between. So you have to break it up, do something to help keep them engaged in addition to being hands on. Otherwise, you're just gonna lose the room. Anyone can claim to be able to build a model. Not everyone can defend one when the questions start. The advanced financial modeler puts your modeling under real scrutiny, so you know it holds up. I invite you to become an AFM. Go to fminstitute.com/podcast. That is fminstitute.com/podcast and use code podcast for 15% off.
00:24:03 · Paul Barnhurst, Giles Male
[00:24:03] S0: Yeah. When they've been told... They've been voluntold that they will attend this training. And if you're doing Excel training, the reality is one person knows everything you're talking about and may even be better at Excel than you. One person probably should have one on one training because they may not have ever used a spreadsheet, and then you got a range everywhere in between. So you have to break it up, do something to help keep them engaged in addition to being hands on. Otherwise, you're just gonna lose the room. Anyone can claim to be able to build a model. Not everyone can defend one when the questions start. The advanced financial modeler puts your modeling under real scrutiny, so you know it holds up. I invite you to become an AFM. Go to fminstitute.com/podcast. That is fminstitute.com/podcast and use code podcast for 15% off. [00:25:11] S1: I agree. And and I spoke about this a few years ago somewhere where I said, you know, on average within a cohort of say 30 people, you will have a pocket, maybe 5% of people that are genuinely very good. And interestingly for me, the people that rate themselves as experts quite often aren't the best in the group. It's the ones that rate themselves as intermediate or they know they're pretty good, high end intermediate, but they're so aware of everything they don't know that they are really hesitant to call themselves experts. I don't know if you've had that experience.
00:25:11 · Giles Male, Paul Barnhurst
[00:25:11] S1: I agree. And and I spoke about this a few years ago somewhere where I said, you know, on average within a cohort of say 30 people, you will have a pocket, maybe 5% of people that are genuinely very good. And interestingly for me, the people that rate themselves as experts quite often aren't the best in the group. It's the ones that rate themselves as intermediate or they know they're pretty good, high end intermediate, but they're so aware of everything they don't know that they are really hesitant to call themselves experts. I don't know if you've had that experience. [00:25:45] S0: A 100%. And, you know, honestly, when people ask me, I think of myself as intermediate. I recognize compared to a lot of people to say I'm advanced, but I rarely use Lambdas. I don't... I almost never use VBA. I mean, there's so many areas where I know I could be much more efficient in Excel. Now that's not to say I don't know more in the sense of... I probably know more formulas and have done more in Excel than 90% of people, but I... That doesn't mean I'm an expert. I think there's a there's a very high bar when I think of a true expert. I think of someone like a dim. I think of many of these MVPs, though I'm an MVP that I look at, I'm like, I wish I had forgot about as much of Excel as they know. You know what I mean? Like, they forgot more than I'll ever know type of thing.
00:25:45 · Paul Barnhurst, Giles Male
[00:25:45] S0: A 100%. And, you know, honestly, when people ask me, I think of myself as intermediate. I recognize compared to a lot of people to say I'm advanced, but I rarely use Lambdas. I don't... I almost never use VBA. I mean, there's so many areas where I know I could be much more efficient in Excel. Now that's not to say I don't know more in the sense of... I probably know more formulas and have done more in Excel than 90% of people, but I... That doesn't mean I'm an expert. I think there's a there's a very high bar when I think of a true expert. I think of someone like a dim. I think of many of these MVPs, though I'm an MVP that I look at, I'm like, I wish I had forgot about as much of Excel as they know. You know what I mean? Like, they forgot more than I'll ever know type of thing. [00:26:25] S1: And the funny thing is Dim would probably rate himself seven or eight out of 10. Like, there's no way he would say nine or 10. And I've had people when... Because we we quite often, like, send out questionnaires, self assessment questionnaires for training. I've had a group where somebody literally put 10 out of 10 and in the free text box, I do not need training. And that that... That's mind blowing to me because very quickly, you see, like, they do need training and they do need help.
00:26:25 · Giles Male, Paul Barnhurst
[00:26:25] S1: And the funny thing is Dim would probably rate himself seven or eight out of 10. Like, there's no way he would say nine or 10. And I've had people when... Because we we quite often, like, send out questionnaires, self assessment questionnaires for training. I've had a group where somebody literally put 10 out of 10 and in the free text box, I do not need training. And that that... That's mind blowing to me because very quickly, you see, like, they do need training and they do need help. [00:26:51] S0: So I'll share one story on that. I'm interviewing a guy for an FP and A role. This is... So ten years ago now, probably. And I I would always ask a question. I ask people to rate themselves on a scale of one to 10 in Excel. And it wasn't about the answer because then I'd ask them to explain why they rated themselves that way. [00:27:09] S1: Yeah.