In this episode of Financial Modelers Corner, host Paul Barnhurst is joined by Giles Male, who brings his unique perspective on the rapidly changing landscape of financial modeling. Together, they explore how the latest advancements in Excel—such as dynamic arrays and Lambda functions—are revolutionizing the way financial models are built and used. Giles also provides invaluable advice on the importance of simplicity, adaptability, and effective communication in modeling.

Giles Male is a CMA-qualified accountant and a seasoned financial modeler with extensive experience in bid analysis and complex financial modeling. As a co-founder of Full Stack Modeler, Giles is passionate about training and mentoring the next generation of financial modelers. He holds the prestigious Master Financial Modeler (MFM) accreditation from the Financial Modeling Institute, making him one of only seven individuals worldwide to have achieved this honor. Giles brings a wealth of knowledge on modern Excel and its application in financial modeling.

Key takeaways from this week's episode include:

• The importance of embracing modern Excel techniques, including dynamic arrays and Lambda functions.

• Insights into the changing landscape of financial modeling and why simplicity is often more effective than complexity.

• The challenges and rewards of transitioning from traditional modeling methods to modern approaches.

• How Giles's experiences in ultra-marathon running have influenced his approach to problem-solving and pushing beyond perceived limits in both personal and professional contexts.

• Practical advice on maintaining model integrity, including the use of structured standards like FAST or SMART while adapting to specific project needs.
  

Here are a few quotes from Giles Male:

• "Simplicity is the biggest lesson I’ve learned in my career. Complex models might seem impressive, but they’re often impractical." - Giles Male

• "A good financial model should be as complex as it needs to be, but as simple as possible." - Giles Male

• "There’s a visibility fog when reviewing your own models. Stepping away and coming back later is essential." - Giles Male

In this episode, Giles Male offers a wealth of insights into the evolving world of financial modeling. He emphasizes the importance of simplicity, the transformative power of modern Excel, and the critical need for clear communication in model design. As the industry continues to evolve, Giles’s focus on adaptability, continuous learning, and user-centric design serves as a guide for both seasoned professionals and newcomers alike.

Follow Giles:

• Website - https://www.fullstackmodeller.com/
  LinkedIn - https://www.linkedin.com/in/giles-male-30643b15/

Follow Paul: 

• Website - https://www.thefpandaguy.com   

• LinkedIn - https://www.linkedin.com/in/thefpandaguy  

• YouTube - https://www.youtube.com/@thefpaguy8376  

Follow Financial Modeler's Corner  

• LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  

Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984

Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’.

Visit www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. 

In today’s episode:
[01:18] - Introduction to the topic and guest Giles Male

[05:31] - Lessons from complex models
[07:12] - Giles shares his career journey into financial modeling
[16:10] - Achieving master financial modeler accreditation

[17:19] - Giles shares practical project insights
[28:42] - Defining advanced modeling skills

[34:00] - The future of excel and financial modeling

[41:50] - Excel shortcuts and best practices

[47:47] - Conclusion and contact information

Full Show Transcript

[00:00:00] Host: Paul Barnhurst: Tell me that horror story. What's that worst financial model you've ever seen or worked on?

[00:00:05] Guest: Giles Male: The worst one I've seen professionally that wasn't mine, which I've spoken about in a couple of places before, was I saw somebody running a month end model and it had a VBA macro dashboard, and I watched this person get a piece of paper out, which was a handover document. Click all of these buttons in an order looking at this piece of paper, and I asked him what they were doing and he didn't know. And when I dug into the code, none of what he was doing with the VBA buttons had any impact. I think there's a very common journey that good modelers go on, where you probably do start to get good at Excel and learn some clever things. One of the most rewarding things that I've done in my life, it's a hell of an experience getting to these points where you think you've hit a limit. The addiction, I think, is just what it gives you back as positive self-talk. I think it's great that they're putting Excel under pressure. I just think Excel has evolved so much.

[00:01:02] Host: Paul Barnhurst: Welcome to Financial Modelers Corner, where we discuss the art and science of financial modeling with your host, Paul Barnhurst. Financial Modelers Corner is sponsored by Financial Modeling Institute. Welcome to Financial Modelers Corner. I am your host, Paul Barnhurst. This is a podcast where we talk all about the art and science of financial modeling with distinguished financial modelers from around the globe. The Financial Modelers Corner podcast is brought to you by the Financial Modeling Institute. FMI offers the most respected accreditations in financial modeling, and that's why I completed the Advanced Financial Modeler. I'm thrilled to welcome our guest to the show this week. Giles. Male, welcome to the show.

[00:01:54] Guest: Giles Male: Thank you very much for having me, Paul.

[00:01:56] Host: Paul Barnhurst: Excited to have you. Giles is one of the few guests we've had on more than once. He was part of a roundtable discussion where we talked about AFM and some other things, and we thought we'd bring them back for a solo appearance. He wanted to talk to all of you. So here he is, right? You know what? First question is coming. I don't think you got this question last time. Tell me that horror story. What's that worst financial model you've ever seen or worked on?

[00:02:23] Guest: Giles Male: So many. And I'd probably break them down into categories. There will be some of my own from my early career, where I just had those crazy sort of 1015 line formulas that I was very proud of at the time. The worst one I've seen professionally that wasn't mine, which I've spoken about in a couple of places before, was I saw somebody running a month end model, and it had a VBA macro dashboard with a bunch of buttons, and I watched this person get a piece of paper out, which was a handover document. Click all of these buttons in an order looking at this piece of paper, and I asked him what they were doing and he didn't know. And when I dug into the code, none of what he was doing with the VBA buttons had any impact on the things that the models. The model was used for. It was crazy. And he'd been handed this model well over, I think 6 or 7 months ago, so that's probably the weirdest one.

