Arena Training
Essential Virtual and On-Site Technical and Soft-Skills Training since 1994
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 …
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 …
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.
Use the full power of MS Excel’s Data Validation feature.
“But I want to change different pages to different colors in a Word document”
Feeling a bit chagrined but undaunted, I set out to find a workaround.
Making Your Meetings Impactful Keep in mind these tips are not “hard and fast”;As with everything in life, use them judiciously. Use the slide master feature to create a consistent and simple design template. Simplify and limit the number of words on each screen. Limit punctuation and avoid all capital letters. More white space is …
Stephanie Hutcheson, MCT October 4, 2021 Engage your audience with presenter modes Meeting participants tend to be more focused and have a better experience when they see a presenter along with a presentation. An interactive presenter also helps guide an audience along with visual cues while reducing information overload. By using a presenter mode such …
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 …