Arena Training
Essential Virtual and On-Site Technical and Soft-Skills Training since 1994
About Stephanie Hutcheson Executive Summary Learn how to hide filter buttons on Excel Pivot Tables using two powerful methods: the Field Headers toggle in the PivotTable Analyze tab and a VBA macro script. This tutorial is perfect for Excel power users, data analysts, and spreadsheet sorcerers looking to clean up their dashboards. Why Hide Filter …
March 2022 saw the release of 14 new Excel functions specifically for working with text and dynamic arrays. Use these functions to split text or combine, resize, and reshape arrays. VSTACK uses the dynamic array environment to combine lists and arrays vertically into a single array.
Do you need to analyze profit and loss? Or track changes over time? A waterfall chart may be the tool of choice. You can visually represent cash flow, budget changes, outliers and anomalies using this technique. These charts are a terrific way to visually present data in an appealing and intuitive manner. Objectives: What is …
Love using MS Excel’s conditional formatting feature? Learn to use it in PivotTables so that the formatting is as dynamic as your source data.