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)
Everything you need to succeed,
all in one place
Personalized learning dashboard, that brings together curated courses, expert mentorship, progress tracking, and AI learning support.
Personalized Learning Dashboard
Everything you need to learn, track progress, and get support, all from one personalized dashboard.
Expertly Curated Courses
Access hundreds of industry vetted modules built around real industry skills
AI Tutor support
Get instant help while you learn, ask questions with our AI tailored to your skill.
Structured Learning Paths
Follow a clear path from beginner to job ready level with recognized certificate.
Expert Mentorship
Get one-on-one guidance from experience industry mentors and receive personalized feedbacks to help you move forward with confidence.
Internationally Accredited by ACTD
Our programs are rigorously vetted and officially recognized by the American Council of Training and Development. This ensures that your credentials carry the prestige and quality standards required in today's global professional landscape.
Our Achievements
Student Feedback
Here is what some past students have to say about us
Sharon
UI-UX
The knowledge and skills gained under the guidance of the UI &UX Tutor have been invaluable. His dedication, expertise, and unwavering support have truly transformed our learning journey.
Amarachi
UI-UX
With the guidance of our tutor, I've been able to envision a roadmap to follow on my journey as a UI/UX designer
David
UI-UX
Grateful to our tutor for his invaluable support and talent in simplifying complex concepts to enhance learning. This has created a motivated environment that has enabled me to grow
Kelvin Ojelum
UI-UX
Firstly, I want to thank the team for the opportunity, it was very helpful. I went through the course to the end and I can actually design now but I am still brushing up and improving myself and I can do a lot of design now.
Onyema Susan
UI-UX
Based on my experience with the previous Techy Jaunt Cohort, it was educational and worthwhile. I got to learn about UI/UX design and this made my Journey in Tech look so seamless.
News Feature
We are featured on a couple of prominent platforms
Ready to jumpstart your tech career?
Join 5000+ Learners already building their future of technology with Techyjaunt
Get Started