Introduction to Data Analytics with Microsoft Excel

Partner: Udemy
Affiliate Name:
Area:
Description: RequirementsMicrosoft Office 365 or Excel 2010 - 2019Mac users Pivot Visuals may look slightly different to the examples shownBasic experience with Excel functionality is a bonus but not requiredDescriptionWelcome to the world of Data Analytics, voted the sexiest job of the 21st Century.In this expertly crafted course, we will cover a complete introduction to data analytics using Microsoft Excel, you will cover the concepts, the value and practically apply core analytical skills to turn data into insight and present as a story.Look at this as the first step in becoming a fully-fledged Data ScientistCourse OutlineThe course covers each of the following topics in detail, with datasets, templates and 17 practical activities to walk through step by step:What is Data AnalyticsWhy Do We Need It in this new worldThinking about Data, how it works in the lad v how it works in the wildQualitative v Quantitative data and their importanceFinding Your DataHow to find Sources of Data and what they containReviewing the Dataset and getting hands onAnalysing Your DataMean, Modes, Median and RangeNormal and Non normal Data and its impacts to predictabilityWhat is an Outlier in our data and how do we removeDistribution and Histograms and why they are importantStandard Deviation and Relative Standard Deviation, why variance is the enemyWhat are Run and Control charts and what do they tell us?Working With Pivot TablesHow the Pivot Builder WorksSetting Our HeadersWorking with calculated fieldsSo
Category: Office Productivity > Microsoft > Excel Analytics
Partner ID:
Price: 19.99
Commission:
Source: Impact
Go to Course