[00:03:16] Host: Paul Barnhurst: Yeah, I had a guy I interviewed yesterday, you know, episode that will be coming out, and he mentioned when he dug into it, 50 different workbooks were externally linked to the model, and some of them went as deep as seven. So they went back. When you got back to the original one, they were linked through seven different workbooks and in some cases there were circular workbook links in the, you know, the third one here referenced back to the first one in different areas. And I was just like, oh man. Right. I was like.

[00:03:53] Guest: Giles Male: That's back to like a pre Power Query world, which actually, when you think of it, is what, more than ten years ago, where you had like those dedicated input and output external link sheets if you were doing that well. But yeah that's bad. 

[00:04:10] Host: Paul Barnhurst: Yeah. I mean, I'm not a fan of workbook links. I've used them. But make sure you're doing it well and I've done it not well, but I've been pretty limited. And it's usually only workbooks I'm working with. Never have somebody else own your external workbook link if you're going to do it. I'm with you. It should be Power Query. But there's those rare occasions and if people do it well they're structured really well. You can you can do it. I generally say no just because they're usually not structured well and they're more of a problem than they're worth.

[00:04:40] Guest: Giles Male: It's one of the things that would make you most nervous, isn't it, when you open it up. And if you saw 50 external workbook links, I would immediately be very nervous.

[00:04:48] Host: Paul Barnhurst: The one that makes me most nervous is when you open the formula and name manager, and it has thousands of external link. References. So not even workbook links, but I've had one where the code there were so many and it's such an old file. There was a VBA code I'd use to kind of break all the links and take all that out. It wouldn't even run on the file.

[00:05:11] Guest: Giles Male: You are exactly right. And I've seen ones where you open it up and you've got thousands of just ref errors in the name manager. And again, you just think, well, this is just not been looked at at all. So yeah, you're bringing back some really traumatic memories for me within the first five minutes Paul.

[00:05:26] Host: Paul Barnhurst: Well you're welcome. I guess we can now have a therapy session, some PTSD

[00:05:30] Guest: Giles Male: Please. Yeah, that'd be great.

[00:05:31] Host: Paul Barnhurst: Some of these horrible models you've seen, the one you mentioned there and some of the others. What was the learning experience? What's been kind of the key takeaway when you see these models?

[00:05:41] Guest: Giles Male: I mean, the key takeaway from my own experience was not to get wrapped up in your own, not to be impressed by your own, you know, level of complexity in what you're creating. I think there's a very common journey that good modelers go on where you probably do start to get good at Excel and learn some clever things. And you think that clever, complex stuff is impressive. And then and then typically something goes wrong and, and you learn about the importance of finding the simplest way to do things. So that's been the biggest lesson, I think, in my whole career. Probably simplicity.

[00:06:16] Host: Paul Barnhurst: Yeah, I think we all learned that somewhere along the line that, yeah, my favorite quote or one of my favorite quotes that people hear me say a lot is simple is actually hard. Complex is easy. It's usually a lot easier to write that complex formula than to really think about how do I design and structure and build this in such a way that it's really simple for people to understand.

[00:06:37] Guest: Giles Male: Daniel Stein first had a really nice quote. I can't remember when she said this, but she said you should build models as complex as they need to be, but as simple as you can make them. I'm paraphrasing a little bit, but that really stuck with me in the last year or so.

[00:06:52] Host: Paul Barnhurst: Yeah, and it's a great way I've heard someone else say, make it as simple as you can because the end user is going to make it more complex just as you go through the process.

[00:07:02] Guest: Giles Male: Yes.

[00:07:02] Guest: Giles Male: That's it.

[00:07:04] Host: Paul Barnhurst: That's the other one I heard I like that. I'm like, you do everything as simple as you can because don't worry, they'll complicate it for you.

[00:07:10] Guest: Giles Male: Yes.

[00:07:11] Guest: Giles Male: I'm going to remember that.

[00:07:12] Host: Paul Barnhurst: Why don't you tell our audience a little bit about yourself and your background?

[00:07:16] Guest: Giles Male: Sure. So, I mean, on paper, I'm a CMA qualified accountant, and I got out of the kind of management accounting side of things as quickly as I could. I'm really what I would call a sort of career long financial modeler. My first job was really intense bid analysis. So building big, complex three statement models for bids, doing lots of things like Monte Carlo analysis, dealing with auditors, working through lots of complex modeling scenarios. So I feel like I got really lucky in my early career. Got very early exposure to some things that, you know, some modelers don't get to for decades. And then I hit 30 and had a I keep saying describing this as my first midlife crisis, but basically I just got frustrated. I wanted to do my own thing and I didn't know what to do. And I think, like many people in that space, you kind of sit there and think, well, God, how do I start my own thing here? And the only thing I wanted to do was excel work. So I went on this path into contracting and freelancing, trying to build models for people, my evenings and my weekends, and then eventually met Miles, my business partner, and we did some consultancy work together. And now I co-found Full Stack, which is a training company for modelers at all levels.

[00:08:41] Host: Paul Barnhurst: Got it.

[00:08:42] Host: Paul Barnhurst: Yeah, I think a lot of people get to the point where you kind of want to do your own thing, set your own schedule. You're tired of building a model at one in the morning, whatever it might be.

[00:08:51] Guest: Giles Male: Yes.

[00:08:52] Guest: Giles Male: It's always the model. The model is always the last thing. That's what I found, especially on big projects. You know, everything else gets done. There's a timeline and the models the last thing. So it's always you that's there on the evenings and the weekends just before the submission date, which was. Yeah. And you're.

[00:09:07] Host: Paul Barnhurst: Always holding them up like, why don't we have the model? But before we get into the good old fun, hard code modeling stuff, we're going to talk hardcore running for a minute. I know you're a big running fan. You recently did an ultra marathon, so one that tells me you're crazy because I've done marathons and I thought I was crazy, but ultra, it's a whole new level. So tell us about the event you did. What was the distance? What was that experience like for you and where did you go? Was it Africa for that one?

