Advanced Excel
24 hours
Overview
This course is designed to provide a comprehensive broad-based education that develops academicians, business professionals, analysts and data scientists, and project managers to effectively and efficiently use Excel in solving more complex formulas and functions, create and analyze pivot tables and charts, and automate tasks using macros. The goal is to equip participants with essential skills and knowledge to effectively use Microsoft Excel for data management, analysis, and visualization
24 Hours
- Excel Interface & Basic Functions.
- Count & Date Functions.
- Text Manipulation.
- Logical & Conditional Formulas.
- Data Cleaning & Validation.
- Advanced Lookup Techniques.
- What-if Analysis & Tools.
- Data Organization.
- Generative AI & Excel Hacks.
- Final Project & Career Prep.