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: package_852
Price: 29.95 EUR
Availability: InStock

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

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

3 min

An overview of the contents of the course

42 MB To the text tutorial: Data analysis with Excel in financial sales

02 Open free of charge

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

7 min

Introduction to the case study

22 MB To the text tutorial: Financial distribution and Excel: Practical data analysis

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

17 min

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

55 MB To the text tutorial: Excel data analysis: Create frequency distribution

04 Open

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

29 min

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

88 MB To the text tutorial: Calculate contingency coefficient in Excel

05 Open

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

23 min

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 To the text tutorial: Data analysis in Excel: Understanding correlation and regression

06 Open

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

5 min

Graphical visualization of time series in Excel via line chart

18 MB To the text tutorial: Visualization of revenue data in Excel

07 Open

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

6 min

Calculation of trend function, forecast estimate

20 MB To the text tutorial: Trend analysis in Excel for data analysis

08 Open

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

8 min

Calculation of trend function, forecast estimate

28 MB To the text tutorial: Forecasting sales figures in Excel

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

17 min

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

53 MB To the text tutorial: Conduct 1-sample t-test for the expected value in Excel

10 Open

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

6 min

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

19 MB To the text tutorial: Data analysis with Excel - do not reject the null hypothesis

11 Open

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

8 min

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

24 MB To the text tutorial: Calculation of the two-sided confidence interval in Excel

12 Open

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

10 min

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

30 MB To the text tutorial: Conducting a two-sample F-test in Excel

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

Sticker & Pop – 100 Photoshop Styles for Promotional Graphics

−40% International price

Go to content To Sticker & Pop: Photoshop Styles for Promotional Graphics

Sticker & Pop: Photoshop Styles for Promotional Graphics

5 sets of 20 layer styles each · ASL and editable PSD samples

100 contents

Printable Advent calendar: little doors, numbers, vouchers, boxes

new

−40% International price

Go to content To Printable Advent Calendar – Kit with 7 Template Sets

Printable Advent Calendar – Kit with 7 Template Sets

7 template sets in 4 design lines – A4 PDF with crop marks, plotter SVG, JPG/PNG, PPTX, DOCX and XLSX

200 contents

The big infographic bundle for technology & B2B

−40% International price

Go to content To Infographic templates & diagrams for technology & B2B | TutKit

Infographic templates & diagrams for technology & B2B | TutKit

48 editable chart templates in SVG, PDF, EPS, PNG, and PowerPoint – in under a minute in the customer’s corporate identity

48 contents

Briefing templates for agencies: 5 fillable PDF questionnaires

−40% International price

Go to content To Briefing Templates for Agencies: 5 Fillable PDFs

Briefing Templates for Agencies: 5 Fillable PDFs

5 sheets of 4 A4 pages each as a fillable PDF – with filling examples and a guide for Acrobat and InDesign

5 contents

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

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

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

Details of the content

Optimization is the order of the day? Then start Excel and your data analysis ...

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