[00:09:33] Guest: Giles Male: Yeah, I was in South Africa. So this was the third part of a trilogy for me. I got into I got into Ironman events, so big triathlons about 6 or 7 years ago, and I really wanted to do an Ironman, a full Ironman and Marathon disable, which is the multi-day desert ultramarathon through the Sahara and then comrades, which is the one I've just done in South Africa. It's an 86 kilometer road race, so you've got to do it in less than 12 hours. It was hot. It was very hilly. It was very, very tough. And again, one of the most rewarding things that I've done in my life, it's a hell of an experience getting to these points where you think you've hit a limit and then finding something that you can drag yourself beyond where you think your limits are. It's one of the most addictive things that I do in my life, to be honest.

[00:10:25] Host: Paul Barnhurst: You know, it's funny you say addictive because most people I knew who did ultras, in my experience, running clubs, they had that addictive personality. It's really interesting because you almost have to have it to commit the time it takes to do it, and that was the biggest thing for me. I've done a few marathons, I've done a half Ironman. I'm like, I could do a full. I just value my time too much. So I admire anyone that's able to carve out that time because I know it's a tremendous commitment to do an event like that.

[00:10:56] Guest: Giles Male: Well, it is. And you know what? What I think I learned from comrades because I went as part of an organization called Africa marathons, who this group makes sure everything around the race is done for you, so you can just turn up and worry about the running. But I was there as part of a group of about 25 people, and I quickly learned that most other people doing this actually do manage to take their running very seriously. And, and it was just me that was flagging at the back of the pack that realized, you know, 11 hours in, I was like, oh, I probably should take this, this training stuff more seriously. But it is fun. It is the addiction, I think is just what it gives you back as positive self-talk. You know, when, when you feel like you can really back yourself and you can push through what you assume are your limits, that that for me has been a huge, you know, value add to lots of areas of my life.

[00:11:50] Host: Paul Barnhurst: So it sounds like the biggest thing is it's helped you realize what you're capable of, kind of overcoming that negative self-talk we all deal with.

[00:11:58] Guest: Giles Male: I think that's exactly. I think it's the self-talk. I remember in my 20s, you know, if you'd seen me in a meeting with, I don't know, a CFO or an FD there because I was young and I was quite inexperienced, and I don't think I'd done anything professionally that I was that proud of. I had that kind of slightly negative inner talk where you're just like, oh, this person probably doesn't want to be sat with me, or I bet I look stupid, I'm probably doing something wrong. And I found that even after the first half Iron Man, I did. And you might, you know, empathize with this a bit like it's still six, seven hours of running and swimming and cycling, and I genuinely didn't know if I was going to finish. And to get over that finish line just gave me something, you know, that I felt really, really proud about.

[00:12:46] Host: Paul Barnhurst: Yeah, for me I didn't know if I was going to get out of the water. It was raining, cold, extremely windy and I wasn't a good swimmer. And I jumped in the water and it was just pounding over my head, people kicking me left and right and I'm just like, yes, I'm miserable. I can't finish this swim. I almost went right to the boat. I'm like, no, I can get through this. And we only had to do half the swim because they're afraid lightning was coming.

[00:13:09] Guest: Giles Male: Oh, wow.

[00:13:09] Host: Paul Barnhurst: Because there was a window we had and they're like, if we go beyond this window, there's too big a risk. You can't have someone in the water with lightning and thunder, right? And I dragged my body, one of the last people out of the swim get on the bike. And we got 50 mile an hour wind gusts that day and hail. I got two flat tires on the bike. Finished the bike ride. The run was the piece of cake because I'd run marathons. I'm like, all I got to do is keep moving. I can do the run. This is the problem.

[00:13:37] Guest: Giles Male: Where was this? Where were you in the world?

[00:13:39] Host: Paul Barnhurst: It was in Utah.

[00:13:40] Host: Paul Barnhurst: It was Utah Lake.

[00:13:42] Guest: Giles Male: Okay, okay.

[00:13:44] Host: Paul Barnhurst: They did not. They used to do an Ironman out of there until, I shouldn't say this, but somebody drowned in the open water swim and they stopped doing the Ironman there.

[00:13:52] Guest: Giles Male: Okay.

[00:13:53] Guest: Giles Male: Fair enough.

[00:13:53] Host: Paul Barnhurst: So probably yeah, we were doing it in a protected area because they moved the location when they did the half, so they wouldn't be out in the open water after the person drowned. I'm like, yeah, probably a smart move. So anyway, but that was my half Ironman experience. And of course it cleared up. It was nice weather, cool for the run. So it was perfect. The rest of it was just miserable.

[00:14:16] Guest: Giles Male: It's tough, you know, and I remember getting to the end of it. And my first thought when I, when I started speaking to people after the first half was I'm never doing that again. And why would anybody do a full Ironman? And then a week later I'd signed up to Ironman UK, which is a very classic story for people that get into this.

[00:14:34] Host: Paul Barnhurst: Yeah.

[00:14:35] Host: Paul Barnhurst: It's funny. Like you finish your like I'm never going to do that. It's like a friend of mine told me, you know, his wife was having a baby. It was like their third kid. And she goes, remind me we're never having a kid again during the pregnancy. Like six months later, she's like, I think I want to have a kid. And he reminded her of that. And she goes, you know, you cannot use anything I said during childbirth against me. It's kind of like that first hour after the run. You just ignore everything you said.

[00:14:59] Guest: Giles Male: Yep.

[00:15:00] Guest: Giles Male: Totally agree.

[00:15:01] Host: Paul Barnhurst: One last thing there, and then we'll move on to the real meat of our interview here. Any interest in doing the Badwater Ultra here in the US, where you go from lowest point in the continental US to the highest through Death Valley. 140 miles.

[00:15:19] Guest: Giles Male: Yes. So I'm really easily persuaded to do stupid things like this. I'm. I have to admit, you know, comrades was just over a month ago. Mentally, I'm still in a post ultra phase where the last thing I want to do is run, but it will end. And the short answer to that is, yeah, definitely. I'd be very easily persuaded. I need something.

