Excel Data Analysis Basics Class - Data Analysis & BI Made Easy with Excel Power Tools

ExcelIsFun via YouTube

Start learning Write review

This course uses Excel and Power BI tools to turn real-world datasets into reports and dashboards for business decision-making. Learners practice data preparation, modeling, visualization, and sharing reports.

Syllabus

Free Excel Data Analysis Basics Course at YouTube (E-DAB)
E-DAB 01: What is Data Analysis & Business Intelligence?
E-DAB 02: Data, Proper Data Sets, Excel Tables, Logical Tests, More
E-DAB 03: Excel Spreadsheet Formulas Old School? Or Dynamic Arrays?
E-DAB 04: PivotTables & Slicers Create Dashboards & Summary Reports
E-DAB 05: Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards
E-DAB 06: The Magic of Power Query to Import, Transform & Load Data
E-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot?
E-DAB 08: Power Pivot: Big Data, Data Modeling, DAX & Dashboards
E-DAB 09: Power BI Desktop: Data Modeling & Interactive Visualizations
E-DAB-10: Excel & Power BI Together! Import, Publish and Share Reports & Visualizations

Taught by

ExcelIsFun

Reviews

4.5 rating, based on 67 Class Central reviews

Start your review of Excel Data Analysis Basics Class - Data Analysis & BI Made Easy with Excel Power Tools

Heverton Carlos Rios @Hevertonrios
1

Acabo de finalizar meu curso de Excel e foi uma experiência extremamente enriquecedora. O curso foi rápido, didático e muito fácil de acompanhar, trazendo clareza em cada detalhe do aprendizado. A imersão foi completa, permitindo desenvolver desde a…

Acabo de finalizar meu curso de Excel e foi uma experiência extremamente enriquecedora. O curso foi rápido, didático e muito fácil de acompanhar, trazendo clareza em cada detalhe do aprendizado. A imersão foi completa, permitindo desenvolver desde a criação de tabelas e planilhas até o uso de fórmulas de forma prática e objetiva.

Aprendi a organizar dados, estruturar informações, montar controles de caixa e relatórios, sempre com foco na importância da organização e da precisão em cada detalhe. A riqueza de recursos apresentados e a forma clara de explicação tornaram o aprendizado não apenas acessível, mas também aplicável no dia a dia.

Foi um curso de grande valor, que me proporcionou conhecimentos essenciais para otimizar processos e ganhar eficiência. Gostei muito da experiência e recomendo fortemente a todos que desejam aprimorar suas habilidades no Excel. Sem dúvida, é um investimento que vale a pena.
Udekwe ThankGod O. @udekwee
2

This is an in-depth course on Excel, including how to use Power Query, pivot tables, and the introduction of Power BI. I enjoyed every bit of it, especially the class work and tests that can be downloaded and worked on. Thank you, Guys.
TSHILENGE KANANGA Elysée @ELYSEE

i glad to learned this course cause i believe that will help me in my career ,so now i think that i have the goal to build my career in Data analysis and to look in others courses, and i will keep going to learn the big data
ABASS ABU-YAHYA
1

this course has been very formative, assistive and it has instilled in me some confident to tackle the industry and as well analyse a lot of things in a smart way. i highly recomend this to everyone who's starting a carrier in data analysis.
Abdulahi Abdirahman Haidar

I really enjoyed taking the Excel Power Tools course. It helped me improve my practical Excel skills and understand how powerful tools can make data analysis faster and more efficient. I learned useful techniques for working with data, organizing information, cleaning datasets, and creating better analysis workflows. The lessons were clear, practical, and easy to follow, especially for someone who wants to build professional data-analysis skills. I also gained more confidence in using Excel for real-world business and financial data. I would recommend this course to learners who want to strengthen their Excel skills and take their data analysis to the next level.
Abram Maged

goode Very beautiful, really very beautiful, and it will suit everyone Very beautiful, really very beautiful, and it will suit everyone. It's very nice and I love it a lot.
Radhika Sood

It's a good course for getting the basic idea of excel, power query, and power bi , I have got an idea of data visualization ,data cleaning and much more from this course . it is the combination of videos in a sequence to follow and get the better understanding at the end .
Suresh P

Really enjoyed this course! The explanations were simple, and the hands-on examples made it easy to understand Excel's data analysis tools. Definitely worth it if you're looking to improve your Excel skills
Sohaib Naeem
2

"I recently completed the Excel Data Analysis Basics class, and I must say, it was a game-changer! The course was well-structured, and the instructor was knowledgeable and engaging. I learned how to harness the power of Excel's data analysis tools,…

"I recently completed the Excel Data Analysis Basics class, and I must say, it was a game-changer! The course was well-structured, and the instructor was knowledgeable and engaging. I learned how to harness the power of Excel's data analysis tools, including pivot tables, charts, and Power BI.

The class was perfect for beginners like me, and the hands-on exercises helped me apply the concepts to real-world scenarios. I'm now confident in my ability to analyze and visualize data, making me a valuable asset to my organization.

Highly recommend this class to anyone looking to upskill in data analysis with Excel. It's a great investment in your career!

Rating: 5/5 stars"

Feel free to customize it based on your personal experience with the class!
Dhruv Shah

the recordings are good will check oput more videos like this
also will recommednthis to my friends
Kothapalli Bhoomika

