Excel for Financial Analysis Beyond Basic Formulas
Date:
Thursday
October 2, 2025
Time:
10:00 AM PDT | 01:00 PM EDT
Duration: 60 Minutes
Instructor: Ray Evans
Webinar Id: 804800
Overview:
Financial professionals know that data is only as valuable as your ability to analyze it.
In this dynamic webinar, Excel expert Ray will guide you through 8 essential functions that separate basic spreadsheet users from true financial modeling experts. Whether you're projecting future values, analyzing conditional data, or looking up critical information, these tools will become your new secret weapons.
You'll Learn How To:
- Master time calculations with DATEDIF (Excel's hidden date difference gem)
- Project investment growth accurately using FV (Future Value)
- Apply smart conditional analysis with AVERAGEIF, COUNTIF & COUNTIFS
- Build decision-making logic into your sheets with the versatile IF function
- Find data instantly using both VLOOKUP & HLOOKUP (and when to use each)
Why should you Attend: Why This Matters for Finance Professionals:
- Move beyond basic spreadsheets to true analytical tools
- Reduce manual work in financial reporting and forecasting
- Make more confident decisions with accurate, automated calculations
- Impress stakeholders with professional, dynamic financial models
Ray's webinars replicate the in-person classroom experience and include a professional Learning Guide with practical hands-on exercise files, providing a superior learning and knowledge retention experience for attendees.
- Harness the full potential of your software investment
- Time-Efficient Power Learning with Focused Topics
- Practical Hands-On Skill Enhancement with High Retention
- Supporting Resources, Learning Guide and Practice Files
- Improved Productivity, Quality and Error Minimisation
- Up-to-Date Current Knowledge Transfer
- Professional Development Recognised for Career Advancement
- Interactive Experience Through Chat and Live Interaction
- Rapid Return on Investment
Areas Covered in the Session:
- FV - Future value
- IF - Returns one value if TRUE, another if FALSE
- AVERAGEIF - Average with condition
- COUNTIF - Counts cells matching a condition
- COUNTIFS - Counts cells matching multiple conditions
- DATEDIF - Returns difference between dates
- HLOOKUP - Horizontal lookup
- VLOOKUP - Vertical lookup
Who Will Benefit:
- Anyone using Artificial Intelligence and Microsoft Office from fields including Government, Business, Education, Accounting, Banking, Finance, Investment, Bookkeeping, Consulting, Tourism, Hospitality etc
Speaker Profile
Ray Evans professional and relaxed style reflects his thorough understanding of adult learning principles and is demonstrated through his diverse range of classroom, seminar, workshop and online delivery services and instructional materials.
With Microsoft Certifications, he has mastered over 2500 topics to advanced level in Artificial Intelligence, ChatGPT, DeepSeek, Excel, Access, Outlook, Project, PowerPoint, Word, Visio and Publisher.
Ray has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.
Having trained over 40,000 students, business owners and executives since 1990 and authored a wide range of training and procedural documentation, complex reports and engaging internet content, Ray has demonstrated strong ability in key communication styles and knowledge transfer.
With Microsoft Certifications, he has mastered over 2500 topics to advanced level in Artificial Intelligence, ChatGPT, DeepSeek, Excel, Access, Outlook, Project, PowerPoint, Word, Visio and Publisher.
Ray has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.
Having trained over 40,000 students, business owners and executives since 1990 and authored a wide range of training and procedural documentation, complex reports and engaging internet content, Ray has demonstrated strong ability in key communication styles and knowledge transfer.