Tag «Microsoft Office Tips»

VSTACK Function: Combine Multiple Sheets into One Array

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.

MS EXCEL AUTOFILL FEATURE

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 …

Waterfall Charts MS Excel

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 …

Controlling the Default Date Format in Office Programs

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.