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

Cash Flows Dashboard

The Cash Flows Dashboard tracks your company’s cash inflows and outflows, offering insights into liquidity and cash management...

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...