[00:15:43] Host: Paul Barnhurst: To live outside there. So I remember always hearing about it and the runners and you run to the base of Mount Whitney, and then a few super crazy people will then decide to hike Whitney so they can say they went from the lowest to the highest point in the continental US and add an extra, you know, 18 miles to the trip and over 20,000ft of elevation gain altogether.

[00:16:04] Guest: Giles Male: Yeah.

[00:16:05] Guest: Giles Male: I mean, it sounds so crazy that I'm instantly interested, so yeah, we'll keep that one in mind.

[00:16:09] Host: Paul Barnhurst: That tells me a lot about you. All right. Let's move on to modeling here. So you were recently awarded the master financial modeler from the FMI Institute. What was that like? Talk a little bit about that.

[00:16:23] Guest: Giles Male: A huge honor, to be honest. I mean, I like you, you know, you know, from AFM, I've put a lot of work into the FMI certification program. And CFM when you step up is no joke. So, you know, it's a good 100 hours plus of study. So I, you know, I put my application in for MFM and I think I'm the seventh to be awarded it in the world. And I'm very honored, you know. And I say this just to manage my own imposter syndrome, it doesn't mean that I'm like one of the seven best modelers in the world. It's reflective of what you're doing in the broader industry and how you're trying to help people. So yeah, huge honor. I do feel like I've put a lot of work into trying to be active and support people publicly in the last 12 months. I'm looking forward to what it means I can do to support them.

[00:17:14] Host: Paul Barnhurst: Cool.

[00:17:15] Host: Paul Barnhurst: Well, congratulations on that. Thanks for sharing a little bit about that. Now modeling, I'm curious, what's the most interesting or funnest project you've ever worked on for a model?

[00:17:27] Guest: Giles Male: It's probably the biggest one that I ever worked on, so I worked on a smart metering bid. , so years and years ago. Well, not that many years ago, but, you know, we had a rollout for smart meters in the UK. I don't know if you're familiar with this. You know, essentially, like intelligent gas and electric meters where, you know, you don't have to get a meter reading all the time. So this was a huge project and I ended up having this network of models. You had different regions in the UK that you were modeling for and pricing for, and just the largest team imaginable. So many subject matter experts, so many assumptions to manage. , but it was the most valuable project I've ever worked on. And there's one story from that I wanted to share with you which which is nothing to do with the modeling. And but it was a real learning point for me. We had a really strong program manager, and he went through this process with all of the subject matter experts, bearing in mind these are people that are probably going to be managing if you win the bid areas of this project that are operating in the millions of pounds each year. And he set them a task, and I had to set up a spreadsheet with three columns and three numbers, and it was right for your area.

[00:18:41] Guest: Giles Male: Just give me three numbers. What do you think? The kind of essentially the best case, the worst case, and the most likely cost is for your area. And underneath, I just want three things that would take us from the most likely to the best, and three things that would have to happen to take us from the most likely to the worst number. And that was it. There was no modeling. It was just three numbers. And then he brought every one of these SMEs in one by one with a team of us there watching. And he got them to justify this thing. You know, why? Why have you put this thing that would get us from the most likely cost to the best? And what you got out the back of that was 25 versions of things that you could then go and work on as a risks and opportunities management tool. You know, if you go and make sure these things happen, you will drop the cost base by X. If you make sure these things don't happen, we're probably going to protect about the cost base rising. And it was just such a big learning curve for me of like the modeling is important, like complex modeling is needed, but there's a whole other area of like interaction and just communication that's just as valuable on projects like this.

[00:19:55] Host: Paul Barnhurst: Yeah. I mean it's like when you build a budget, biggest part is the planning and the assumptions. It's that conversation and thinking about the risk and really the business understanding. And sometimes we think, oh, it's all about the model. But at the end of the day, the model is just a representation of what the work we really do.

[00:20:14] Guest: Giles Male: Absolutely.

[00:20:15] Guest: Giles Male: And, you know, you might recognize this kind of thing where you sit in a room with a CFO and they kind of already know the answer that they think the model is going to give you. You know, you're there just to prove that the number in their head is right, but they kind of know it. So yeah, I found those moments in my career really interesting. When you meet people that are just their level of awareness is like three steps ahead of where you are, and you're just excited about the modeling part.

[00:20:43] Host: Paul Barnhurst: Agree with you there. Always great to work with. They can really think through all those situations, and the worst is when you have the CFO that already has the answer in his mind and the model doesn't support it at all.

[00:20:52] Guest: Giles Male: 100%.

[00:20:53] Guest: Giles Male: And they can see it. You present the numbers and they instantly see. They go, look, line 25 that that cost line there. That's not right in year three. And you're like, well how do you know that? Just looking at this for the first time. And they're right. 

[00:21:08] Host: Paul Barnhurst: They can spot any number on anything. And they're just like well this and that and that. And you're just like, oh my goodness, I didn't even know that.

[00:21:15] Guest: Giles Male: Exactly.

[00:21:16] Host: Paul Barnhurst: I know what you're talking about. I've dealt with some of those. So you mentioned starting, you know, Full Stack Modeler and you've been running that now for, what, about five years? Four years.

[00:21:26] Guest: Giles Male: Yeah.

[00:21:26] Guest: Giles Male: Five years. Incredibly. That's gone fast.

[00:21:31] Host: Paul Barnhurst: So talk a little bit about how you started it. And then even more importantly, what do you hope others get from the program. So like kind of what is the program and what does somebody get by going through full stack modeling.

