Continuing Education: Microsoft Excel 2

This course goes beyond MS Excel 1 to include more complex features such as creating and modifying pivot tables, using names instead of cell references in formulas and creating and using nested IF statements. Participants will learn to use advanced techniques to create filters and sorts, how to eliminate duplicates, use Data Validation to create and maintain drop down lists, and how to share Excel data with other applications.