top of page

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)


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

Financial Health Dashboard
Financial Health Dashboard

This dashboard showcases your financial and cash metrics, indicating how good your business is doing

Cash Flows Dashboard
Cash Flows Dashboard

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

Excel Proposal
Excel Proposal

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

Every Excel Chart
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...

bottom of page