[00:21:44] Guest: Giles Male: Yeah, I think it's probably changed over time. You know, originally it was a group of four co-founders, all coming together with different skill sets. The team's changed now, So me and my business partner Myles run it. We've got a growing team that we actually kind of lean on. A lot of our members now part time to help us run the business. But it's a community. It's a training program that covers a lot of the fundamentals. It's called full stack because we try and think of it as the full stack of skills that we think you need to. Certainly, you know, Excel fundamentals, financial modeling fundamentals, but also things like dataviz, you know, understanding how you manage data at different levels, whether it's just a bit of Power Query or more complex things. , and getting really sort of hands on practical experience in the community. So, you know, we work with individuals who pay to join us on a 12 month membership they pay out of their own pocket. But we also work with some of the biggest companies in the world in all sorts of sectors who put cohorts in, and we kind of help manage those cohorts, you know, pretty intensely throughout their time with us.

[00:22:58] Host: Paul Barnhurst: So it's a 12 month immersive program where you're covering the full stack, the dataviz, the modeling, all of it, not just, hey, here's how you build a three statement model.

[00:23:08] Guest: Giles Male: Exactly that. And actually, you know, for companies, it's not always 12 months. I think sometimes 12 months can feel a bit daunting. So sometimes with companies we say, look, we'll come in for six months with us. We'll give you a month by month sort of structured package to work through. We'll check in with you. We'll assess your team at the start. We'll kind of test you at the end. But yeah, it's pretty comprehensive. And we actually lean in really closely with the FMI. So I try and get as many of our members whilst they're doing our accreditation internally to then go for as much of FMI's accreditation program as well, because I just think it complements it so nicely.

[00:23:46] Host: Paul Barnhurst: All right. So another kind of question I want to get your thoughts on is right. Financial modeling is a skill that many people profess to have. Almost everybody that works in finance is like, yeah, I can build a financial model, but most models are poorly designed. And I've built many. I didn't start my career with any kind, of course. It was just, oh, hey, you start building stuff. No idea. You know, not using color coding. Probably used some hard codes from time to time. Ashamed to admit, you know, all those things we shouldn't do. So what skill level? What is really needed for somebody to become an advanced modeler? And when I say advanced, I always use that word loosely. It's like advanced Excel, but more of a competent modeler that can really design a model well and make sure it's usable to. To me, that's more of an advanced modeler than somebody that can build a really complex model. Is there able to make it simple and usable for the end user? What does that really take in your mind to kind of get to that level?

[00:24:46] Guest: Giles Male: Yeah, it's such a big topic area, and it's something that I've had a conversation with a few people about recently, because I think it's really hard to define what advanced or, you know, you could swap advanced out with expert. What does it mean to be an expert? And I know some of the things that I definitely don't think it is. And I see people kind of projecting themselves as experts because they have these skills. So, for example, I see lots of VBA experts who in one silo would consider themselves to be experts in VBA, but they don't have the awareness to know when VBA is appropriate versus Power Query or the data model, or maybe not even Excel at all. So I think it's probably a few things. Now I'm convinced you have to have a level of literacy or awareness about almost all of the Potential tools, for example, within our Microsoft environment that you could lean on. So I think part of the answer is knowing when to choose which tool for the right job. I think part of it you've just hit on, which is keeping things simple.

[00:25:54] Guest: Giles Male: And then part of it actually is the technical side of, you know, how do you build good models. And I think you a little bit like, , have you heard this thing? When you meet somebody, you decide whether you like them or not within seven seconds or something. I think you have the same thing with models. I think when you first open up a financial model, you know, within the first 10s, when you just see the tabs, you glance over a few tabs, you see the way it's structured, you know, straight away whether it's been built to a standard or not. It doesn't matter whether you follow fast or smart, you know, but you just know when there's been principles that have been followed versus not. My time as a consultant definitely drilled home the message that it is about being useful for the user if you build the most sophisticated tool in the world, but you've built it in a way that your end client doesn't know how to use or doesn't feel comfortable with, then I do kind of feel like you've missed the point slightly there.

[00:26:51] Host: Paul Barnhurst: FP&A guy here. And as you know, I am very passionate about financial modeling and the Financial Modeling Institute's mission. I have been a huge fan of the FMI for years, and I was super excited when they decided to sponsor the Financial Modelers Corner. I recently completed the Advanced Financial Modeler certification and love the entire experience. It was top notch from start to finish. I am a better modeler today for having completed the certification. I strongly believe every modeler needs to demonstrate they are a qualified financial modeler, and one of the best ways to do that is through the FMI program. Earning the accreditation will demonstrate to your current and future employers that you are serious about financial modeling. What are you waiting for? Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you enroll in an accreditation today. Agree. There's the balance of how do you make it usable for the end user. And I've definitely been one of those that's allowed my career to be on the too complex side. Okay. How do you simplify this? Now of course I've really been focusing on simplified. And then I got a client that wanted to use every single line of accounting and the account system to forecast that.

[00:28:21] Guest: Giles Male: Oh, wow. Okay. 

[00:28:25] Host: Paul Barnhurst: Are you kidding me? You know, there went the simple. It was quite complex.

[00:28:31] Guest: Giles Male: And that's a really interesting one because then, you know, in that situation you've got a real challenge on your hands because, you know, that's probably not the most appropriate way to do that. So part of your skill set is now nothing to do with the technical side. It's like communication skills, like, can you actually persuade this person not to do what they think is the right thing to do? So there's another whole side of this where I think there's soft skills that you must have to be more than just a spreadsheet geek, and then it probably makes a difference if you're if you're on a team of modelers in a company like opera or whoever, or one of the big accounting firms, you're, you know, being good at what you do is probably very different to if you are a consultant or like you run your own business as a consultant modeler. The skill sets are really different in those two sorts of categories as well.

[00:29:25] Host: Paul Barnhurst: Well, and then there's so many different types of models like I remember on LinkedIn, a friend of mine saying the number one skill every FP&A professional has to have is how to build a three statement model. And I responded with, I never built one for my career until two years ago when I went out as a consultant. Yeah, I was like, what? He had done all startups, right? I worked at American Express. American Express isn't building a bunch of three statement cash flows and, you know, three statement models and trying to roll those up. And so, like, for me, the AFM was a real challenge because I just hadn't done a lot of three statement modeling. And it was really good learning for me because I think it's just everybody has to understand the three statements. If you work in finance, I think understanding basic accounting and three statements should be table stakes. I don't think you have to build a three statement model depending on the work you're doing. And for big companies it's not needed. But you better understand how the three statements interact at a minimum. In my mind.

