Dive into a comprehensive 6-hour video series on Excel data analysis and business intelligence. Master essential Excel power tools including formulas, PivotTables, Power Query, Power Pivot, and Power BI Desktop to transform real-world datasets into actionable insights. Learn to structure data efficiently, create dynamic reports and dashboards, import and clean big data, build data models, and develop interactive visualizations. Explore advanced techniques such as DAX formulas, data modeling, and sharing reports online through Power BI. By the end of this course, gain the skills to construct efficient, refreshable, and sharable reports and dashboards for effective business decision-making.
Excel Data Analysis Basics Class - Data Analysis & BI Made Easy with Excel Power Tools
ExcelIsFun via YouTube
Overview
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
Related Courses
Related articles
Reviews
4.6 rating, based on 16 Class Central reviews
-
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.
-
Shakshi Negiit is a very good course for the beginners because it helped me a lot to understand the work of excel and the power bi tool for the analysis purpose. I think it should be a little more basics of power bi, to get better understand the tool which is new for many users. and also, this website must be given the resources which are provided in the video by the tutor. -
"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,…
-
Dhanalakshmi EThe classes are knowledgeable and provided clear explanations with practical examples. Hands-on learning was emphasized, which helped solidify my skills. The small class size allowed for personalized attention and a collaborative learning environment. Overall, it was a valuable experience that significantly improved my Excel proficiency.
-
VICTOR KLUTSELearning data analysis with Excel has been a game-changer! I've gained hands-on experience in collecting, analyzing, and interpreting data to inform business decisions. Excel's powerful tools, such as pivot tables, charts, and formulas, have become essential skills in my toolkit. I've improved my ability to identify trends, create forecasts, and present insights effectively. I highly recommend learning data analysis with Excel to anyone looking to enhance their analytical skills and drive business growth. It was worth the while... I promise you won't regret it. -
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.
-
I truly enjoyed this course.
I appreciated how the instructor surveyed the class before to get a sense of what we all wanted to take away from the course.
The instructors were fantastic – very knowledgeable and willing to answer questions as they came up. -
The course content was comprehensive and covered all the essential aspects of Excel data analysis."
"I appreciated how the course started with the basics and gradually moved to more advanced topics, ensuring a solid foundation." -
This course exceeded my expectations! I gained practical skills in data analysis and visualization.While the course was informative, I wished there were more hands-on projects to practice my skills.
-
i have learned alot it was amazing .the data was from basics and then moved on to advance formating I loved it the content was related to topic slides and videos were well explianed
-
This course is an enlightening one. I learnt a lot of things i did not even know exist before. i will recommend this course to people because it will help on your analysis journey.
-
Awesome and well organized content. This was on point and the instructor is knowledgeable at what he does. The flow was also detailed and the pace too was on point.
-
It's really helpful for me and I learn so many things in this course and I gain my knowledge more I hope I will use this course particular time or situation
-
The Course is very understandable and I learnt a lot from it,most especially the basics of data analysis.
-
The course content was comprehensive and covered all the essential aspects of Excel data analysis."
"I appreciated how the course started with the basics and gradually moved to more advanced topics, ensuring a solid foundation." -
the program is very good and helpful to learn MS excel in day to day life and find solution in professional life.
