Arena Training
Essential Virtual and On-Site Technical and Soft-Skills Training since 1994
About Stephanie Hutcheson Executive Summary Styles help you apply consistent formatting across your document and enable features like automatic tables of contents, easy navigation, and quick global updates. For a Detailed PDF with Screen Shots, Click this link OBJECTIVES 5 Practical Applications of Bookmarks in Microsoft Word Styles vs Manual Formatting in Microsoft Word Feature …
About Stephanie Hutcheson Executive Summary Bookmarks in Word let you mark specific locations or sections in a document so you can quickly jump to them later or link to them from elsewhere. For a Detailed PDF with Screen Shots, Click this link OBJECTIVES 5 Practical Applications of Bookmarks in Microsoft Word Create a Bookmark ¡IMPORTANT! …
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 …
Focus mode in Microsoft Teams minimizes distractions, expands shared content, and reduces notification interruptions during meetings, helping you stay focused. It is a relatively new feature designed to help you stay focused and avoid distractions during meetings.
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.
Thanks for visiting! Click the first Link for a complete list of topics. Use the Search Bar to the right to find specific topics or just scroll through the list. Email with questions or suggestions! Happy Learning!
Customize and Use the AutoFill feature in Excel Do you get annoyed by tedious, time-consuming tasks? ME TOO!! One task I automate in Excel is filling patterns by using the AutoFill feature. Use this feature to populate common terminology such as Dates, Months, Days of the Week, Numbers, Text with patterns you create. You can …
Need to organize your slides in your PowerPoint presentation? With SECTIONS you can group your slides into meaningful parts and quickly access, rearrange or delete them.
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 …