Microsoft Excel: Practical MS Excel + MS Excel data analysis

Description :

Warning: Illegal string offset 'ID' in /home/onlinecou/public_html/wp-content/plugins/advanced-custom-fields-pro/includes/api/api-field.php on line 890

Warning: Illegal string offset 'key' in /home/onlinecou/public_html/wp-content/plugins/advanced-custom-fields-pro/includes/api/api-field.php on line 891

Warning: Illegal string offset 'label' in /home/onlinecou/public_html/wp-content/plugins/advanced-custom-fields-pro/includes/api/api-field.php on line 892

Warning: Illegal string offset 'name' in /home/onlinecou/public_html/wp-content/plugins/advanced-custom-fields-pro/includes/api/api-field.php on line 893

Warning: Illegal string offset 'menu_order' in /home/onlinecou/public_html/wp-content/plugins/advanced-custom-fields-pro/includes/api/api-field.php on line 894

Warning: Illegal string offset 'parent' in /home/onlinecou/public_html/wp-content/plugins/advanced-custom-fields-pro/includes/api/api-field.php on line 895

Warning: Illegal string offset 'key' in /home/onlinecou/public_html/wp-content/plugins/advanced-custom-fields-pro/includes/api/api-field.php on line 899
Excel A-Z + Data Analytics Theory & Application (Accredited) course is 2 courses in 1. In the first part, you will learn how to work with Excel in general. Among other things, you will learn: Pivot charts and pivot tables Nested IF functions AND function Combining IF & AND function Cross sheet referencing Absolute and relative cell references Histograms Pareto charts Multiple line charts Bar charts Chart theory In part two, you will learn the theory of statistical techniques for data analysis. Subsequently, you learn how to execute these theories in Excel. The tools of data analytics which you will learn include for instance: Standard deviation Single OLS regression Multiple OLS regression Nonlinear regression