Nearly everyone uses Excel, but how much of its vast functionality do you really know? This session will provide you with ideas for more intermediate and advanced usage of this common spreadsheet tool and help you to get more efficient and effective with it along the way. Examples of common data normalizing and cleansing techniques, along with more advanced Excel functionality like pivot tables, lists and conditional formatting will be fully explored. You will have the ability to follow along and try everything in real time with real data. While you may not become a data ninja during this mini session, you will take home some great new ideas you'll be able to use and implement right away when you return from the conference.
Identify cleansing techniques in Excel to help ensure you have clean and accurate data.
Indicate more advanced Excel functionality like pivot tables, lists and conditional formatting.
Review real world applications of these techniques.