The Excel Data Analysis Basics class was easy to understand and beginner-friendly. The concepts were explained clearly with practical examples. It helped me build a good foundation in Excel.
Naresh Dj

It's very intersting to learn and also useful for my career development and achieve my job then clarify my doubt about skills
Anonymous

I recently completed the Excel Data Analysis Basics Class - Data Analysis & BI Made Easy with Excel Power Tools by ExcelIsFun on YouTube, and it was an excellent introduction to data analysis using Excel. The course is very practical and hands-on, m…

I recently completed the Excel Data Analysis Basics Class - Data Analysis & BI Made Easy with Excel Power Tools by ExcelIsFun on YouTube, and it was an excellent introduction to data analysis using Excel. The course is very practical and hands-on, making it easy to follow along while applying the concepts directly in Excel.

What I liked most was how clearly the instructor explained complex features like PivotTables, Power Query, and Power Pivot. These are tools that often seem intimidating, but the step-by-step demonstrations really broke them down into manageable pieces. The instructor also emphasizes real-world use cases, which helped me understand how these tools can be applied to everyday data analysis tasks.

The pacing was just right—not too fast, but not dragged out either. The examples used were simple but effective, showing how raw data can be cleaned, transformed, and analyzed in meaningful ways. I also appreciated that the course focused not only on formulas and functions, but also on building a workflow for data analysis in Excel.

If you’re looking for a free, easy-to-understand, and practical way to start with Excel’s more advanced data tools, this class is a fantastic choice. It gave me more confidence in handling data and opened the door to exploring business intelligence features in Excel.
Baskaran S

In this EDAB course very simple understanding and improve my skills and useful tha return document and video so I am pratic in home work so very good
Andre Marvero

Kursus "Excel Data Analysis Basics Class - Data Analysis & BI Made Easy with Excel Power Tools" ini benar-benar luar biasa dan sangat direkomendasikan bagi siapa pun yang ingin meningkatkan keterampilan analisis datanya menggunakan Microsoft Excel.…

Kursus "Excel Data Analysis Basics Class - Data Analysis & BI Made Easy with Excel Power Tools" ini benar-benar luar biasa dan sangat direkomendasikan bagi siapa pun yang ingin meningkatkan keterampilan analisis datanya menggunakan Microsoft Excel. Materi disampaikan dengan cara yang mudah dipahami dan terstruktur dengan baik, bahkan untuk pemula sekalipun. Instruktur menjelaskan konsep-konsep dasar analisis data dan Business Intelligence (BI) dengan jelas dan aplikatif.
Yang paling saya hargai adalah fokus pada Power Tools Excel, seperti Power Query dan Power Pivot. Sebelum mengambil kursus ini, saya merasa terintimidasi oleh alat-alat ini, tetapi kini saya dapat menggunakannya untuk membersihkan, mengubah, dan menganalisis set data yang besar dengan efisiensi yang jauh lebih baik. Pembelajaran tentang pembuatan dasbor interaktif juga sangat berharga, memberikan wawasan yang mendalam dari data mentah. Kursus ini benar-benar membuktikan bahwa Excel adalah alat yang ampuh untuk analisis data modern. Sangat memuaskan!
Kris Nakrani

This Excel course is well-structured, practical, and highly beneficial for learners at all levels. It explains concepts clearly, starting from the basics and gradually moving to advanced features like formulas, functions, pivot tables, and data analysis tools. The hands-on exercises and real-life examples make learning engaging and easy to understand. The instructor explains each topic step by step, which helps build confidence while working with large datasets. The course has significantly improved my productivity and analytical skills. Overall, it is an excellent course for students, professionals, and anyone looking to strengthen their Excel knowledge for academic or career growth.
SHEETAL KHARAT

The video was very simple to understand and very helpful. Thank you for making this course so knowledgeable and easy to understand.
Tharunsai SARANA

Excellent Introduction to Excel's Power Tools! This course by ExcellsFun is a fantastic starting point for anyone new to data analysis in Excel. The instructor explains the basics of Data Analysis and Business Intelligence (BI) very clearly, making…

Excellent Introduction to Excel's Power Tools!
This course by ExcellsFun is a fantastic starting point for anyone new to data analysis in Excel. The instructor explains the basics of Data Analysis and Business Intelligence (BI) very clearly, making complex topics easy to understand. I especially found the sections on Excel's Power Tools (like Power Query and Power Pivot) to be incredibly helpful. These aren't always covered in basic classes, but they are super powerful for handling and analyzing data. The lessons are well-paced, and I was able to follow along and practice on my own. I definitely feel more confident in my Excel skills after taking this class. Highly recommended for students or anyone looking to level up their data skills!
Iroka Uche Chrysogonus

I've just completed the Excel Data Analysis Basics Class and I'm impressed! The course effectively covered Power Tools, data visualization. Practical examples and hands-on exercises made complex concepts easy to grasp. A great starting point for beginners and a useful refresher for experienced users. Looking forward to applying these skills!

My major problem is how to get the office 365, am using office 2021
Ritik Raushan

This course is a great introduction to Excel data analysis. The instructor explains each concept clearly and uses practical examples that are easy to follow. I especially liked the sections on Power Query, PivotTables, and basic BI tools. It’s very helpful for beginners and for anyone who wants to build real-world data analysis skills in Excel.