Bojan Radojicic on LinkedIn: Top excel functions for financial modelers. But, remember!! 𝗘𝘅𝗰𝗲𝗹… | 18 comments (2024)

Soufyan Hamid

I train Finance Teams at Soft Skills | Corporate Training Facilitator | Course Instructor | Keynote Speaker

2w

I remember when I used to sweat to calculate the previous month end date with 10+ IFs. Now with EOMONTH, this isn't a problem anymore

Simon Thompson

I help engineers fast-track their transition from manager to senior leadership roles when tasked with setting up & overseeing contracts valued from $5M to $5B. My clients deliver outcomes that impress executives & boards

2w

Great list, Bojan! 👏 It's like having a Swiss Army knife for finance pros. But let's not forget, it's not just about the tools but how we use them. Like, 'IFERROR' can be a lifesaver for clean reports, yet it also teaches us to anticipate and manage errors proactively. And those lessons? Sounds like a goldmine for upping our game 🚀 Let's keep pushing to not just work with data but to tell its story in a way that moves mountains (or at least budgets 😄). Who else has found an unexpected gem among these functions?

Hong Lem

I Help Employees Make Money in Stocks Without Quitting Their Jobs.

2w

My Paretto to be competent in most scenarios:1. SUM2. SUMIF3. VLOOKUP4. AVERAGE5. MATCH6. INDEX&MATCH -> Dominate this and you'll be good in life 😄

Jeetain Kumar, FMVA®, FPWM™

CFA® L-1 Candidate || Certified FMVA® || Certified CBCA® || FPWM™ Professional || ESG & Macabacus Specialist ||MBA in Core Finance & Financial Consulting (KPMG) || Graduated in Aerospace Engineering

2w

Excel formulas and functions streamline data analysis. SUM adds values, VLOOKUP retrieves data, IF evaluates conditions, and CONCATENATE joins text. INDEX/MATCH locates data precisely, while COUNT counts occurrences. PivotTables summarize data dynamically.

Andrew Lokenauth

I write TheFinanceNewsletter.com for 50,000 subscribers • Follow for posts on Finance, Tech & Career Advice • Words in WSJ, CNBC, CNN

2w

You're so right - Excel is just a tool, not the whole job. The most important part of financial modeling is the strategy and insights. Excel can help showcase your ideas, but the real value is in the thinking behind it.

Cashflow Chronicles

Business Trends and Analysis with a Focus on Founders and Startups. 🇨🇦🇺🇸

2w

Solid list of essential Excel functions for financial modeling.Excel is a powerful tool when used strategically. If you're looking to upskill, the comprehensive course you mentioned seems like a valuable resource.

Mauricio Martinez

Head of Finance | FMVA® | CBCA®

2w

If I have to rank them I would say index&match is one of the most powerful functions in Excel, but as a matter of fact nested functions are useful and powerful in general, for example the OFFSET combined with MATCH function for dynamic calculations.

Hiro Wa

UX Designer at Insulet Corporation

2w

Excel functions are a game-changer for financial modeling, great choices! 💼

Albert Ramos Jr.

🤖 CFO: I help scale financial operations

2w

These are all super helpful

Dr. Pranay Singh

Insurance Consultant at Bajaj Allianz Life |Aspiring Dentist and Tactical CIA Field Agent| Cybersecurity Learner

2w

Very useful important and analytical content 👌 👏 👍