Almost every part of your financial life involves present values and perpetuity calculations. From your monthly mortgage payment to your credit card balance to your student loans, all of your financial obligations are somehow connected to the imaginative idea of a perpetuity - at least, in terms of valuing that
Incorporate a unit testing framework into your Power BI reports with some simple measures combined with a matrix visualization.
Consolidate data from multiple tables within Excel into one table using PowerQuery, a basic function, and a parameters table in under 7 minutes.
PowerQuery custom data types offer promise of bold and powerful new features in the future; however, their current implementation is currently limited to simple, non-hierarchical data.
Unit testing in R is straight-forward and easy so long as you remember to appropriately dive into your lists!
Explainly offers bespoke cloud-based technology solutions for your specific business needs.
Explainly builds a share-able basic project management data capture and reporting system in 7 minutes. Learn how to build the report yourself and then interact with and add your own project data.
Microsoft's PowerApps makes web app development as easy as writing Excel formulas while dragging and dropping the pieces across a canvas.
Our author Philip takes a year's worth of electricity usage data and builds a Power BI report to compare and contrast different electricity price contracts and gain some insight into his usage.
Explainly offers corporate training through self-paced online courses in addition to designing custom training curriculums for your business, led by experts.
This QuickTip offers a quick use-case for PowerQuery's Merge command to connect data together in order to locate potential missing pieces.
Introductory course receiving light updates for Excel 2019 plus all new audio tracks.