Essential Excel For Business Statistics and Data Analytics

Overview

Applied Statistical Modelling For Business Cases With Excel What you'll learn:

Introduction to Excel and navigating around the interfaceReading in external data (including data from webpages) into ExcelDerive insights from the data via grouping and pivotingDescribe your data (descriptive statistics, including identifying the best statistic)Data visualisation through chartsInferential statistics in Excel (including hypothesis testing)Regression modelling in Excel If You Are…..A business intelligence (BI) practitionerData analystInterested in gaining insights from data (especially financial, geographic, demographic and socio-economic data)Excel Is Your Friend for Common Business Data Analysis and Statistics TasksI’m Minerva Singh, and I’m an expert data scientist. I’ve graduated from 2 of the best universities in the world; MPhil from Oxford University (Geography and Environment), and a PhD holder in Computational Ecology from Cambridge University.

I have several years of experience in data analytics and data visualization. My course aims to help you start with no prior/limited exposure to data analysis and become proficient in undertaking common business statistical analysis with Microsoft Excel, including reading data from different sources and building data visualisations.

You don't need any prior exposure to data analytics and visualization to get started with MS Excel. So if you have struggled with Excel, worry no more.

After finishing my course you will be able to:

Read in and clean messy data in MS ExcelBasic webscraping with ExcelCarry out common business data analytic tasks including filtering and pivotingCarry out pre-processing and data summarization to glean insights from dataDevelop powerful visualisations with MS Excel Learn important statistical techniques, including hypothesis testing and inferential statistics Carry out common statistical analysis using MS Excel-including correlations and regression analysisInclude qualitative attributes in your regression models and interpret the resultsIf you take this course and it ever feels like a disappointment, feel free to ask for a refund within 30 days of your purchase, and you would get it at once. Become an expert in Data Analytics and Visualization with a new and powerful tool by taking up this course today!

Syllabus

• Introduction to Excel for Business Statistics
Overview of Excel interface and functionalities
Customizing the Excel workspace
Basic Excel operations and formulas
• Data Management Techniques
Importing and exporting data
Data cleaning and preparation
Handling large datasets efficiently
• Descriptive Statistics in Excel
Calculating measures of central tendency
Analyzing measures of dispersion
Using data visualization tools for descriptive analysis
• Advanced Excel Functions for Data Analysis
Logical functions (IF, AND, OR)
Lookups and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
Text functions for data manipulation
• Data Visualization and Dashboarding
Creating and customizing charts and graphs
Introduction to PivotTables and PivotCharts
Designing interactive dashboards
• Statistical Analysis Tools in Excel
Conducting hypothesis tests
Correlation and regression analysis
Analyzing variance (ANOVA)
• Business Data Modeling
Introduction to financial modeling
Scenario and sensitivity analysis using Excel tools
Forecasting techniques and trend analysis
• Automation and Macros in Excel
Introduction to Excel macros
Recording and editing macros
Basic principles of Excel VBA (Visual Basic for Applications)
• Case Studies and Practical Applications
Real-world business cases using Excel
Projects on data-driven decision-making
Group assignments for collaborative learning
• Course Review and Final Assessment
Summary of key concepts
Final project presentation
Feedback and future learning paths

Taught by

Minerva Singh

Subjects

Business