AESOP Academy Technical Training: Excel Advancement Level 2

Data analysis & blending techniques, and efficient reporting methods.Join us for this next level Excel series that brings together essential Excel methods and techniques to help you quickly and successfully step in and standout in your career, irrespective of industry.This series focuses on the Excel skills used by everyday experienced professionals to analyze and blend data, as well as generate efficient reporting. Knowing these techniques will elevate your professional capabilities so you can comfortably work through more challenging data-related tasks typically expected of senior analysts / associates.Workshop is crafted as a ‘learning by doing’ format while tackling real world scenarios, even without having any prior work experience. In this program, students will: Learn efficient reporting techniques and data analysis calculations to blend, aggregate, and summarize results (SUMIFs, COUNTIFs, Cell Reference and Locking, VLOOKUP)
Conduct summarized analysis with Pivot Tables and build insightful visualizations working with Pivot Charts
Establish data management best practices to handle data and create well-structured workbooks
Complete exercises while using a variety of key Excel tools and techniques to become comfortable with the more advanced Excel formulas and functions
“I actually just received a job offer on Friday, and I think one of the things that made me stand out was my knowledge of Excel and SQL. (from AESOP courses)”Nathan Stein, Economics, Aesop Academy Student“I really enjoyed the AESOP Excel Intensive and I learned a lot! Thanks so much for helping me build skills and my resume.”Julia Hablak, Russian and Literature, Creative Writing, Aesop Academy StudentThis Academy is led by Haverford ’09 alum Panos Panidis. Panos has a great deal of industry expertise in consulting, finance, startups, and entrepreneurship and has become a dedicated mentor to supporting talented students as they explore competitive career paths. His passion is to share his years of accumulated technical expertise, professional guidance and career tips with driven students to help them achieve their professional aspirations early-on.