Power Excel Tools for the Executive Assistant

Administrative Professionals who are already comfortable with Excel fundamentals (from creating spreadsheets to sorting & filtering information) must attend this class to learn more about advanced Excel functionality. Using sample workbooks, this course focuses on functions and other advanced features that will enhance the users’ knowledge and customization of Excel, as well as learning about many of the “hidden” Excel functions available.

After participating in this session, the user will be able to:

• Create and use pivot tables
• Compare and combine data using Excel Scenarios and Consolidation Tools
• Identify the latest Excel features, including how to use Dynamic Array Functions

Bonus Handout: 20 Way Cool Excel Shortcuts!

About James Spellos: James Spellos is the President of Meeting U., a company specializing in helping people become more productive and comfortable with technology.  Jim is certified as a Microsoft Office Specialist (MOS). He delivers over 150 seminars annually on how to use technology more efficiently, and how it is altering the nature of business. Jim is an adjunct faculty member at New York University, teaching in the School of Professional and Continuing Studies since 1990. He has been honored with both their Award for Teaching Excellence and their Outstanding Service Award. In the past few years, Jim has also been named a meeting industry trendsetter by Meetings Today magazine.