Difference between revisions of "Excel"

From
Jump to: navigation, search
m
m
Line 31: Line 31:
 
|}
 
|}
 
|}<!-- B -->
 
|}<!-- B -->
−
{|<!-- T -->
+
 
−
| valign="top" |
+
 
−
{| class="wikitable" style="width: 550px;"
 
−
||
 
−
<youtube>4jfgWHQYYGU</youtube>
 
−
<b>Text Analytics with [[Microsoft]] Excel | How to create word cloud in [[Microsoft]] Excel?
 
−
</b><br>Take the first step in learning to do analytics based on text. Although users would prefer [[Python]] for text analytics in AI or ML, [[Microsoft]] Excel with its dynamic array feature brings in new functionalities with which you can analyze thousands of large passages. Although [[Microsoft]] Excel does not have a word cloud, we can prepare something close to it using the tree map.
 
−
|}
 
−
|<!-- M -->
 
−
| valign="top" |
 
−
{| class="wikitable" style="width: 550px;"
 
−
||
 
−
<youtube>ID2</youtube>
 
−
<b>HH2
 
−
</b><br>BB2
 
−
|}
 
−
|}<!-- B -->
 
 
= Regression Analysis =
 
= Regression Analysis =
 
{|<!-- T -->
 
{|<!-- T -->
Line 156: Line 141:
 
<b>How to Use Statistical Functions for Forecasting in [[Microsoft]] Excel 2016 - Part 1
 
<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><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 -->
 +
 +
= Text Analytics =
 +
{|<!-- T -->
 +
| valign="top" |
 +
{| class="wikitable" style="width: 550px;"
 +
||
 +
<youtube>4jfgWHQYYGU</youtube>
 +
<b>Text Analytics with [[Microsoft]] Excel | How to create word cloud in [[Microsoft]] Excel?
 +
</b><br>Take the first step in learning to do analytics based on text. Although users would prefer [[Python]] for text analytics in AI or ML, [[Microsoft]] Excel with its dynamic array feature brings in new functionalities with which you can analyze thousands of large passages. Although [[Microsoft]] Excel does not have a word cloud, we can prepare something close to it using the tree map.
 +
|}
 +
|<!-- M -->
 +
| valign="top" |
 +
{| class="wikitable" style="width: 550px;"
 +
||
 +
<youtube>ID2</youtube>
 +
<b>HH2
 +
</b><br>BB2
 +
|}
 +
|}<!-- B -->
 +
 +
== Text Analytics with Azure ==
 +
{|<!-- T -->
 +
| valign="top" |
 +
{| class="wikitable" style="width: 550px;"
 +
||
 +
<youtube>IwLhBPayQk4/youtube>
 +
<b>Text Analytics with [[Microsoft]]
 +
</b><br>An older webinar of ours, but worth the watch. The desire to enhance the customer experience and elevate customer lifetime value is a key part of many firm strategies. Often times, the information needed to make value-adding changes is trapped in the text inside documents and comes in the form of customer surveys, call logs, social media posts, and other text.  Due to changes in the technology landscape with tools like Hadoop, R, and pre-built solutions in Microsoft Azure, many of the traditional barriers for text analytics have been reduced or eliminated.  Watch this webinar to learn how to create text analytics solutions using the [[Microsoft]] Azure ecosystem, including recommended architectures and examples of text analytics solutions ranging from easy to complex.
 +
|}
 +
|<!-- M -->
 +
| valign="top" |
 +
{| class="wikitable" style="width: 550px;"
 +
||
 +
<youtube>obMtu9bIhLA</youtube>
 +
<b>AI Solutions with [[Microsoft]] Azure Natural Language Processing | Synergetics Learning
 +
</b><br>In this virtual meetup session, explain how [[Microsoft]] Azure Natural Language Processing (NLP) based offerings for facilitating Text Analytics, Sentiment analysis, Language detection and Named Entity Recognition Solutions is delivered.
 
|}
 
|}
 
|}<!-- B -->
 
|}<!-- B -->

Revision as of 18:38, 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

Module 1: Data Analysis in Microsoft Excel
This video is part of the Analyzing and Visualizing Data with Excel course available on EdX. To sign up for the course, visit: http://aka.ms/edxexcelbi

Data Analysis With Microsoft Excel Learning Roadmap
David Langer Data analysis with Microsoft Excel is accessible to anyone with the proper learning roadmap. Whether you are business pro looking to use data to have more impact, or an aspiring analytics or data science pro, this following this roadmap will give you serious data skills.


Regression Analysis

Multivariate regression in Microsoft Excel
This video discusses how to undertake a multivariate regression in Microsoft Excel. It also discusses how to calculate predicted values using that regression. The video uses the example of predicting exchange rate changes (here, looking at the USD/AUD exchange rate). It looks at predicting forex changes as a function of interest rate, inflation rate, and GDP growth differentials (i.e., as implied using purchasing power parity and interest rate parity).

Regression analysis in Microsoft Excel
This video is a part of work shop organized by REST Society for Research International (RSRI). RSRI conducts various workshops, seminars, conference and student events. If you are interested to join any of the above events, kindly check our society website to know about upcoming events. for more details website: www.rsri.org.in E-mail: rsrisociety@gmail.com

<bMultiple Regression in Microsoft Excel
Multiple Regression in Excel in a nutshell. Focusing on Excel functionality more than presentation of regression theory.

Microsoft Excel Regression Analysis Output Explained
Overview of the Excel regression analysis output.

Ch 12: Interpreting Regression Analysis in Microsoft Excel
Business Statistics

Microsoft Excel 2016 Regression Analysis
Using Data Analysis Toolpak Correlation analysis and interpreting the results

Excel - Forecasting

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.

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.

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.

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.

Text Analytics

Text Analytics with Microsoft Excel | How to create word cloud in Microsoft Excel?
Take the first step in learning to do analytics based on text. Although users would prefer Python for text analytics in AI or ML, Microsoft Excel with its dynamic array feature brings in new functionalities with which you can analyze thousands of large passages. Although Microsoft Excel does not have a word cloud, we can prepare something close to it using the tree map.

HH2
BB2

Text Analytics with Azure

AI Solutions with Microsoft Azure Natural Language Processing | Synergetics Learning
In this virtual meetup session, explain how Microsoft Azure Natural Language Processing (NLP) based offerings for facilitating Text Analytics, Sentiment analysis, Language detection and Named Entity Recognition Solutions is delivered.

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