by Garry Feldman | Jun 20, 2019 | Training, Webinar
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...
by Garry Feldman | Dec 16, 2018 | Training, 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...
by Garry Feldman | Nov 25, 2018 | Training, 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,...
by Garry Feldman | Apr 20, 2018 | Training, 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...
by Garry Feldman | Dec 27, 2017 | Training, Webinar
If you have been using Excel for some time, you have probably come across situations in which you would like to pull out information from a large data-set without modifying the list or looking across the columns and down the rows to find the information you need. One...
