Data Analysis using Excel
The objective of this online workshop is to provide participants with a comprehensive understanding of how to leverage Artificial Intelligence (AI) for optimizing their curriculum vitae (CV). By the end of the workshop, participants will have gained essential knowledge and practical skills to create compelling, ATS-friendly resumes that stand out in the competitive job market.
- Online
- 12 hours
- Certificate of completion
Course Content
Introduction to Excel for Data Analysis:
Excel interface overview, basic formulas (SUM, AVERAGE, COUNT), importing data, and basic data visualization.
Data Cleaning and Preprocessing in Excel
Techniques for handling duplicates, removing blank cells, addressing errors, and using functions like IF and VLOOKUP for data validation.
Basic Statistical Analysis in Excel
Understanding central tendency, dispersion, and variability. Application of functions like STDEV, MEDIAN, and creating frequency distributions.
Creating Pivot Tables for Data Summarization
Creating Pivot Tables for Data Summarization
Data Visualization with Excel Charts
Creating various charts (bar, line, pie), formatting charts for clarity, and adding trendlines. Emphasizing effective storytelling through visual representation of data.