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

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

Excel Text Functions Webinar

There is frequently a need for text in Excel spreadsheets to create lists, label information, and track products, people, and other items. This webinar will discuss and demonstrate some of the many ways in which text can be manipulated to use existing information...
Using Basic Arrays in Excel

Word Automated Features – Webinar

The webinar will discuss and demonstrate some of the many automated features of Word, which can make the creation of documents more efficient and more attractive. The Webinar will cover: – What is the easiest method of inserting repetitive text blocks? –...
Using Basic Arrays in Excel

Animate your Presentation – Webinar

Microsoft Office programs are extraordinarily popular, used in every industry, for all sorts of purposes. The reason they are so popular is their flexibility. PowerPoint can be used for any type of presentation, whether to one person or a crowd of hundreds, to present...