Difference between revisions of "Excel"

From
Jump to: navigation, search
m
Line 5: Line 5:
 
|description=Helpful resources for your journey with artificial intelligence; videos, articles, techniques, courses, profiles, and tools  
 
|description=Helpful resources for your journey with artificial intelligence; videos, articles, techniques, courses, profiles, and tools  
 
}}
 
}}
−
[https://www.youtube.com/results?search_query=Excel+Data+Analysis YouTube search...]
+
[https://www.youtube.com/results?search_query=Excel+Data+Analysis+Forecasting+deep+machine+learning+ML+artificial+intelligence YouTube search...]
−
[http://www.google.com/search?q=Excel+Data+Analysis+deep+machine+learning+ML+artificial+intelligence ...Google search]
+
[http://www.google.com/search?q=Excel+Data+Analysis+Forecasting+deep+machine+learning+ML+artificial+intelligence ...Google search]
  
 
* [[Microsoft]] Tools
 
* [[Microsoft]] Tools
Line 14: Line 14:
 
Microsoft Excel has a [http://www.microsoft.com/en-us/download/details.aspx?id=35578  data mining add-in] for making clusters. You can find instructions here. The wizard works with Excel tables, ranges or Analysis Survey Queries. This add-in can be customized, unlike the Detect Categories tool. In addition, the Detect Categories tool is limited to data from tables.  [http://www.statisticshowto.com/clustering/ Clustering in Excel | Statistics How To]  
 
Microsoft Excel has a [http://www.microsoft.com/en-us/download/details.aspx?id=35578  data mining add-in] for making clusters. You can find instructions here. The wizard works with Excel tables, ranges or Analysis Survey Queries. This add-in can be customized, unlike the Detect Categories tool. In addition, the Detect Categories tool is limited to data from tables.  [http://www.statisticshowto.com/clustering/ Clustering in Excel | Statistics How To]  
  
−
 
+
{|<!-- T -->
 +
| valign="top" |
 +
{| class="wikitable" style="width: 550px;"
 +
||
 
<youtube>0lpfmFnlDHI</youtube>
 
<youtube>0lpfmFnlDHI</youtube>
 +
<b>HH1
 +
</b><br>BB1
 +
|}
 +
|<!-- M -->
 +
| valign="top" |
 +
{| class="wikitable" style="width: 550px;"
 +
||
 
<youtube>B22arpiRTes</youtube>
 
<youtube>B22arpiRTes</youtube>
 +
<b>HH2
 +
</b><br>BB2
 +
|}
 +
|}<!-- B -->
 +
{|<!-- T -->
 +
| valign="top" |
 +
{| class="wikitable" style="width: 550px;"
 +
||
 
<youtube>cXiZ_t2NK1k</youtube>
 
<youtube>cXiZ_t2NK1k</youtube>
 +
<b>HH3
 +
</b><br>BB3
 +
|}
 +
|<!-- M -->
 +
| valign="top" |
 +
{| class="wikitable" style="width: 550px;"
 +
||
 
<youtube>EZEygGFOTNc</youtube>
 
<youtube>EZEygGFOTNc</youtube>
 +
<b>HH4
 +
</b><br>BB4
 +
|}
 +
|}<!-- B -->
 +
 +
= <span id="Forecasting"></span>Forecasting =
 +
[[...predict values]]
 +
* [http://www.microsoft.com/en-us/microsoft-365/blog/2015/10/06/one-click-forecasting-in-excel-2016/ One-click forecasting in Excel 2016]
 +
 +
{|<!-- T -->
 +
| valign="top" |
 +
{| class="wikitable" style="width: 550px;"
 +
||
 +
<youtube>UCW5Odd_oSA</youtube>
 +
<b>FORECAST.LINEAR & FORECAST.ETS Functions in [[Microsoft]] Excel 2016
 +
</b><br>The FORECAST.ETS  predicts a future value based on historical values.  It uses the Exponential Triple Smoothing (ETS) algorithm.  The FORECAST.LINEAR function makes a prediction using a simple linear regression.
 +
|}
 +
|<!-- M -->
 +
| valign="top" |
 +
{| class="wikitable" style="width: 550px;"
 +
||
 +
<youtube>MIzy-aCYG_I</youtube>
 +
<b>Introduction to Forecasting in Excel
 +
</b><br>Chandoo Learn how to use the awesome Forecasting feature of [[Microsoft]] Excel 2016 / 2019 / 365. We will learn about time series forecasting, seasonal fluctuations and confidence intervals too.
 +
|}
 +
|}<!-- B -->
 +
{|<!-- T -->
 +
| valign="top" |
 +
{| class="wikitable" style="width: 550px;"
 +
||
 +
<youtube>-jx8dOkrG5g</youtube>
 +
<b>How to do forecasting with Excel 2016
 +
</b><br>If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of [[Microsoft]] Excel 2016 have a basket of tools to get the job done.
 +
|}
 +
|<!-- M -->
 +
| valign="top" |
 +
{| class="wikitable" style="width: 550px;"
 +
||
 +
<youtube>UiZt04a3F9I</youtube>
 +
<b>How to Use Statistical Functions for Forecasting in [[Microsoft]] Excel 2016 - Part 1
 +
</b><br>During this Microsoft Excel 2016 advanced training tutorial video, we will cover the statistical functions for forecasting. We will show examples using the functions SLOPE and INTERCEPT, FORECAST.LINEAR, and TREND. We will also explain what are independent and dependent variable.
 +
|}
 +
|}<!-- B -->
 +
{|<!-- T -->
 +
| valign="top" |
 +
{| class="wikitable" style="width: 550px;"
 +
||
 +
<youtube>v4rS9L9MuI4</youtube>
 +
<b>Forecasting in [[Microsoft]] Excel and Trends Functions
 +
</b><br>You can use this function to predict future sales, cash and inventory, or consumer trends. Calculates, or predicts, a future value by using existing values. Formula syntax and usage of the FORECAST and TREND functions in Microsoft Excel.
 +
|}
 +
|<!-- M -->
 +
| valign="top" |
 +
{| class="wikitable" style="width: 550px;"
 +
||
 +
<youtube>gHdYEZA50KE</youtube>
 +
<b>Excel - Time Series Forecasting - Part 1 of 3
 +
</b><br>This is Part 1 of a 3 part "Time Series Forecasting in Excel" video lecture. Be sure to watch Parts 2 and 3 upon completing Part 1.
 +
|}
 +
|}<!-- B -->

Revision as of 17:25, 13 September 2020

YouTube search... ...Google search

Microsoft Excel has a data mining add-in for making clusters. You can find instructions here. The wizard works with Excel tables, ranges or Analysis Survey Queries. This add-in can be customized, unlike the Detect Categories tool. In addition, the Detect Categories tool is limited to data from tables. Clustering in Excel | Statistics How To

HH1
BB1

HH2
BB2

HH3
BB3

HH4
BB4

Forecasting

...predict values

FORECAST.LINEAR & FORECAST.ETS Functions in Microsoft Excel 2016
The FORECAST.ETS predicts a future value based on historical values. It uses the Exponential Triple Smoothing (ETS) algorithm. The FORECAST.LINEAR function makes a prediction using a simple linear regression.

Introduction to Forecasting in Excel
Chandoo Learn how to use the awesome Forecasting feature of Microsoft Excel 2016 / 2019 / 365. We will learn about time series forecasting, seasonal fluctuations and confidence intervals too.

How to do forecasting with Excel 2016
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Microsoft Excel 2016 have a basket of tools to get the job done.

How to Use Statistical Functions for Forecasting in Microsoft Excel 2016 - Part 1
During this Microsoft Excel 2016 advanced training tutorial video, we will cover the statistical functions for forecasting. We will show examples using the functions SLOPE and INTERCEPT, FORECAST.LINEAR, and TREND. We will also explain what are independent and dependent variable.

Forecasting in Microsoft Excel and Trends Functions
You can use this function to predict future sales, cash and inventory, or consumer trends. Calculates, or predicts, a future value by using existing values. Formula syntax and usage of the FORECAST and TREND functions in Microsoft Excel.

Excel - Time Series Forecasting - Part 1 of 3
This is Part 1 of a 3 part "Time Series Forecasting in Excel" video lecture. Be sure to watch Parts 2 and 3 upon completing Part 1.

Retrieved from "https://primo.ai/index.php?title=Excel&oldid=16681"