fb_pixel

Learn Data Analytics on your own: A structured learning

Beginner

Ratings star4.8

328 Reviews

Unlock the door to the future with comprehensive data classes designed to transform your skills and career. Accessible to you anytime, anywhere. No prior tech experience required.

Data Analytics

Visualization

138.5 hours

24 videos

69 Exercises

24,000 students

Course Description

Master Excel from basics to advanced analytics. Learn to create powerful dashboards, perform complex data analysis, and automate workflows. Perfect for beginners and professionals looking to enhance their data analytics skills.

Curriculum

1

Introduction to Data Analytics

FREE

Get started with the fundamentals of data analytics. This free section covers the basics of Excel, cell referencing, ranges, named ranges, and formulas.

2

Lookups (VLOOKUP, XLOOKUP)


Learn powerful lookup functions to search and retrieve data from tables - essential skills for data analysis and reporting.

3

Pivot Tables


Master pivot tables to summarize, analyze, and present large datasets quickly. Learn to create dynamic reports and insights.

4

Data Validation


Implement data validation rules to ensure data accuracy, create dropdown lists, and prevent data entry errors.

About the Instructor

Instructor James Gabriel

James Gabriel

Data Analytics Instructor

Excel expert and data analytics professional with over 10 years of experience helping businesses make data-driven decisions. Specialized in Excel automation, dashboard creation, and business intelligence. Passionate about teaching practical skills that deliver immediate value in the workplace.

Excel

Power Query

Power BI

Tableau

Data Visualization

VBA

rectangle1
rectangle2
rectangle3
rectangle4

Everything You Need to Know About Self-Learning

  • Datafrik Self-Learning is our flexible, on-demand learning platform that gives you access to industry-grade data courses. You can learn at your own pace, on your own schedule, with the same quality content and projects from our live bootcamps—but without the fixed class times.

  • Self-Learning features pre-recorded video lectures you can watch anytime, while our Bootcamp is live, instructor-led with real-time interaction. Self-Learning is more affordable and flexible, perfect if you're juggling work or studies. Both offer the same curriculum, projects, and certification.

  • No prior experience required! Our self-learning courses are designed for complete beginners. We start from the fundamentals and gradually build your skills. Whether you're a student, career switcher, or professional looking to upskill, you can start from scratch.

  • Once you enroll in a self-learning course, you have lifetime access to all course materials, including video lectures, projects, and resources. You can revisit any lesson whenever you need a refresher or want to review specific topics.

  • Yes! Upon successful completion of your course and projects, you'll receive an industry-recognized certificate that you can add to your resume, LinkedIn profile, and portfolio. This validates your newly acquired data skills to potential employers.

  • Absolutely! While self-learning is self-paced, you're not alone. You'll have access to our community forum where you can ask questions, connect with fellow learners, and get guidance. We also offer optional mentorship add-ons for personalized support.

Quote

The self-learning platform gave me the flexibility I needed to study while working full-time. I could pause, rewind, and review concepts until they clicked. Now I'm confidently using Python and SQL in my new role.

Adebayo

Adebayo

Junior Data Analyst

Background

Ready to take the next step? Start
learning with Datafrik today and build skills that truly matter

Logo

datafrik.co

Copyright © 2024 Datafrik.co

All rights reserved

Quick Links
Career Bootcamp
Tools Bootcamp
Stay up to date

1813 Pinsky Lane, North Las Vegas, NV, 89032, USA

Email: support@datafrik.co

© 2026 datafrik.co