Practical Spreadsheet Solutions | Poke

Practical Spreadsheet Solutions @[email protected]

985 subscribers - no pronouns :c

Inspiring you to combine technical skills with creative thin

Videos Shorts Posts Playlists

Recently Uploaded Popular Oldest

Fiscal year-to-date total in a PivotTable? No problem! Here are two ways to calculate it

Create engaging visuals from text in just seconds with this free AI

This is BETTER than a PivotTable! Power Pivot vs. PivotTable in Microsoft Excel

Lock cells to prevent data entry in more than one column using data validation in Microsoft Excel

Replace boring bullet points in your next presentation with this in Microsoft 365 PowerPoint

How to remove old redundant items from pivot table slicers in Microsoft Excel

New trick to connect any chart to a PivotTable + awesome dynamic sunburst chart in Microsoft 365

No more complex formulas that others just can't read - use function LET in Microsoft 365

Using table slicers with spilling formulas to make an engaging interactive chart in Microsoft 365

Make an awesome interactive chart displaying aggregated numbers easily in Microsoft 365

A feature that you absolutely need to know to make EASY dynamic charts in Microsoft 365

Use table slicers to their full potential with the SUBTOTAL function in Microsoft Excel

How to make an EASY color-changing rating chart in Microsoft Excel, no Visual Basic for Applications

How to add the pivot table grand total to a dynamic chart using as example a chart for NPS®

Calculation and an interactive chart for Net Promoter Score® survey results in Microsoft Excel

Trick to connect any chart to a pivot table + an awesome dynamic sunburst chart in Microsoft Excel

Making an interactive tornado (butterfly or pyramid) chart using one pivot table in Microsoft Excel

How to add currency symbols to cells, chart elements, formulas, and pivot tables in Microsoft Excel

Colorful dynamic custom data labels made easy in Microsoft Excel

Automate the bar of pie chart in Microsoft Excel: answering your questions

Automate the bar of pie chart and control it with a slicer for custom drilldown in Microsoft Excel

Stay on track of project deadlines by setting a self-updating reminder in Microsoft Excel

Automate the pie of pie chart and control it with a pivot table to drill down any slice in MS Excel

Declutter a line chart by choosing shown product from a drop-down list (OFFSET or INDEX functions)

Charting a Dynamic Year-to-Date Period Using the INDEX Function in Microsoft Excel (Part 2 of 2)

Charting a Dynamic Year-to-Date Period Using the OFFSET Function in Microsoft Excel (Part 1 of 2)

Excel Chart with Rolling 6 Months, 12 Months, or User-Defined End Date using Dynamic Named Ranges

Rotating Pie Chart in Microsoft Excel with Visual Basic for Applications

Highlight chart points with a click in a filtered Excel table to explain your key messages - Part 2

Highlight chart points with a click in an Excel table to explain key messages in your report- Part 1