Udemy - Excel Predictive Analytics, Automation, and AI - No-Code
- CategoryOther
- TypeTutorials
- LanguageEnglish
- Total size1.8 GB
- Uploaded Byfreecoursewb
- Downloads104
- Last checkedOct. 25th '24
- Date uploadedOct. 24th '24
- Seeders 21
- Leechers20
Excel Predictive Analytics, Automation, and AI : No-Code
https://DevCourseWeb.com
Published 10/2024
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Language: English | Duration: 3h 57m | Size: 1.82 GB
Microsoft Excel Predictive Analytics, Automation, and AI Tools: The Complete No-Code Guide for Every Professional
What you'll learn
Master Predictive Analytics Using Excel Students will learn how to use Excel’s built-in tools and functions, such as LINEST and TREND
Automate Repetitive Tasks with Macros and VBA Learners will gain the skills to create and implement Excel macros and basic VBA to automate repetitive tasks
Apply Advanced Forecasting Techniques Students will explore and apply advanced forecasting methods, such as exponential smoothing to predict trends
Learners will develop dynamic, interactive dashboards using PowerPivot, Power BI, and Excel’s advanced charting tools to present insights effectively.
Requirements
Basic Understanding of Excel Students should have a basic familiarity with Excel, including knowledge of standard functions like SUM, AVERAGE, and simple cell formatting.
Access to Excel Software Learners will need access to Microsoft Excel (preferably version 2021 or Excel 365) to follow along with the exercises and practical applications.
No Coding Experience Required No prior programming or coding knowledge is needed, as this course focuses on no-code solutions for predictive analytics and automation using Excel.
A Desire to Learn Predictive Analytics While no advanced math or analytics background is required, students should be motivated to explore how data-driven decisions can be made using Excel’s tools.
Files:
[ DevCourseWeb.com ] Udemy - Excel Predictive Analytics, Automation, and AI - No-Code- Get Bonus Downloads Here.url (0.2 KB) ~Get Your Files Here ! 1 - Introduction - Course Outline and Learning Objectives
- 1 -Introduction.mp4 (70.7 MB)
- 2 -Learning Objectives.mp4 (23.6 MB)
- 1 -Foundations of Predictive Analytics.mp4 (17.9 MB)
- 2 -1.xlsx (23.1 KB)
- 2 -Forecast sales using 2D line chart and forecast sheet.mp4 (62.4 MB)
- 3 -2.xlsx (12.9 KB)
- 3 -Trend and Linest.mp4 (47.1 MB)
- 4 -Exponential smoothing in Excel - Practice.xlsx (9.4 KB)
- 4 -Exponential smoothing in Excel.xlsx (9.8 KB)
- 4 -Forecasting with Exponential smoothing and Excel Exercise.mp4 (49.8 MB)
- 1 -What - If Analysis Intro.mp4 (15.5 MB)
- 2 -What - If Analysis Data Table in Excel.mp4 (35.9 MB)
- 2 -What-if Analysis - Practice.xlsx (10.0 KB)
- 2 -What-if Analysis.xlsx (11.6 KB)
- 3 -Marketing_Budget_Scenario - Practice.xlsx (9.3 KB)
- 3 -Marketing_Budget_Scenario.xlsx (11.2 KB)
- 3 -Scenario Manager.mp4 (56.9 MB)
- 4 -Solver Intro.mp4 (20.0 MB)
- 5 -Excel Solver Exercise.mp4 (46.5 MB)
- 5 -Solver - Practice.xlsx (9.9 KB)
- 5 -Solver.xlsx (9.8 KB)
- 1 -Macro in Excel.mp4 (39.4 MB)
- 1 -Sales_Report_For_Macro - Practice.xlsx (8.5 KB)
- 1 -Sales_Report_For_Macro.xlsx (8.9 KB)
- 1 -Sales_Report_Unformatted - Practice.xlsx (8.5 KB)
- 1 -Sales_Report_Unformatted.xlsm (16.6 KB)
- 10 -Chatgpt response - Summary.mp4 (12.1 MB)
- 2 -Coffee_Shop_Analysis_Data - Practice.xlsx (11.0 KB)
- 2 -Coffee_Shop_Analysis_Data.xlsx (16.6 KB)
- 2 -Python in Excel.mp4 (107.7 MB)
- 3 -Results Interpretation of Python Exercise.mp4 (33.4 MB)
- 4 -ChatGPT for Excel Functions - Practice.xlsx (15.1 KB)
- 4 -ChatGPT for Excel Functions.xlsx (16.0 KB)
- 4 -ChatGPT_for_Excel_Tips.mp4 (140.0 MB)
- 5 -ChatGPT for Excel Functions - Practice.xlsx (15.1 KB)
- 5 -ChatGPT for Excel Functions.xlsx (16.0 KB)
- 5 -ChatGPT response to Excel - Excel Functions and OCR.mp4 (79.1 MB)
- 6 -ChatGPT pivot_table_example - Practice.xlsx (11.4 KB)
- 6 -ChatGPT pivot_table_example.xlsx (16.0 KB)
- 6 -Chatgpt response to query - Excel Pivot Table.mp4 (49.5 MB)
- 7 -ChatGPT for Excel VBA - Practice.xlsm (10.0 KB)
- 7 -ChatGPT for Excel VBA.xlsm (23.0 KB)
- 7 -Chatgpt response to Excel 4 - Generate VBA code.mp4 (47.3 MB)
- 8 -Chatgpt response to Excel 5 - Your Personal Tutor.mp4 (61.8 MB)
- 9 -Chatgpt response to Excel 6 - Analyze Excel File.mp4 (46.0 MB)
- 1 -Intro to Logistic regression model.mp4 (35.7 MB)
- 2 -Logistic regression model - example.mp4 (55.3 MB)
- 2 -Logistic_Regression_Example - Practice.xlsx (8.8 KB)
- 2 -Logistic_Regression_Example.xlsx (10.4 KB)
- 3 -Logistic regression model - example interpretation.mp4 (20.4 MB)
- 4 -Intro to K-means clustering.mp4 (15.9 MB)
- 5 -Fruit_KMeans_Clustering - Practice.xlsx (10.1 KB)
- 5 -Fruit_KMeans_Clustering.xlsx (11.1 KB)
- 5 -K- means clustering in excel.mp4 (144.0 MB)
- 6 -Intro to Weighted Scoring.mp4 (22.9 MB)
- 7 -Weighted Scoring - Excel Example.mp4 (49.9 MB)
- 7 -Weighted_Scoring_Model_Template - Practice.xlsx (10.7 KB)
- 7 -Weighted_Scoring_Model_Template.xlsx (11.0 KB)
- 1 -Introduction to PowerBI.mp4 (48.3 MB)
- 2 -Introduction to Powerpivot with example in excel and interpretation.mp4 (69.9 MB)
- 2 -PowerPivot_Excel_Template - Practice.xlsx (10.5 KB)
- 2 -PowerPivot_Excel_Template.xlsx (230.7 KB)
- 3 -Utility Bills Tracking.mp4 (73.1 MB)
- 3 -Utility_Bills_Tracking_2024 - Practice.xlsx (8.9 KB)
- 3 -Utility_Bills_Tracking_2024.xlsx (44.4 KB)
- 4 -Machine Learning in Excel.mp4 (86.3 MB)
- 4 -Sales_Forecast - Practice.xlsx (9.7 KB)
- 4 -Sales_Forecast.xlsx (75.0 KB)
- 5 -Sparklines - Practice.xlsx (9.9 KB)
- 5 -Sparklines.mp4 (35.9 MB)
- 5 -Sparklines.xlsx (10.6 KB)
- 1 -Book1.xlsx (33.6 KB)
- 1 -Power Query and Pivot Tables in Excel.mp4 (90.2 MB)
- 2 -Auto Update.mp4 (34.5 MB)
- 2 -Master Sales Report - Practice.xlsx (9.1 KB)
- 2 -Master Sales Report.xlsx (11.8 KB)
- 2 -North_Region - Practice.xlsx (9.3 KB)
- 2 -North_Region.xlsx (9.3 KB)
- 2 -South_Region - Practice.xlsx (9.3 KB)
- 2 -South_Region.xlsx (9.3 KB)
- 1 -Conclusion and Next Steps.mp4 (23.3 MB)
- Bonus Resources.txt (0.4 KB)
Code:
- udp://tracker.torrent.eu.org:451/announce
- udp://tracker.tiny-vps.com:6969/announce
- http://tracker.foreverpirates.co:80/announce
- udp://tracker.cyberia.is:6969/announce
- udp://exodus.desync.com:6969/announce
- udp://explodie.org:6969/announce
- udp://tracker.opentrackr.org:1337/announce
- udp://9.rarbg.to:2780/announce
- udp://tracker.internetwarriors.net:1337/announce
- udp://ipv4.tracker.harry.lu:80/announce
- udp://open.stealth.si:80/announce
- udp://9.rarbg.to:2900/announce
- udp://9.rarbg.me:2720/announce
- udp://opentor.org:2710/announce