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...
by Garry Feldman | Nov 15, 2017 | Training, Webinar
Excel workbooks often have important, inter-related information on multiple sheets. You may have a sheet for each month with sales data or a sheet containing production figures for each product your company produces. One of Excel’s powerful features is the ability to...
by Garry Feldman | Oct 24, 2017 | 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 | Sep 13, 2017 | Training, Webinar
In all MS Office applications, you can customize your Quick Access Toolbar (QAT), as well as your Ribbons, and the Tabs on your Ribbons. Having useful commands at your fingertips, without having to search for them, or execute multiple clicks, can save you time. There...
by Garry Feldman | Jun 13, 2017 | Training, Webinar
Creating graphic displays from spreadsheet data is the most engaging way to explain and illustrate your information. Charts can be created from Excel data, or in PowerPoint itself. There are a large number of chart types, but the most common ones, such as column, bar,...
