Learn how to perform Data Analysis and Business Intelligence using Excel Power Tools. Develop skills in creating reports, dashboards, and visualizations using Excel formulas, PivotTables, Power Query, Power Pivot, and Power BI Desktop. The course teaches you to import, clean, transform, and visualize data, build data models, and work with Big Data. The teaching method includes video lectures and practical demonstrations. This course is designed for individuals interested in enhancing their data analysis skills using Excel for 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
Reviews
5.0 rating, based on 2 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.
-
the program is very good and helpful to learn MS excel in day to day life and find solution in professional life.
