Tag: EXCEL

Excel for Finance Building a Three-Statement Operating Model


Free Download Excel for Finance Building a Three-Statement Operating Model
Released 10/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Advanced | Genre: eLearning | Language: English + srt | Duration: 4h 59m | Size: 1.11 GB
A three-statement operating model incorporates your company’s income statement, balance sheet, and cash flow statement to provide an integrated and complete view of your organization’s financial health. Follow along with Chris Reilly, financial modeling expert and experienced Excel trainer, as he shows you how to build a three-statement model in Excel. Chris explains how to clean up source data, build the cash flow statement, build EBITDA, and forecast the income statement, balance sheet, debt schedule, and more.

(more…)

Data Analytics for Pricing Analysts in Excel


Free Download Data Analytics for Pricing Analysts in Excel
Released 10/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Advanced | Genre: eLearning | Language: English + srt | Duration: 2h 4m | Size: 296 MB
Discover how to make smarter product pricing decisions that maximize your organization’s profits. In this course, instructor Michael McDonald goes over using scenario analysis, price optimization, and variance analysis to model the data analytics behind pricing . Michael explains how to determine bundle pricing in a scenario, estimate price elasticity, compute price optimization profits with one variable or many variables, balance price and sales volume considerations, and more. If you’d like to pursue a career in corporate finance-particularly as a pricing analyst in an insurance, retail, manufacturing, or technology firm-then this course can help equip you with the skills you need to help your company succeed in today’s economy.

(more…)

Coursera – Everyday Excel Specialization


Free Download Coursera – Everyday Excel Specialization
Last updated 10/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 174 Lessons ( 17h 23m ) | Size: 2.61 GB
Learn Excel From Scratch to Expert. Starting from zero knowledge of Excel, you’ll learn basic spreadsheet skills and apply them in to several exciting projects in the capstone "Projects" course.

(more…)