Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Hier kannst du dein Wissen und Können an Millionen von Teilnehmer:innen in aller Welt weitergeben und damit richtig Geld verdienen!
Weitere Infos
Dein Einkaufswagen ist leer.
Weiter einkaufen
Essential Excel For Business Statistics and Data Analytics
Bewertung: 4,3 von 5(187 Bewertungen)
1.082 Teilnehmer:innen
Erstellt vonMinerva Singh
Zuletzt aktualisiert 11/2025
Englisch

Das wirst du lernen

  • Introduction to Excel and navigating around the interface
  • Reading in external data (including data from webpages) into Excel
  • Derive insights from the data via grouping and pivoting
  • Describe your data (descriptive statistics, including identifying the best statistic)
  • Data visualisation through charts
  • Inferential statistics in Excel (including hypothesis testing)
  • Regression modelling in Excel

Kursinhalt

6 Abschnitte56 Lektionen3 Std. 39 Min. Gesamtdauer
  • Whats This Course About?1:54
  • Data and Code0:03
  • Introduction to Different Data Types3:37
  • Say Hello To the Excel Interface6:18
  • Excel Templates4:36
  • Rock The Ribbon1:51

Anforderungen

  • Access to Microsoft Excel
  • Interest in data processing and analysis
  • Developing data visualisations in Excel
  • Statistical modelling in Excel

Beschreibung

If You Are…..

  • A business intelligence (BI) practitioner

  • Data analyst

  • Interested in gaining insights from data (especially financial, geographic, demographic and socio-economic data)

Excel Is Your Friend for Common Business Data Analysis and Statistics Tasks

I’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:


  1. Read in and clean messy data in MS Excel

  2. Basic webscraping with Excel

  3. Carry out common business data analytic tasks including filtering and pivoting

  4. Carry out pre-processing and data summarization to glean insights from data

  5. Develop powerful visualisations with MS Excel

  6. Learn important statistical techniques, including hypothesis testing and inferential statistics

  7. Carry out common statistical analysis using MS Excel-including correlations and regression analysis

  8. Include qualitative attributes in your regression models and interpret the results

If 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!

Für wen eignet sich dieser Kurs:

  • Data analysts
  • Business and management students
  • Students and professionals seeking to use Excel for data tasks
  • Those looking to use Excel for basic data visualisations
  • Those looking to use Excel for basic statistical modelling