Power Query Sheet

This worksheet helps you see the before and after that take place when data is transformed with power query.

Instructions

Color coding

Items in blue - inputs (editable)

Items in black - calculations (do not edit)

Items in purple - referencing another cell (do not edit)

Update information in cells C2:D7

Hit Data > Refresh all to see the numbers change in columns G:I

To review the queries, hit Data > Queries & Connections, and double click Profit_and_Loss query.

More Templates

Excel Proposal

This template is a structured spreadsheet designed to outline project details, objectives, timelines, costs, and deliverables...

Every Excel Chart

This template is a comprehensive showcase of all chart types, designed for education and reference. Each chart is paired with example data...

CFO Report

This template outlines key financial metrics, including revenue, expenses, profitability, and cash flow. It includes sections for financial performance analysis...

Balance Sheet workpapers

This template is a detailed tool for preparing and reconciling balance sheet accounts. It includes structured schedules, formulas...