This Excel Factor tip is from Dr Isaac Gottlieb, professor at Temple University in Philadelphia. Words by Mynda Treacy Excel In Cell Charts aren’t actually charts at all, insofar as you won’t find them in the Charts menu in Excel. They’re actually a formula that you can insert in any empty cell, like you see [...]
July 2012
This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. Excel PivotTables are one of the greatest tools in the spreadsheet user’s toolkit. However, there is one tiny bit of functionality that appears to be missing: the ability of pivot tables to automatically update when information in the source data changes. Most [...]
The following Excel Factor entry was sent in by Daniel Ferry, founder of Excel enthusiast blog, Excel Hero. Often an Excel model needs a dynamic print area, as data that we wish to print may change over time. Watch how the print area for the table below (depicted by the dashed line around the data), [...]
The need to look up and match multiple criteria is quite common; however as with most things in Excel there are many ways to ‘skin a cat’, I’ll share two options with you here. Matt Duncan from Florida sent in this a cool INDEX and MATCH array formula that allows you to match two criteria [...]
Importing data into Excel from other systems rarely goes without the need to fix formatting before you can even use it. Sandy R from Pittsburgh, PA sent in this Excel Factor entry. Using the REPT, LEN, FIND and MID functions Sandy can transform thousands of rows of data that comes into Excel like this: 3707.314278 [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
