3 Months
Virtual Classes
Expert Instructors
How you will learn
Virtual Live Classes
Join and collaborate with other students in an interactive virtual classroom.
Real World Projects
Work on real-world projects by applying what you learn to solve actual business problems.
Community / Groups
Share knowledge with fellow peers and gain distinct perspectives on problem-solving.
Mentorship
Gain invaluable career mentorship and code reviews from experienced tech industry experts.
What you will Learn
UNIT 1
Introduction to Excel and Data Analytics
Overview of Data Analytics, Overview of Excel and its capabilities in data analytics, Understanding basic concepts in data analytics, Navigating the Excel interface
UNIT 2
Data Preparation and Analysis in Excel
Importing data into Excel, Data cleaning and preparation, Data analysis techniques in Excel ( Data validation, conditional formatting, sorting and filtering data.), Introduction to pivot tables, creating pivot tables, analyzing data with pivot tables etc.
UNIT 3
Excel Formulas and Functions for Data Analytics
Overview of Excel formulas and functions, Basic statistical functions (sum, average, median, mode), Advanced functions for data analysis (COUNTIF, SUMIF, AVERAGEIF), Working with data types (text, numbers, dates), formatting cells, basic functions (IF, VLOOKUP, COUNT)
Data Analysis
Taught by Experienced Industry Experts
Techyjaunt instructors are experienced practitioners who work at the world's most innovative companies. They are experts in their field and enter the classroom with years of hands-on experience, making sure you're learning the most up-to-date and practical skills companies around the world need.
Get Trained. Get Skills.
Get Hired.
Enrol Now
Join Techyjaunt community today
Join a community of over 35,000+ tech enthusiasts. As the African Tech space continues to grow, we ensure you stay informed through our vibrant community.