[00:30:18] Guest: Giles Male: I think that's absolutely right. Yeah. So I wrote about this a couple of years ago, actually saying I can't remember what the article was, but it was making the point that you don't have to be you don't have to work in an investment bank, and you don't have to be doing three statement models every day to be, in my eyes, a financial modeler. I do think most people, if you use the term financial model, probably do assume you're talking about a three statement model. I think that's fair, but I like the idea that we try and include as many talented people in the community as possible, and I'm sure there are hundreds of thousands, if not millions of people that do amazing modeling work in Excel, and they may never have had to build a full three statement model in their life.

[00:31:02] Host: Paul Barnhurst: I agree, there's the business, there's supply chain modeling. People are using good modeling principles and that understand modeling that aren't necessarily building a three statement. But I think I agree with you when you say financial model, that tends to make people think of the three statements. So it tends to be a skill you expect everybody to have.

[00:31:22] Guest: Giles Male: But then that to me that's just the first layer. Because then, you know, there are all sorts of three statement models. And even if you just broke it down into a one off transaction model versus an opera, a financial operational model. You know, there's so many variations.

[00:31:41] Host: Paul Barnhurst: Yeah.

[00:31:42] Host: Paul Barnhurst: It's like anything when you start digging into it. There's so many variations, like when you learn a sport, right? The different formations in soccer or football or basketball or whatever it may be, if you're really passionate about it, you start learning. You realize, oh, there's a ton here or even running. People don't realize. But I mean, you know, this, there's a lot of different strategies and tactics and, and ways you could run and things you can do. Are you running uphill, downhill? Are you long distance, short distance, on and on and on.

[00:32:11] Guest: Giles Male: Even periodicity. Right. For me, this is what I was thinking about the other day. You imagine if you've spent most of your career as a financial modeler, building annual models, working off the last three years of historic, you know, numbers so you could have an entire career building really amazing value, adding models like that. And you may never have built a rolling actuals plus forecast monthly model, which is a totally different build approach. You have to think about different levels of dynamic rolling nature for your model. Even though it's a completely different skill set and a different model type.

[00:32:50] Host: Paul Barnhurst: Yeah.

[00:32:50] Host: Paul Barnhurst: And 99% of my models have been the rolling monthly FP&A models. And sometimes you have 40 different departments and three legal entities. So you got 120 cost centers. You got to manage, and it's just huge. And so I used to always be like, well, models should just be horizontal because you're dealing with so many sheets. Then I built a basic three statement. I'm like, oh, vertical really does make sense. And so I've kind of come it's like, okay, it depends on what I'm building, what makes sense here. But I was always never understanding why so many people love vertical because I was doing so many. I'm not stacking 200 cost centers in one sheet. I want them on individual pages because there's already 100 accounts. And so it was really interesting to learn as you start seeing different types of modeling going, okay, now I get why somebody does it that way.

[00:33:35] Guest: Giles Male: And again.

[00:33:36] Guest: Giles Male: That's really important. Horizontal versus vertical I've typically modeled horizontally. But there's another mindset thing I think for modelers where you've got to be aware that the way you do things doesn't mean everybody else is wrong. Like if you open if you're a horizontal modeler and you open up a vertical model, you can't chastise the person for going vertical. It might be totally appropriate for what they do.

[00:33:57] Host: Paul Barnhurst: Totally agree. Really great point. Next question I want to ask you. Obviously, you know, the number one tool that people use globally for modeling is Excel. There's a lot of other tools out there and there are some great tools. And I think people can build great models with different tools. But in your mind, do you see it changing anytime soon? Any other tool, you know, maybe becoming dominant or do you see, at least for the foreseeable future, it's going to be Excel and then everybody else.

[00:34:25] Guest: Giles Male: Yeah.

[00:34:26] Guest: Giles Male: I mean, the only thing I would say is I think Google Sheets is making some huge strides, and I know there are lots of other players on the market. I think you've done some awesome work on this side of things. You know, the quanterix equals, , there are loads of others that are probably forgetting off the top of my head. I think it's great that they're putting Excel under pressure. I just think Excel has evolved so much. It is a different beast now to what it was two years ago. And I genuinely think that the only real competition is Google. And I had a stat recently that I think something like 60 to 70% of startups use Google Sheets over Excel, probably because it's free and the kind of collaboration side of things is better. But I thought that was very interesting. So no, I think Excel will certainly in my career lifetime be the dominant tool. But I think Google Sheets is doing some really cool stuff at the moment.

[00:35:25] Host: Paul Barnhurst: I agree with you. We just had someone who compared Google Sheets to Excel and talked about when he uses each and where Google is better. And it was a great conversation and learn a lot of things like Google's just added tables.

[00:35:37] Guest: Giles Male: They have and they're good.

[00:35:39] Host: Paul Barnhurst: Google has more functions that people like that are not in Excel than Excel has, that are not in Google as much as people use Google, there are some really unique like count unique. Why is that not in Excel? Why do I got to wrap it in a count and just create the formula. But that's a separate story. I digress. So you talk about how much Excel has changed the term I use and I know I've heard you use it is modern Excel. So talk a little bit about what's changed and maybe what do you think is next for Excel.

