Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

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

ExcelIsFun via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
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 58 Class Central reviews

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

  • 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…
  • 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.
  • 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
  • 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, 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,…
  • SHEETAL KHARAT
    The video was very simple to understand and very helpful. Thank you for making this course so knowledgeable and easy to understand.
  • 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.
  • 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.…
  • Profile image for Tharunsai SARANA
    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…
  • 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
  • Profile image for Ritik Raushan
    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.
  • This is an okay course you can learn a lot of fundamental things regarding data analysis, a nice transition to a SQL course you might want to do next.
  • Sunny
    The Excel Data Analysis Basics class was very informative and practical. It introduced key features such as sorting, filtering, and conditional formatting to manage and clean data effectively. The session covered essential formulas like SUM, AVERAGE, IF, VLOOKUP, and pivot tables, which made analyzing large datasets easier and faster. I learned how to create charts and graphs for better visualization and interpretation of data. The trainer explained concepts clearly with step-by-step examples, making even complex tools simple to understand. Overall, the class built a strong foundation in Excel data analysis, boosting my confidence to apply these skills in real work.

  • Profile image for ORHAN GAZİ KÖSE
    ORHAN GAZİ KÖSE
    It was a great training and helped me become a professional in analysis in a practical way
    I sincerely believe that this education I have received will help me get a head start in my university and business life. I thank you.
  • Shujun Dayis Alhasnani
    This course was truly amazing, and I learned so much from it. The lessons were clear, practical, and very helpful.
  • Anupama
    Explanation is good and i think it was difficult but my opinion totally change, to pearn about data analysis is simple with good guidance, there it is here, i will understand the concept, i will practice in daily routine
  • MOHAMMED KAIS
    SUBJECT IS PRECISE AND CLEAR,
    EASILY UNDERSTANDABLE.
    TEACHING ONLY CORE CONCEPTS.
    PRACTICAL SCENARIO VERY HELPFUL THESE SYLLABUS ESPECIALY DATA ANALYSIS
  • Ritu Prano
    Amazing course for beginner with complete guidance and easy to understand totally worth it . The best thing in this course is the mentor who teach this full course with so much fun . This course really help to enhance anyone's carrier
  • Profile image for Alireza Rajaei
    Alireza Rajaei
    Overall, it was a good course, but my expectations were more towards statistical data analysis. Overall, it was a good course, but my expectations were more towards statistical data analysis. But it was mostly used for big data analysis. The tips and tricks that were useful for importing data and converting it into readable formats by Excel software were also useful. His style of speaking and tone of voice were good and he did not speak too thickly or incomprehensibly.
  • Omar Faruk Opu
    I recently took the "Excel Data Analysis Basics" class, and it exceeded my expectations in every way. This course is perfect for beginners and those looking to brush up on their Excel skills. What I Loved: Clear and Structured Lessons: The course i…

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.