Arena Training
Essential Virtual and On-Site Technical and Soft-Skills Training since 1994
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.
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 …
Use the full power of MS Excel’s Data Validation feature.
Have you ever been annoyed because you have to set the date and/or time format in your Office documents Every.Single.Time. you create a new one? Help is on the way!! This tutorial will take you through the steps to insure that you save time and frustration by changing the default date and time.
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.
When you’re not in the mood for change! Protecting the Workbook Structure Protecting the workbook structure prevents the user from viewing hidden worksheets, adding, moving, deleting, hiding, or renaming them. You can protect the structure of your Excel workbook with a password if you choose, but it is not necessary. Review–Protect Workbook Choose Protect Workbook …