Practical Spreadsheet Solutions
Inspiring you to combine technical skills with creative thinking for engaging reports that will get you noticed. As a data analysis and business insights professional I am sharing my favorite techniques in Microsoft Excel and PowerPoint.Visualizing data in an engaging and insightful way is key to achieving intensive usage of the reports by their recipients. A clever data arrangement helps users to draw correct conclusions from it. Automation and dynamic reports ensure low maintenance effort - create once, use many times!
I strongly believe in learning by doing. In the videos every step will be explained.
Let your spreadsheet data come to life and tell a story!
Nino K.
- 12:26
- Ай бұрын
New trick to connect any chart to a pivot table + awesome dynamic sunburst chart in Microsoft 365
- 9:50
- 2 ай бұрын
No more complex formulas that others just can't read - use function LET in Microsoft 365
- 19:49
- 3 ай бұрын
Using table slicers with spilling formulas to make an engaging interactive chart in Microsoft 365
- 12:56
- 3 ай бұрын
Make an awesome interactive chart displaying aggregated numbers easily in Microsoft 365
- 6:44
- 4 ай бұрын
A feature that you absolutely need to know to make EASY dynamic charts in Microsoft 365
- 18:25
- 5 ай бұрын
Use table slicers to their full potential with the SUBTOTAL function in Microsoft Excel
- 6:54
- 5 ай бұрын
How to make an EASY color-changing rating chart in Microsoft Excel, no Visual Basic for Applications
- 22:36
- 7 ай бұрын
How to add the pivot table grand total to a dynamic chart using as example a chart for NPS®
- 17:57
- 7 ай бұрын
Calculation and an interactive chart for Net Promoter Score® survey results in Microsoft Excel
- 12:03
- 7 ай бұрын
Trick to connect any chart to a pivot table + an awesome dynamic sunburst chart in Microsoft Excel
- 11:07
- Жыл бұрын
Making an interactive tornado (butterfly or pyramid) chart using one pivot table in Microsoft Excel
- 10:59
- Жыл бұрын
How to add currency symbols to cells, chart elements, formulas, and pivot tables in Microsoft Excel
- 9:24
- Жыл бұрын
Automate the bar of pie chart and control it with a slicer for custom drilldown in Microsoft Excel
- 10:23
- Жыл бұрын
Stay on track of project deadlines by setting a self-updating reminder in Microsoft Excel
- 18:24
- Жыл бұрын
Automate the pie of pie chart and control it with a pivot table to drill down any slice in MS Excel
- 14:07
- 2 жыл бұрын
Declutter a line chart by choosing shown product from a drop-down list (OFFSET or INDEX functions)
- 14:48
- 2 жыл бұрын
Charting a Dynamic Year-to-Date Period Using the INDEX Function in Microsoft Excel (Part 2 of 2)
- 16:29
- 2 жыл бұрын
Charting a Dynamic Year-to-Date Period Using the OFFSET Function in Microsoft Excel (Part 1 of 2)
- 20:48
- 2 жыл бұрын
Excel Chart with Rolling 6 Months, 12 Months, or User-Defined End Date using Dynamic Named Ranges
- 12:25
- 2 жыл бұрын
Highlight chart points with a click in a filtered Excel table to explain your key messages - Part 2
- 17:06
- 2 жыл бұрын
Highlight chart points with a click in an Excel table to explain key messages in your report- Part 1
- 15:04
- 2 жыл бұрын
Пікірлер