Arena Training
Essential Virtual and On-Site Technical and Soft-Skills Training since 1994
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 …
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.
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 …
Templates are terrific timesavers and great for consistency. You have created the template, saved it but when you try to access the template you do not see the choice Personal or Office. This is a frustrating scenario so below are some instructions that hopefully will solve this problem. Change Template Options Change your options to …
Hi there Excel users! Stephanie Hutcheson here. Trying to save the world some headaches. I frequently get asked to explain how to show leading zeros in Excel. It’s so frustrating when a leading zero drops from your worksheet. While you can format it as text or type an apostrophe in front of it, you may …