Language: German

Data analysis with Excel for business and sales (video course)

Name: Data analysis with Excel for business and sales (video course)
Brand: TutKit.com
SKU: 852
Price: 29.95 EUR
Availability: InStock

Office, Business, Marketing & Sales 12 Videos · 2.3 h Video training · English

by Fabio Basler

What works? Where is there room for optimization? Find answers to these questions by correctly analyzing your figures in Excel. Using a practical case study from the financial business and sales sector as an example, you will learn how to apply important methods of inductive and descriptive statistics in this course. One training course, two hours, including exercises - trainer Fabio Basler will teach you how to read your data correctly!

Two-hour video course on data analysis with Excel using the example of financial sales
Practical learning based on tasks, solutions and a points system
Descriptive and inferential statistics: How to identify optimization potential in your figures
Among other things: Frequency distribution, correlation matrix, regression analysis, 1-SP test, confidence interval
Included: Excel raw data, collection of formulas and a summary

On the road to success! Recognize both strengths and weaknesses in your data to set up your business even better. Be smart now and start training right away!

content

12 Videos, 139 minutes

Introduction

2 Videos · 10 minutes

01 Open free of charge

Data analysis with Excel for business and sales: 1.1 What to expect in the course

An overview of the contents of the course

42 MB

02 Open free of charge

Data analysis with Excel for business and sales: 1.2 Introduction to the case study

Introduction to the case study

22 MB

Data analysis with Excel for business and sales: 1.1 What to expect in the course

3 min Open

42 MB

Data analysis with Excel for business and sales: 1.2 Introduction to the case study

7 min Open

22 MB

Descriptive case study part

6 Videos · 88 minutes

03 Open

Data analysis with Excel for business and sales: 2.1 Classification of data, frequency analysis, distribution functions

Calculation of a frequency distribution with data analysis function in Excel, graphical representation in approximating/empirical distribution function

55 MB

04 Open

Data analysis with Excel for business and sales: 2.2 Context measure analysis

Calculation of the contingency coefficient K* using the association measure Chi² in Excel

88 MB

05 Open

Data analysis with Excel for business and sales: 2.3 Correlation analysis and regression analysis

Correlation matrix via data analysis function, interpretation of content, modeling of linear functional relationship in Excel; interpretation of quality and statistical significance; calculation of regression function; quantitative evaluation of absolute/relative importance of regressors

82 MB

06 Open

Data analysis with Excel for business and sales: 2.4 Visualization time series

Graphical visualization of time series in Excel via line chart

18 MB

07 Open

Data analysis with Excel for business and sales: 2.5 Determining trends after exponential smoothing

Calculation of trend function, forecast estimate

20 MB

08 Open

Data analysis with Excel for business and sales: 2.6 Determining the trend function

Calculation of trend function, forecast estimate

28 MB

Data analysis with Excel for business and sales: 2.1 Classification of data, frequency analysis, distribution functions

17 min Open

55 MB

Data analysis with Excel for business and sales: 2.2 Context measure analysis

29 min Open

88 MB

Data analysis with Excel for business and sales: 2.3 Correlation analysis and regression analysis

23 min Open

82 MB

Data analysis with Excel for business and sales: 2.4 Visualization time series

5 min Open

18 MB

Data analysis with Excel for business and sales: 2.5 Determining trends after exponential smoothing

6 min Open

20 MB

Data analysis with Excel for business and sales: 2.6 Determining the trend function

8 min Open

28 MB

Inductive case study part

4 Videos · 41 minutes

09 Open

Data analysis with Excel for business and sales: 3.1 1-SP test case for the expected value

Execution of statistical parameter test, decision on validity/invalidity of the hypothesis

53 MB

10 Open

Data analysis with Excel for business and sales: 3.2 1-SP test case for the expected value - change in result

Modeling the significance level to change the content of the result of the hypothesis decision

19 MB

11 Open

Data analysis with Excel for business and sales: 3.3 2-sided confidence interval

Calculation of interval limits of a 2-sided confidence interval based on samples in Excel

24 MB

12 Open

Data analysis with Excel for business and sales: 3.4 Two-sample F-test

Execution of statistical parameter test, decision on validity/invalidity of the hypothesis

30 MB

Data analysis with Excel for business and sales: 3.1 1-SP test case for the expected value

17 min Open

53 MB

Data analysis with Excel for business and sales: 3.2 1-SP test case for the expected value - change in result

6 min Open

19 MB

Data analysis with Excel for business and sales: 3.3 2-sided confidence interval

8 min Open

24 MB

Data analysis with Excel for business and sales: 3.4 Two-sample F-test

10 min Open

30 MB

Details of the content

Optimization is the order of the day? Then start Excel and your data analysis ...
Some things feel good, some feel bad. But how is your company actually doing? Learn important methods of descriptive and inductive statistics now so that you can work with clear facts in the future. Start this two-hour video course on data analysis with Excel now !

Work materials included: Practise data analysis with Excel straight away

The training lets you work hands-on right from the start. Open the Excel spreadsheet provided with all the raw data you need to practise and understand what you've been shown. If you get stuck, pause the tutorial, go back a step or take a look at the included formulas and summary. A points system helps you to monitor your own learning success. In this way, what you have learned quickly turns into knowledge - which you can use for your own purposes tomorrow.

