Udemy - Excel Magic 8 - Transforming a Pro-forma into a Dashboard
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 24 lectures (58m) | Size: 451.5 MB
Learn how to transform a pro-forma into a dashboard!
What you'll learn:
Intermediate to Advanced Excel skills that will help you
- to ace your Excel skills,
- to make yourself the go-to-person in their office, or
- to be well positioned for your next promotion!
Requirements
Basic Excel
Example: be able to open one Excel file, etc.
Power Query
Description
The course is presented in three parts.
First, the course reveals the 3 shortcomings of presenting a pro-forma report. They are:
o Hard to slice and dice
o Hard to build a collapsible table on timeline
o Not for self-service
Next, the course presents 3 challenges in building a Pro-Forma report and provide solutions for the challenges. They include:
o How to Track On-hire Days for Each Vessel?
o How to Track Daily Hire Rates for Each Vessel?
o How to Calculate Net Hire Revenues?
Last, the course presents another 3 challenges in building a Dashboard report and provide solutions for the challenges. They include:
o How to convert Pro-forma report to a Dashboard report?
o How to build the Slice-and-dice function of a dashboard?
o How to display budgets, actuals and off-hires all in one chart?
Course Search Keywords
- Pro-Forma report
- Dashboard report
- Power Query
- Unpivot
- Reference
- Merge queries
- Slicer
- Timeline
- PivotChart
- Combo Chart
- Secondary Axis
Learning Objectives:
● Understand when and how to build a pro-forma report or a dashboard report
● Master the "golden" formulas to track days based on start/end dates and this/next periods
● Discover the way to model "staggered" daily rates and summarize into one table
● Recognize how to convert a cross-table to a flat-table
● Understand how to build a self-service dashboard that enables slice-and-dice
Who this course is for
Office workers, Professionals, and Managers
Homepage
https://www.udemy.com/course/excel-magic-8-transforming-a-pro-forma-into-a-dashboard/
Buy Premium From My Links To Get Resumable Support,Max Speed & Support Me
https://uploadgig.com/file/download/0549fedc3cC7c93F/zxi2d.Excel.Magic.8..Transforming.a.Proforma.into.a.Dashboard.rar
https://rapidgator.net/file/e09eba651651f5118a7962bd0ad9ae8d/zxi2d.Excel.Magic.8..Transforming.a.Proforma.into.a.Dashboard.rar.html
http://nitroflare.com/view/11FB0FCB3408521/zxi2d.Excel.Magic.8..Transforming.a.Proforma.into.a.Dashboard.rar
Links are Interchangeable - No Password - Single Extraction
Comments (0)
Users of Guests are not allowed to comment this publication.