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 | Dec 14, 2016 | Training
Macros can help you by reducing a 10 step process to one step! – How often do you type your company’s name, address, phone? – You can record a macro to do this in one keyboard shortcut or click on a command button. – You can set up multiple common...
by Garry Feldman | Sep 19, 2016 | 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. You may want to find out how many items in your inventory cost over $100, or how many customers ordered more...