Ideally suited for controlling, for students and all optimization enthusiasts!

Whether for your studies or your job - this video course is aimed at anyone who sees much more in Microsoft Excel than simple lists and spreadsheets. Link your data skillfully and methodically until you can derive target-oriented recommendations for action from it.

Do you want to improve your company's sales? Are you looking for an effective way to get into controlling? Do you see huge columns of figures as the key to successful optimization? - Then welcome to this Excel training course!

A real-life example: data analysis in financial sales

The case study on which you will carry out your data analysis exercises relates to an investment bank in which three teams are responsible for sales. You now have various data from the last 100 weeks that you need to analyze. Your learning curve towards comprehensive data analysis includes the following aspects:

Descriptive statistics: classification of data, frequency analysis, distribution functions, correlation analysis, regression analysis, visualization of time series, trend determination after exponential smoothing, determination of trend function
Inductive statistics: statistical parameter tests, 1-SP test case for the expected value, 2-sided confidence interval, two-sample F-test

Note

Usable with: Microsoft Excel
Licence: private and commercial Rights of use

Created with love by

Fabio Basler

My name is Fabio Basler and I have been working with Microsoft Excel for years. Thanks to the daily use in my job as a business unit controller, I now know almost all the functions and shortcuts in Excel. In addition, I ran a tutorial for three semesters in which I taught 30 to 40 students statistics. Thanks to my intensive involvement with the subject, I now know all the tricks of the trade! I have already helped countless students to successfully complete the exam and prepared them for their day-to-day work with MS Excel. My goal on TutKit.com is to share all my knowledge in data analysis, Excel and statistics, with targeted case studies that include real-life examples.

Products

Comment now „Data analysis with Excel for business and sales (video course)“

Other users are also interested

Microsoft Copilot (Video-Training) – mit KI effektiver arbeiten

Go to content To Microsoft Copilot (video training): working effectively with AI

Microsoft Copilot (video training): working effectively with AI

This saves you time and effort!

5 hours 7 minutes

Corporate Design "Digital": Templates for programmers and web designers

Go to content To Corporate Design Digital: Templates for Webdesigners

Corporate Design Digital: Templates for Webdesigners

With flyer, business card & Co.

18 contents

Go to content To Paid Ads for LinkedIn, Google & Facebook with ChatGPT (Tutorial)

Paid Ads for LinkedIn, Google & Facebook with ChatGPT (Tutorial)

Create, set up & optimize online advertising

3 hours 20 minutes

Excel: Tips & Tricks - 40 ingenious best-of-hacks for effective work

Go to content To Excel: Tips & tricks | 40 best-of hacks for effective working

Excel: Tips & tricks | 40 best-of hacks for effective working

Faster results in your tables

1 hour 15 minutes

Data analysis with Excel for business and sales (video course)

12 Videos, 139 minutes

Introduction

Data analysis with Excel for business and sales: 1.1 What to expect in the course

Data analysis with Excel for business and sales: 1.2 Introduction to the case study

Data analysis with Excel for business and sales: 1.1 What to expect in the course

Data analysis with Excel for business and sales: 1.2 Introduction to the case study

Descriptive case study part

Data analysis with Excel for business and sales: 2.1 Classification of data, frequency analysis, distribution functions

Data analysis with Excel for business and sales: 2.2 Context measure analysis

Data analysis with Excel for business and sales: 2.3 Correlation analysis and regression analysis

Data analysis with Excel for business and sales: 2.4 Visualization time series

Data analysis with Excel for business and sales: 2.5 Determining trends after exponential smoothing

Data analysis with Excel for business and sales: 2.6 Determining the trend function

Data analysis with Excel for business and sales: 2.1 Classification of data, frequency analysis, distribution functions

Data analysis with Excel for business and sales: 2.2 Context measure analysis

Data analysis with Excel for business and sales: 2.3 Correlation analysis and regression analysis

Data analysis with Excel for business and sales: 2.4 Visualization time series

Data analysis with Excel for business and sales: 2.5 Determining trends after exponential smoothing

Data analysis with Excel for business and sales: 2.6 Determining the trend function

Inductive case study part

Data analysis with Excel for business and sales: 3.1 1-SP test case for the expected value

Data analysis with Excel for business and sales: 3.2 1-SP test case for the expected value - change in result

Data analysis with Excel for business and sales: 3.3 2-sided confidence interval

Data analysis with Excel for business and sales: 3.4 Two-sample F-test

Data analysis with Excel for business and sales: 3.1 1-SP test case for the expected value

Data analysis with Excel for business and sales: 3.2 1-SP test case for the expected value - change in result

Data analysis with Excel for business and sales: 3.3 2-sided confidence interval

Data analysis with Excel for business and sales: 3.4 Two-sample F-test

Details of the content

Work materials included: Practise data analysis with Excel straight away

Ideally suited for controlling, for students and all optimization enthusiasts!

A real-life example: data analysis in financial sales

Comment now „Data analysis with Excel for business and sales (video course)“

You might also like