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...
Cyber Security Tips – Pretexting

Cyber Security Tips – Pretexting

Pretexting is when the bad guys create a false scenario using a made-up identity or pose as someone you know to manipulate you into divulging personal or sensitive information. They often pose as employees of bank or credit card companies or even as your own...
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,...