[00:36:13] Guest: Giles Male: To be modern Excel. When I talk about modern Excel, I'm predominantly thinking of array modeling. And linked to that certainly is a financial modeler. Dynamic array modeling means you're leaning on Lambda as well. For me, as a financial modeler, they really come as a package. I know there are other things, so I know we've got things like Python coming as well, and that definitely is a part of the modern version of Excel. But I think there will be a huge shift over to the use of modern Excel and in particular the use of dynamic arrays for financial modeling. And I think it's going to happen fast. I'm really convinced of this now, and I base that on what I'm seeing with lots of the companies we train where, interestingly, the youngest people in the teams, the least experienced, the fresh graduates are coming into the workforce. They're seeing and they're being trained on modern Excel, and they just get it instantly and they love it. But I'm also seeing that from more experienced people as well. Once you see dynamic array modeling in practice, I just think I genuinely think we will look back in five years, like cell referencing, and we'll be saying, why? Why the hell did we always do that? That's ancient.

[00:37:28] Host: Paul Barnhurst: I don't quite share your optimism for the five year window, just knowing how long Power Query and anything has taken to adopt Excel and the different versions that are out there. But I do think we're moving that way. I don't know how long it will be, but if I had to guess, I'm going to go 10 to 15. But we'll see.

[00:37:46] Guest: Giles Male: Well, you'll, you'll hate my actual number because I actually predicted two years. So you'll have to hold me to account on that. Paul, if in two years we're nowhere near.

[00:37:56] Host: Paul Barnhurst: You know, Chris Argent and Lance Rubin have had their battle about Excel and they had a bet going of when it would die. And I think Chris owes Lance a bourbon, and I think I told him I would be the delivery boy or something on that bet. It was like 15 years and this was, I don't know, probably three, four years ago around there would be another tool other than Excel. So we'll see where that ends. So I get it right. We're if any of us could forecast highly accurately, I like to say we'd be sitting on a beach somewhere enjoying a drink, because we would have made a fortune in the market. It's about good assumptions.

[00:38:34] Guest: Giles Male: It is. Do you know the only difference for me this time, I think, and I could be completely wrong, is that I think this transition is going to be led by the professionals. I think you are going to genuinely see that the financial modeling teams at the big four beyond, at the big, the big modeling companies, I think they're going to be the first to really transfer over to full dynamic array modeling and everything else. And I just think that's going to filter down. I mean, we 've had people on your podcast who are running consultancies. You had Cameron and Nick on, I remember, who are now running a business where all of their client modeling is dynamic array and lambda based, and I think that's fascinating to see that in place, adding real value already.

[00:39:26] Host: Paul Barnhurst: Yeah.

[00:39:27] Host: Paul Barnhurst: No. It's exciting. There's definitely some doing it. So it'll be fun to watch and we'll just kind of have to see how it all unfolds. But it's amazing at time to see these dynamic arrays, lambdas. Let's this whole idea of everything expands and contracts. And I totally agree with the younger generation. I'm teaching two 18 year old girls excel. I know their dad and he asked me to train them and I was explaining lookups and I showed them Vlookup and they're like, well, why would we ever index Vlookup or why would we ever use that? I'm like, the only reason I'm explaining it to you is you're going to run across it in your career, and I want you to understand when you open that file, what's going on? And they're like, okay, I go in general, you're probably going to use another function and that's totally fine. But just trust me, you're going to run into those situations where people are using them. So it's really interesting as I was explaining different things, I'm like, I'm only telling you this one here because you're going to run into it or this you're never going to. I would recommend you never use it like some if versus some ifs 

[00:40:26] Host: Paul Barnhurst: If you know some ifs, why would you use some if you're just forcing yourself to use two different formulas? Like just build the one and then it's you can add the second criteria every time. So it's really interesting getting that fresh perspective of somebody who hadn't used Excel that was younger, as you're training them.

[00:40:43] Guest: Giles Male: Well, and it might be a generational thing that the next generation coming through is just more familiar with coding. We do see more people now kind of coming out of college or uni, and they've actually seemingly had some quite good training in, in things like Python or whatever it might be SQL so where, where Excel, you know, shifted over to this, what I would call a more kind of coding, , comfort comfortable area for for modelers. I just think at the bottom end of the industry, if you think of it that way, you've got the younger generation that are coming in and just up. They get up to speed so quickly. I think you'll have the top end of the industry. With the professional teams pivoting over to this dynamic array, modeling So so that's for me. That's why I keep banging on about, you know, for for everyone in the middle, the average muddler group, you've got to get up to speed with modern Excel. You really do have to. Now.

[00:41:36] Host: Paul Barnhurst: It's going to be fun to watch. It's an exciting time for sure. It's . Yeah, amazing to watch it change. So we're coming close to our rapid fire section and wrapping up the interview. But I have a couple questions I want to ask before we jump into that first one. What's your favorite Excel shortcut?

[00:41:54] Guest: Giles Male: I've got a pair, so the one I use all the time is control S square bracket F5 enter just to jump, you know, back to a link and then back to where you started from.

[00:42:04] Host: Paul Barnhurst: That is the same combination Chris Riley just gave me the other day.

[00:42:09] Host: Paul Barnhurst: You and him are on the same page, only two and I don't know, 40 interviews now that have given that combo.

[00:42:13] Guest: Giles Male: Nice.

[00:42:14] Host: Paul Barnhurst: Yeah, I know it's one many modelers love, especially when you're trying to flip back and forth. And then what is the one lesson you've learned over your career that has helped you maybe saved you the most time, or helped you the most.

[00:42:27] Guest: Giles Male: The one that jumps to mind. I was going to say something that I've kind of already said in this conversation. So the one that jumps to mind is just the importance of reviewing work, having your models reviewed ideally not by yourself. But if you do have to review your own work, you have to take a break because there's this visibility fog that I'm sure you're aware of. When you just see what you think you've built. And you. It's amazing what happens when you step away from your own modeling work and maybe get a good night's sleep and come back and you look at it again with a fresh pair of eyes with a tool, for example, like oak, I use oak from operas all the time. So. So yeah, there are a number of answers I could have given you there, but I think the importance of reviewing your own work in a very tactical way is, it is a big one.

[00:43:18] Host: Paul Barnhurst: Yeah, I think it was.

