Raw data for excel practice download : drive.google.com/open?id=1rfbqcNIb9BZQaVHccpYGY8D_…

This video is about how to do Predictive Analytics in MS Excel Spreadsheet 2016. Analytics drives business in efficient way. Four types of analytics are there currently. Predictive Analytics is part of four types of analytics. Predictive Analytics is not traditional analytics. Business people are using Predictive Analytics to know what will it happen, when will it happen, why will it happen in the business through historical data.

In this video, Two examples showed for Predictive Analytics. The first example is forecasting next year sales from last year sales using forecast techniques in MS Excel. The second example is creating regression analysis to find relationship between sales and incentive data and checking this data is statistically significant or not.

Excel tips and tricks for interview:    • Excel tips and tricks for interview | Begi...…
Advanced Excel tips and tricks for job:    • Advanced excel tips and tricks for intervi...…
Intermediate Excel tips and tricks for job:    • Intermediate excel tips and tricks for int...…
Basic Excel tips and tricks for job:    • Basic excel tips and tricks for interview ...…
Excel shortcuts and tricks:    • Excel shortcuts and tricks | excel shortcu...…

Data cleaning in excel data analytics:    • Data cleaning in data analytics | how to c...…
Data analysis in excel:    • Data analysis techniques tutorial in excel...…
Excel graphs and charts tutorial:    • Excel graphs and charts tutorials | How to...…
Creative excel charts tutorial:    • Creative excel graphs and charts tutorials...…
Data analysis excel formulas:    • Data analysis excel formulas and functions...…

Latest excel formulas:    • latest formula in excel | advance excel fo...…
Important excel formulas:    • Important excel formulas and functions | m...…
Simple vba code for beginners:    • Simple vba code in excel | Vba for beginne...…
Excel macro how to use:    • Visual basic in excel | macro in excel vba...…
Excel animation:    • Excel animation | vba code in excel | how ...…

AI in Excel:    • AI features in microsoft excel | how to us...…
Excel for auditors:    • Excel tutorial for Auditor | excel and adv...…
Latest excel features:    • Latest features in excel | microsoft 365 e...…
Python in excel:    • Python in excel tutorial | learn excel fro...…
Power pivot dax function tutorial:    • Dax formula in excel | power pivot formula...… .

#msexcel, #exceltutorial, #microsoftexceltutorial