NGC IT Training @ngcittraining-blog - Tumblr Blog

Excel - Quick Tip #08 - Using COUNTIF to count with conditions

Excel - Anchoring Ranges - locking rows and columns

Excel - Quick tip #07 - Using LARGE and SMALL for TOP3 and BOTTOM3

Excel - Data Validation - Creating dependent drop down lists

Excel - Quick Tip #06 - Using Fill Justify to shape text.

Excel - The basics of the Indirect function

Excel - Quick Tip #05 - Using Format Painter

Excel - Named Ranges - Using names instead of ranges

Excel - Quick Tip #04 - Splitting text into different columns

Excel - Data Validation - Dynamic drop-down list

Excel - Quick Tip #03 - How to line break text on a cell

Excel - Using SUM across multiple tabs

Excel - Quick Tip #02 - Transpose - Vertical and Horizontal data rotation

Excel - Index & Match - Using multiple lookup values

Excel - Quick Tip #01 - Data Validation drop-down list

Excel - Index & Match - Using Row & Column parameters

Excel - Index & Match - Replacing VLookup

NGC IT Training