All data analysis start with data collection. How ever you organize your data, whether it's in Excel, GSheets, or Word, it matters that it's clean. By clean, I mean reliable and formatted in the way you need it. On this site, I share some ways on how I do that. Just like you, I started off not knowing anything except how to use a few formulas in excel. It was enough at that time but it wasn't sustainable. As I spent more time thinking through how to solve business problems, I had no choice but to expand my knowledge. Note that I'm not giving you all of the solutions, simply a starting point or a baseline on how to spend less time collecting and cleaning data and more time analyzing. Again, this is not a comprehensive documentation on how to become a data analyst but it'll get you to a place where you hate yourself less by juggling less spreadsheets.
Here are some tools that I use. They're all FREE and that's the focus! I'm not here to sell anything, only to make your life easier :)
Additionally, since the birth of AI and advanced analytics, there have been plenty of sites with free lesson planning support. Below are some of them that teachers loved because 1) they are free, 2) easy to use, 3) interactive/engaging.
Magic School AI is an educational platform that uses artificial intelligence to provide personalized learning experiences for students. It offers interactive lessons, adaptive assessments, and resources tailored to individual learning styles and progress.
Khan Academy is a free online educational platform that provides a vast array of instructional videos, practice exercises, and a personalized learning dashboard across subjects like math, science, and humanities. It allows students to learn at their own pace and track their progress through various levels of content.
ChatGPT is an AI tool that helps K-12 students by providing instant answers, explanations, and support for learning in various subjects. It can assist with homework, encourage critical thinking, and enhance engagement through interactive discussions.
Google Bard provides Ohio's K-12 students with instant access to information and explanations, enhancing their learning experience and encouraging independent exploration. Its interactive nature can help students clarify concepts, assist with homework, and foster critical thinking skills.
Meta-Calculator is a versatile online tool that offers various calculators for math, including a scientific calculator, graphing calculator, and matrix calculator. It allows users to perform calculations, create graphs, and solve complex mathematical problems interactively, making it a helpful resource for students and educators.
GeoGebra is an interactive math software that combines geometry, algebra, and calculus. It is widely used in education for teaching and learning, offering tools for graphing, geometry construction, and dynamic modeling.