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

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

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.

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.6 rating, based on 14 Class Central reviews

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

Udekwe ThankGod O. @udekwee

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.
Sohaib Naeem

"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!
Shakshi Negi

it 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.
Dhanalakshmi E

The 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.
Lavanya

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.
Sanjivani Vijay Dhanawade

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.
Catherine

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."
Shatakshi Pundir

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."
Linisha A

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.
Gulzameen

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
Fernad Nyakaleji

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.
AMEER SOHIL MUCHALI

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
Oyedeji Mariam Mobayonle

The Course is very understandable and I learnt a lot from it,most especially the basics of data analysis.
Vivek Arya

the program is very good and helpful to learn MS excel in day to day life and find solution in professional life.