
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
Top Rated News
- Sean Archer
- AwTeaches
- Learn Squared
- PhotoWhoa
- Houdini-Course
- Photigy
- August Dering Photography
- StudioGuti
- Creatoom
- Creature Art Teacher
- Creator Foundry
- Patreon Collections
- Udemy - Turkce
- BigFilms
- Jerry Ghionis
- ACIDBITE
- BigMediumSmall
- Boom Library
- Globe Plants
- Unleashed Education
- The School of Photography
- Visual Education
- LeartesStudios - Cosmos
- All Veer Fancy Collection!
- All OJO Images
- All ZZVe Vectors