[00:43:20] Host: Paul Barnhurst: It was Nicholas or Cameron. I can't remember which one. Of the hay brothers. One of them was like, always sleep on it and look at your work the next morning. Yeah, kind of that step away because you get so involved, you don't see things that a break will allow you to see. I think that's a great lesson. All right, rapid fire. We're going to run through these quick. I know you've done it before. And so if anyone's listening they can go back and listen I don't know episode 15 and see if you answer anything differently. But you can't say it depends. You just got to pick one or the other. We'll run through them all really quick. And then you can elaborate on 1 or 2, because I know there is nuance in all of these. Yeah. Circular or no circular references.

[00:44:00] Guest: Giles Male: No circular.

[00:44:01] Host: Paul Barnhurst: VBA or no VBA.

[00:44:04] Guest: Giles Male: No VBA. 

[00:44:06] Host: Paul Barnhurst: Horizontal or vertical.

[00:44:08] Guest: Giles Male: Horizontal. 

[00:44:10] Host: Paul Barnhurst: Dynamic arrays. Yes or no.

[00:44:12] Guest: Giles Male: 100%. Yes.

[00:44:13] Host: Paul Barnhurst: I knew where that one was going. External links. Yes or no.

[00:44:17] Guest: Giles Male: No. 

[00:44:18] Host: Paul Barnhurst: Named ranges. Yes or no.

[00:44:20] Guest: Giles Male: Yes. 

[00:44:22] Host: Paul Barnhurst: Follow formal standards for your modeling, like fast or smart, or some of the others that are out there.

[00:44:28] Guest: Giles Male: Yes.

[00:44:29] Host: Paul Barnhurst: All right. Will excel ever die?

[00:44:32] Guest: Giles Male: I remember my answer to this last time. I'll say it more seriously this time. I don't think so in my lifetime.

[00:44:40] Host: Paul Barnhurst: Fair enough. Will AI build the models for us in the future?

[00:44:44] Guest: Giles Male: Yes.

[00:44:46] Host: Paul Barnhurst: All righty. Should we use sheet cell protection in the models? Yes or no.

[00:44:51] Guest: Giles Male: Yes.

[00:44:53] Host: Paul Barnhurst: I had some of the other day tell me they preferred very hidden VBA. Okay. Do you believe financial models are the number one corporate decision making tool?

[00:45:04] Guest: Giles Male: I remember my answer to this last time as well, so I'll try and again give a slightly different answer. Yeah I do. As the technical tool. Tool. Yes.

[00:45:13] Host: Paul Barnhurst: And then what's your favorite lookup function? You would choose Vlookup index match Xlookup or something else.

[00:45:22] Guest: Giles Male: I am now a full convert to Xlookup. I was index match.

[00:45:29] Host: Paul Barnhurst: I'm a big Xlookup fan as well. All right. Is there any of those you want to elaborate on? Add a little more nuance to your answer?

[00:45:36] Guest: Giles Male: Yeah, maybe. Standard. So, you know, I've had the benefit of talking to lots of people in the industry, you know, globally in the last couple of years who I kind of, you know, I listen to them, I get to have these conversations and I hopefully absorb as much as I can. And the general sense that I've got from this is like, this is a really revolutionary time. I think, for us as modelers. And there are some fundamentals, like following a standard for me is a given, but there's also just a bit of reality to that. Like, yeah, look, I generally follow fast, but if somebody's not following every, you know, principle in fast to the letter, am I going to lose sleep over it. Probably not, because I think there's more important things for us to be talking about at the moment. So this came from a conversation I had with Richard Warner in Australia. He was just like, yeah, look, we're all trying to build good models. I don't think anybody's setting out to deliberately build confusing and complex models. So, standards are great. I think lots of companies have their own sort of slightly tweaked in-house standards. Definitely follow one rather than not. And then don't lose too much sleep over the finer details. Let's focus on the bigger topic, like what's happening with modern Excel in the future.

[00:46:56] Host: Paul Barnhurst: I like it, and you know, where I kind of sit on is follow general good principles, have structure and design some of those general industry standards. Beyond that, it comes down to opinion. And if it works within your company, you're keeping things simpler. You're using good practices. To me, that's enough. I'm not one to like you said, I'm not one of those that like, hey, you got to follow that t you didn't follow page seven of this guide. As long as your model works, it makes sense and it's well structured. I'm okay.

[00:47:27] Guest: Giles Male: I completely agree. There is a materiality thing. You've got to be ready to make judgment calls. Assess your situation. As we said earlier, if you work on a team of modelers, you probably do have to be a little bit more restricted and in line. But, you know, there are bigger conversations to be had, I think, at the moment.

[00:47:46] Host: Paul Barnhurst: I agree with you. I think that's a good spot to wrap up on. Enjoyed you joining me here. I had a great conversation. Last question I want to ask if someone wants to learn more about you or get in touch, what's the best way for them to do that?

[00:48:00] Guest: Giles Male: To get in touch.

[00:48:00] Guest: Giles Male: Just find me on LinkedIn. I'd really appreciate any support for my little YouTube project Excel on the road. It is me at the moment, really just going around talking to experts around the world, and I'm very passionate about it. But yeah, if you want to get in touch, just connect with me on LinkedIn. Very, very happy to talk to people about modeling.

[00:48:19] Host: Paul Barnhurst: And we'll close with. There will be an Excel on the road from Vegas. We'll call it our Vegas road trip with, there will be Giles and I. So we're going to be planning that here for December with the Financial Modeling World Cup. So I figure that's a good place to leave it on. Thank you for joining me today. I've really enjoyed chatting with you.

[00:48:36] Guest: Giles Male: Thanks a lot, Paul. Appreciate it.

[00:48:40] Host: Paul Barnhurst: Financial Modelers Corner was brought to you by the Financial Modeling Institute. This year I completed the Advanced Financial Modeler certification and it made me a better financial modeling. What are you waiting for? Visit FMI at www.fminstitute.com/podcast and use code Podcast to save 15% when you enroll in one of the accreditations today.