Name: Excel for Finance
Rating: 3.8125 (16 reviews)

What you will learn

Why Power Query and Power Pivot in Excel

Connecting to External Data Sources (Basics of Power Query)

Transforming Raw Data, or the Magic of Power Query

Data Models and Power Pivot: One-to-Many, Many-to-Many Relationships

Basics of DAX

Connecting to Google Sheets and Web Resources

Course content

This advanced course will guide you from preparing raw data for analysis to building an automated dashboard. You will learn how to calculate the Profits & Losses for a small business, "The Ar…

Prepare to discover the fundamentals of Power Query, including navigating the Get Data tab, establishing connections with databases and Excel workbooks, and effectively merging queries to streamline your data processing tasks.

You will dive deeper into Power Query's capabilities by connecting and integrating data from CSV files and folders. This section will guide you through adding custom columns, merging data sources, handling errors gracefully, and efficiently grouping and unpivoting columns to prepare data for advanced analysis.

The section covers advanced data preparation, relationship building, and calculation methods using Power Pivot.

Delve into creating a highly automated and interactive dashboard from start to finish. We explore advanced features such as pivot charts, KPI integration, and slicers to enhance functionality and user interaction.

Discover advanced functions to create an interactive and automated report for calculating key financial metrics on a monthly basis.

Boost your Tech Skills!

with up to 55% off

What you'll get with our subscription:

200+ Top-Rated coursesCompletion certificatesCutting-edge AI CopilotPersonalized study tracks30+ hands-on real-world projects

Your subscription also includes 200+ courses:

Excel for Beginners

Dive into the world of Excel with this comprehensive video course, designed to take you from basic navigation to mastering functions and basic data analysis. Starting with foundational skills like data entry and cell formatting, you'll quickly progress to using powerful tools. Whether you're organizing large datasets, performing statistical analysis, or creating dynamic charts, this course equips you with the practical skills needed in today’s data-driven environment.

Excel Formulas

Unlock the full potential of Excel by learning how to use formulas and functions to simplify tasks, analyze data, and work more efficiently. You'll explore everything from basic arithmetic and conditional logic to dynamic arrays and powerful lookup tools like VLOOKUP, MATCH, and INDIRECT. With practical examples and clear explanations, you'll build a solid foundation and discover smarter ways to manage and manipulate your spreadsheets.

Data Analysis with Excel

Data Analysis with Excel provides a practical guide to mastering the most essential data management, manipulation, and analysis techniques using Microsoft Excel. You'll gain proficiency in Excel's powerful capabilities, progressing through data analysis methods, and creating dynamic visualizations and interactive dashboards. By the end, you'll learn to automate reporting and apply advanced analytics, equipping you to make informed, data-driven decisions efficiently.

Mastering Discounted Cash Flow Analysis with Excel

Learn how to confidently value a business using Discounted Cash Flow (DCF) modeling. This practical course walks you through the entire valuation process—from understanding key financial concepts to building a complete DCF model in Excel. You'll explore core topics like free cash flows, discount rates, cost of equity, WACC, terminal value, and scenario analysis. With step-by-step examples, downloadable templates, and a real-world case study, you'll gain hands-on experience applying DCF in professional settings. Whether you're an aspiring analyst, investor, or business owner, this course gives you the tools to calculate intrinsic value and make informed financial decisions.

Excel for Beginners

Dive into the world of Excel with this comprehensive video course, designed to take you from basic navigation to mastering functions and basic data analysis. Starting with foundational skills like data entry and cell formatting, you'll quickly progress to using powerful tools. Whether you're organizing large datasets, performing statistical analysis, or creating dynamic charts, this course equips you with the practical skills needed in today’s data-driven environment.

Excel Formulas

Unlock the full potential of Excel by learning how to use formulas and functions to simplify tasks, analyze data, and work more efficiently. You'll explore everything from basic arithmetic and conditional logic to dynamic arrays and powerful lookup tools like VLOOKUP, MATCH, and INDIRECT. With practical examples and clear explanations, you'll build a solid foundation and discover smarter ways to manage and manipulate your spreadsheets.

Data Analysis with Excel

Data Analysis with Excel provides a practical guide to mastering the most essential data management, manipulation, and analysis techniques using Microsoft Excel. You'll gain proficiency in Excel's powerful capabilities, progressing through data analysis methods, and creating dynamic visualizations and interactive dashboards. By the end, you'll learn to automate reporting and apply advanced analytics, equipping you to make informed, data-driven decisions efficiently.

Mastering Discounted Cash Flow Analysis with Excel

