You've successfully subscribed to Explainly
Great! Next, complete checkout for full access to Explainly
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.
Philip Trick

Philip Trick

Philip is a practicing property and casualty actuary as an associate of the Casualty Actuarial Society. He attended Boston University and graduated Cum Laude with a MA in Economics.

Philip Trick
Members Public

Quick Tip: Build a Project Management Report

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.
Philip Trick
Members Public

Introducing Microsoft's PowerApps

Microsoft's PowerApps makes web app development as easy as writing Excel formulas while dragging and dropping the pieces across a canvas.
Philip Trick
Members Public

Power BI versus Excel, Dashboarding

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.
Philip Trick
Members Public

Corporate Training

Explainly offers corporate training through self-paced online courses in addition to designing custom training curriculums for your business, led by experts.
Philip Trick
Members Public

Quick Tip: Find The Missing (Data) Links

This QuickTip offers a quick use-case for PowerQuery's Merge command to connect data together in order to locate potential missing pieces.
Philip Trick
Members Public

Introduction to PowerQuery Updates

Introductory course receiving light updates for Excel 2019 plus all new audio tracks.
Philip Trick
Members Public

Advanced Get and Transform, Chapter 4 Complete

The final three lessons for chapter four have been published to the Advanced Get & Transform course, which can be found here. These lessons cover: 1) Tips and Tricks for working with Lists 2) The List.Accumulate Function 3) The Blackjack Challenge Solution With the publishing of these lessons, the
Philip Trick
Members Public

Quick Tip: Web Scraping with Excel

This Explainly Quick Tip guides you through a quick way to scrape data off of certain websites.
Philip Trick
Members Public

Quick Tip: Automating Tasks With Microsoft Flow

Learn how to create your first Microsoft Flow automation process following this YouTube -> Twitter automation example.
Philip Trick
Members Public

Advanced Get and Transform, Chapter 4 Now Live!

Chapter 4 of the Advanced Get and Transform course is now live on Udemy.
Philip Trick
Members Public

Quick Tip: Use Bing Maps for Simple Geographical Data

This three minute video will show you how to use Bing Maps in Excel to build simple, interactive map visuals.
Philip Trick
Members Public

The New(er) Explainly Blog

We're updating our site to fit with our new mission as we expand our course offerings, our informational tips, and extend into direct training and consulting.