This Excel series brings together essential Excel methods and techniques to help you quickly and successfully step into your career, irrespective of industry. Whether you want to work for a non-profit, a large or small company, a startup, or become an entrepreneur, these Excel skills will elevate your professional capabilities so you can comfortably work through more challenging data-related tasks.
This workshop series is crafted to be ‘learning by doing’ while tackling real world scenarios, without having any prior work experience. In this program, students will:
- Get acquainted with more advanced Excel formulas, functions, and techniques that are commonly used in reporting or data analysis tasks
- Learn efficient reporting techniques and 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
- Use a variety of Excel tools and techniques to complete data-related deliverables