Learn how to confidently value a business using Discounted Cash Flow (DCF) modeling. This practical course walks you through the entire valuation process—from understanding key financial concepts to building a complete DCF model in Excel. You'll explore core topics like free cash flows, discount rates, cost of equity, WACC, terminal value, and scenario analysis. With step-by-step examples, downloadable templates, and a real-world case study, you'll gain hands-on experience applying DCF in professional settings. Whether you're an aspiring analyst, investor, or business owner, this course gives you the tools to calculate intrinsic value and make informed financial decisions.

Why People Choose Codefinity

Web Developer

Kwizera Mugisha

The teaching methodology at Codefinity is excellent, and I particularly appreciate how it has prepared me to handle real-world coding problems. Currently, I am delving into Node.js and eagerly anticipate building full-stack projects that integrate all the knowledge I have gained.

Senior Business Analyst

Sherry Barnes-Fox

My first course was 4 hours, I did it in a few days, "nugget-style". The instructions are very clear and easy to understand. There is even a hint to help you get the answer. I love the learning style that is used, it engages me.

Accounts Payable Specialist

Bill Wagner

I have really liked the browser-based lessons that allow me to code within the lesson. The RUN button allows me to test the code I write before submitting for a grade.

IT Support Specialist

Daniel Chinea

I have gained a lot of practical and logical thinking skills, along with patience for myself and confidence in myself that I can learn programming. Years ago, I would have never thought that I could learn programming in any way, shape or form, and I was able to obtain these certifications and skills with Codefinity.

Technology Project Manager

Steve Bruening

The learning was progressive and made it easy to follow along and make progress. I could feel my skills increasing and building on each other as the course went along.

Project Manager

Stephanie Chan

As I went through the first course of the Python track, I liked the way the course was lay out (in easy and digestible modules) with little exercises at the end of each concept.

Step-by-Step to Stellar Results

Solve Real‑World Coding Tasks

Interactive coding environment

Jump into our interactive environment: write and run your code with real‑time feedback and success metrics—learn by doing at every step.

Get On‑Demand Guidance

AI‑powered support

Leverage the built‑in AI assistant to explain errors, suggest fixes, or answer any question about your code—so you stay productive and never get stuck.

Lock In Your Learning

Knowledge check

Wrap up each module with a quick quiz that delivers instant feedback, tracks your progress, and ensures you’ve mastered key concepts.

Show Off Your Skills

Celebrate success

Earn your industry‑recognized certificate upon completion and share it on LinkedIn with one click—let your network see what you can do.

Full catalog access

One subscription opens up this course and our entire catalog of projects and skills.

Features:

200+ Top-Rated coursesCutting-edge AI Copilot

Personalized study tracks30+ hands-on real-world projects

Without cancellation, before the selected discounted intro plan ends, I accept that Codefinity will automatically charge $79 every 3 months until I cancel. Learn more about cancellation and refund policy in Subscription Terms.

Try Codefinity with confidence – 30-day money-back guarantee included

To welcome you to Codefinity, we're offering up to 64% off on our courses. Plus, we have a 30-day money-back guarantee, so you can try us out risk-free.We truly look forward to welcoming you to our platform and are committed to making your learning experience easy, interactive, and fun.

Frequently Asked Questions

How do I get access to the platform?

While you can study with Codefinity on any device, we strongly recommend using a computer or laptop to optimize your learning experience.

What if I have questions while learning?

All our courses feature an integrated AI assistant, ready to assist you with any questions you may have during your studies and help you solve any problems.

Is a tech degree necessary for learning?

No, you don't need any previous experience to start learning. Our courses are designed for beginners, so you can easily start your journey in the tech industry

Still have questions?

Write your question here

Excel for Finance

Course for Intermediate Level

What you will learn

Course content

Your subscription also includes 200+ courses:

Why People Choose Codefinity

Step-by-Step to Stellar Results

Trusted by Employees of Leading Companies
and Students from Top Universities

Instantly access 200+ courses

Full catalog access

Try Codefinity with confidence – 30-day money-back guarantee included

Frequently Asked Questions

Still have questions?

Excel for Finance

Course for Intermediate Level

What you will learn

Course content

Your subscription also includes 200+ courses:

Why People Choose Codefinity

Step-by-Step to Stellar Results

Trusted by Employees of Leading Companies and Students from Top Universities

Instantly access 200+ courses

Full catalog access

Try Codefinity with confidence – 30-day money-back guarantee included

Frequently Asked Questions

Still have questions?

Trusted by Employees of Leading Companies
and Students from Top Universities