Using Basic Arrays in Excel

Using Basic Arrays in Excel

An array is a type of formula that can perform multiple calculations on one or more items in an array . You can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results...
Using Basic Arrays in Excel

Working With Graphics in Microsoft Office

Pictures often speak louder than words and MS Office provides us with ample means to use various graphics in our documents. Learn how Smart Art can contribute to better presentation and how Screenshot can be used to improve your documents. Import pictures from various...
Using Basic Arrays in Excel

Favorite Excel Features – Webinar

In this webinar Ronny will share some of her favorite Excel shortcuts, such as: • Autofill capabilities – for dates and values • Creating custom lists – automate commonly used listings • Autocorrect features – create shortcuts for common words/phrases • Grouping...
Using Basic Arrays in Excel

Excel Logical Functions – Webinar

Some of the most common and powerful functions for Excel users are “logical functions”.  These are preset formulas that allow you to test cells for various conditions and return text or values depending on their adherence to criteria that you define.  In the webinar,...
Using Basic Arrays in Excel

PowerPoint Slide Masters Webinar

In this webinar, you will learn how to control the appearance of your slides using Slide Masters. Ronny will demonstrate how to create custom layouts, and how to insert multiple Slide Masters into a presentation with different themes, allowing you to select which...