Downloadable Excel courses on various topics from Tutkit Tutorials (save 50%)

29.95 Original price was: €29.95.17.95Current price is: €17.95.

SKU: tutkit-ms-microsoft-excel-tutorials Categories: ,

Description

Improve your Excel skills with downloadable courses: from basics to advanced techniques.

After purchasing this deal, visit the website listed on the voucher to complete the redemption.

Want to take your Excel skills to the next level? Tutkit Tutorials offers a diverse selection of downloadable Excel courses to help you improve your skills and work more efficient. From beginner basics to advanced techniques for data analysis, statistics, and data visualization, the courses cover a range of topics, including business, sales, controlling, and office organization. Discover the high-quality courses now and start your journey to Excel excellence today!

Downloadable online course Excel basics – Introduction for beginners

Details

  • Course type: via download
  • Contents: 3 hours of video material
  • License: private and commercial usage rights
  • Bonus: work includes materials
  • Further information

Contents

  • 32 lessons in a three-hour introduction to using Microsoft Excel
  • All the essential Excel basics: lists, references, formatting, formula, calculations
  • Use the program’s shortcuts and work efficiently and save time from the start.
  • A practical course, perfect for beginners: collecting, detecting, and clearly presenting data.
  • Created by:

Modules

  • Course introduction
    • Excel Basics – Introduction for Beginners: 01 Welcome
  • Excel Basics – Introduction for Beginners: 02 What can Excel do?
  • Basics
    • Excel Basics – Introduction for Beginners: 03 The User Interface
    • Excel Basics – Introduction for Beginners: 04 Files: Create, Save and Auto Restore
    • Excel Basics – Introduction for Beginners: 05 Zoom Mode Customize
    • Excel Basics – Introduction for Beginners: 06 Cell Determination
    • Excel Basics – Introduction for Beginners: 07 Inputs of Cells
    • Excel Basics – Introduction for Beginners: Customize and Connect 08 Cells
    • Excel Basics – Introduction for Beginners: 09 Automatic filling
    • Excel Basics – Introduction for Beginners: Create 10 Own Filling Lists
    • Excel Basics – Introduction for Beginners: 11 The Date and Time trick
  • Recognition with Excel
    • Excel Basics – Introduction for Beginners: 12 What do you mean references? (relative cell references)
    • Excel basics – Introduction for beginners: 13 calculators
    • Excel Basics – Introduction for Beginners: 14 How does Excel think about references? Copy formula by pulling!
    • Excel Basics – Introduction for Beginners: 15 percent
    • Excel Basics – Introduction for Beginners: View 16 Formulas
    • Excel Basics – Introduction for Beginners: 17 Absolute Cell Covers
    • Excel basics – Introduction for beginners: 18 work with relative and absolute cell references
    • Excel Basics – Introduction for Beginners: 19 Works with 3D Covers in Multiple Leaves
    • Excel Basics – Introduction for Beginners: Connect 20 Covers from Other Excel Files
  • Formatting: rows and columns
    • Excel Basics – Introduction for Beginners: 21 Insert and Delete rows and columns
    • Excel Basics – Introduction for Beginners: 22 Move and Copy Lines and Columns
    • Excel Basics – Introduction for Beginners: 23 Rows and Columns
    • Excel Basics – Introduction for Beginners: 24 Grouping and members with partial result
    • Excel Basics – Introduction for Beginners: Format 25 Cells: Fonts and Font Sizes
    • Excel Basics – Introduction for Beginners: Format 26 Cells: Frames
    • Excel Basics – Introduction for Beginners: Format 27 Cells: Fill Color and Highlight
    • Excel Basics – Introduction for Beginners: 28 Text, Number and Date Formatting
    • Excel Basics – Introduction for Beginners: 29 Conditional Formatting: Green, Red, Hooks
  • SVERWEIS: Search and output
    • Excel Basics – Introduction for Beginners: 30 SVERWEIS: Basics
    • Excel Basics – Introduction for Beginners: 31 SVERWEIS with COMPARISON, the dynamic search
  • Bonuses
    • Excel Basics – Introduction for Beginners: 32 Printing with Excel: Tips & Tricks

Data analysis with Excel for Business and Sales (Video Course)

Details

  • Course type: by download
  • Content: 2 hours Video footage
  • License: private and commercial usage rights
  • Bonus: including work material
  • Further information

Contents

  • Two-hour video course for data analysis using Excel for example
  • Practical learning based on tasks, solutions and a score system
  • Descriptive and closing statistics: In your figures, you can see optimization potential among others: frequency distribution, correlation matrix, regression analysis, 1-SP test, confidence interval
  • Includes: Excel raw data, formula collection and a summary

Modules

  • Introduction
    • Data analysis with Excel for Business and Sales: 1.1 This is expected in the course
    • Data analysis with Excel for Business and Sales: 1.2 Introduction to 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
    • 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 Trend determination after exponential smoothing
    • Data analysis with Excel for Business and Sales: 2.6 Determination Trend Function
  • Inductive case study part
    • Data analysis with Excel for Business and Sales: 3.1 1-SP test case for expected value
    • Data analysis with Excel for Business and Sales: 3.2 1-SP test case for expected value – Result change
    • Data analysis with Excel for Business and Sales: 3.3 2-page confidence interval
    • Data analysis with Excel for Business and Sales: 3.4

Statistics with Excel – learn and practice practically

Details

  • Course type: by download
  • Content: 5 hrs. Video footage
  • License: private and commercial usage rights
  • Bonus: including work material
  • Further information

Contents

  • Statistics with Excel on three practical case examples
  • Learning and practicing in practical terms: learning control, formula collection, raw data and solutions
  • Descriptive and inductive statistics methods in more than 4.5 hours viewed by Fabio Basler
  • Among other things: time series, forecasts, distribution tests, average and scattering, normal distribution tests

Modules

  • Introduction
    • Statistics with Excel: 1.1 What will expect you
    • Statistics with Excel: 1.2 Introduction Case Study Collection
  • Case study Portfolio management
    • Statistics with Excel: 2.1 Introduction to the case study Portfolio Management
    • Statistics with Excel: 2.2 Average analysis in Excel
    • Statistics with Excel: 2.3 Scatter analysis in Excel
    • Statistics with Excel: 2.4 Correlation Analysis in Excel (Part 1)
    • Statistics with Excel: 2.5 Correlation Analysis in Excel (Part 2)
    • Statistics with Excel: 2.6 Rangkorrelationsanalyse in Excel
    • Statistics with Excel: 2.7 Boxplot Analysis in Excel
    • Statistics with Excel: 2.8 Data Classification and Frequency Analysis in Excel
    • Statistics with Excel: 2.9 Regression Analysis in Excel
    • Statistics with Excel: 2.10 Chi Quartrate Adaptation Test for Normal Distribution in Excel
  • Case study automotive suppliers
    • Statistics with Excel: 3.1 Introduction to the Case Study Automotive Suppliers
    • Statistics with Excel: 3.2 Visualization of the time series in Excel
    • Statistics with Excel: 3.3 Determining trend function and forecast estimation in Excel
    • Statistics with Excel: 3.4 Trend determination after exponential smoothing in Excel
    • Statistics with Excel: 3.5 Error Analysis and Quality Assessment in Excel
    • Statistics with Excel: 3.6 Contingence Analysis in Excel
  • Case study Biotechnology
    • Statistics with Excel: 4.1 Introduction to the case study Biotechnology
    • Statistics with Excel: 4.2 1-SP test for the expected value with known variance in Excel
    • Statistics with Excel: 4.3 1-SP test for the share value in Excel
    • Statistics with Excel: 4.4 1-SP test for the expected value with unknown variance in Excel
    • Statistics with Excel: 4.5 1-SP test for variance in Excel
    • Statistics with Excel: 4.6 Two-Samples-t-Test in Excel
    • Statistics with Excel: 4.7 2-SP test for the difference of two share values in Excel
    • Statistics with Excel: 4.8 Two-Sample F Test in Excel
  • Outro
    • Statistics with Excel: 5 Outro

Downloadable Excel Course for Controlling and Sales: assortment list, units, currency & Coal

Details

  • Course type: by download
  • Content: 3rd hour Video footage
  • License: private and commercial usage rights
  • Bonus: including work material
  • Further information

Contents

  • Course to Excel with tips and tricks for accounting, controlling and sales
  • Use the Excel functions to avoid unnecessary errors
  • Calculate shipping costs by weight and prices
  • Units and currencies: to convert units and to take account of current exchange rates
  • Make comparisons with SVERWEIS, COMPARISON, INDEX and matrix function
  • Learn how to work efficiently with very large and negative numbers
  • Especially helpful for creating product and assortment lists, for controlled data entry
  • Created by: René Fürst

Modules

  • Intro
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 1 Intro
  • Data input and comparisons
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 2.1 Control data entry more efficiently
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 2.2 Data check for cells
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 2.3 Keyboard mode “Rolling”
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 2.4 Compare contents of different worksheets
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 2.5 Double values prevent
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 2.6 Automatic subtotals
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 2.7 Compare two Excel tables
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 2.8 Compare values in a reference table
  • Products & Commerce
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 3.1 cell names
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 3.2 Reduce images
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 3.3 Import current exchange rates directly to Excel
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 3.4 Calculate shipping costs
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 3.5 Classification and Multiple Form
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 3.6 Commercial round
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 3.7 Highlight double values
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – Use 3.8 units
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 3.9 square meters and cubic meters
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 3.10 color code formatting of cells
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 3.11 Conversion of units
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 3.12 Format currencies to the left and right flush
  • Working with numbers, index, SVerweis and comparison
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 4.1 Format large numbers

    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 4.2 Show numbers with leading zeros

    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 4.3 SVERWEIS over multiple columns

    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 4.4 numbers to separate parts

    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 4.5 Output last numbers of a large number

    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 4.6 order of a list

    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 4.7 Displays or hides zero values

    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 4.8 Determine maximum and smallest values

    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 4.9 Replace formulas with numerical values

    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 4.10 SVERWEIS or INDEX/Comparative

    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 4.11 Expand SVERWEIS search function

  • Tips & tips Tricks: Work faster with Excel
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 5.1 Define names for formulas
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 5.2 Add new quick tool
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 5.3 surveillance windows
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 5.4 protect cells from overwriting
    • Excel Course for Controlling and Sales: assortment list, units, currency & Co – 5.5 highlighting deadlines

Downloadable Excel training for more efficiency in the office: Calendar, Organigram & Coal

Details

  • Course type: by download
  • Content: 3rd hour Video footage
  • License: private and commercial usage rights
  • Bonus: including work material
  • Further information

Contents

  • Three-hour Excel training: How to use the Excel functions for more efficiency in the office
  • Individualizer Excel: use coloured spreadsheets & Grids, create chart templates, remove metadata, fix columns and rows
  • Excel Calendar: Create an annual calendar, calculate the calendar week and a date in the future, let you show dates
  • Office organization: calculate working hours, create intelligent organigrams, PDF export, create an interactive search function, add help texts for cells
  • Created by: René Fürst

Modules

  • Intro
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 1 Intro
  • Individualized and efficient work
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 2.1 Excel different start
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 2.2 Custom Views
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 2.3 Use color grid lines
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 2.4 Colorful spreadsheets
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 2.5 Fixing columns and rows
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 2.6 Reusable Chart Templates
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 2.7 Prevent automatic hyperlinks
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 2.8 Metadata in Office Files
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 2.9 Increase number of reverse steps
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 2.10 Repair defective workbook
  • Organization with the calendar
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 3.1 Flexible annual calendar
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 3.2 weekends in the calendar
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 3.3 Remembering an anniversary
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 3.4 Working with calendar weeks
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 3.5 calendar weeks with annual information
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 3.6 Calculate a future date
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 3.7 Calculate a future date with special times
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 3.8 Coloring dates
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 3.9 Excel calendar only with working days
    • Excel training for more efficiency in the office: Calendar, Organigram & Convert Co – 3.10 hours in minutes
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 3.11 Correctly calculate negative hours and minutes
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 3.12 Useful birthday list
  • Organization made easy
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 4.1 hours correctly add to work time recording
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 4.2 Working hours with industrial time
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 4.3 Create your organization with SmartArt
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 4.4 Creating Smart Organigram without Smart Art
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 4.5 images in tables
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 4.6 Save workbooks in PDF
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 4.7 Texts through, high and low
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 4.8 Columns and rows of a table swap with the transpose function
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 4.9 Sort and filter the table
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 4.10 Insert Excel tables in Word documents
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 4.11 Insert Interactive Search Field into Table Sheet
  • Tips and tricks for efficient organizing
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 5.1 Use auto correction
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 5.2 Cell auxiliary texts
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 5.3 Working with the “Excel Camera”
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – hide 5.4 rows and columns
    • Excel training for more efficiency in the office: Calendar, Organigram & Co – 5.5 Double values

Downloadable Excel Tutorial: Pivot, Charts and Table Design to illustrate data

Details

  • Course type: by download
  • Content: 3rd hour Video footage
  • License: private and commercial usage rights
  • Bonus: including work material
  • Further information

Contents

  • About 3-hour Excel tutorial for illustrative and informative processing of data
  • Pivot Table in Excel: How to keep track of large amounts of data at any time
  • Table design: Useful functions such as conditional formatting for more overview
  • Excel Presentation: Create, for example, a traffic light that switches over at different values
  • Excel charts: How to introduce an informative speedometer diagram among others
  • Many more tips and tricks to work efficiently with Microsoft Excel
  • Created by: René Fürst

Modules

  • Intro
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 1 Intro
  • Evaluations and data overview
    • Excel Tutorial: Pivot, Charts and Table Design for illustrative data presentation – 2.1 times with the numeric block
    • Excel Tutorial: Pivot, Charts and Table Design for illustrative data presentation – 2.2
    • Excel Tutorial: Pivot, Diagrams and Table Design for Visual Data Presentation – 2.3 Formulas Automatically Copy
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – Mix 2.4 Texts, Data and Formulas in a Cell
    • Excel Tutorial: Pivot, Charts and Table Design to illustrate data presentation – 2.5 Views of Formulas
    • Excel Tutorial: Pivot, Charts and Table Design to illustrate data presentation – 2.6 Worksheet in a new Excel file
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 2.7 Weekday in a Conditional Formatting
    • Excel Tutorial: Pivot, Charts and Table Design to illustrate data presentation – 2.6 Worksheet in a new Excel file
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 2.7 Weekday in a Conditional Formatting
    • Excel Tutorial: Pivot, Charts and Table Design to Manage Visual Data Presentation – 2.8
    • Excel Tutorial: Pivot, Charts and Table Design to Highlight Visual Data Presentation – 2.9 Filled Cells
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 2.10 Breaks in Excel
    • Excel Tutorial: Pivot, Charts and Table Design for illustrative data presentation – 2.11 Columns and Rows dive
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 2.12 Database Mask in Excel
    • Excel Tutorial: Pivot, Charts and Table Design to illustrate data presentation – 2.13
  • Presentation and printing
    • Excel Tutorial: Pivot, Charts and Table Design for illustrative data presentation – 3.1 Coloring each second line
    • Excel Tutorial: Pivot, Charts and Table Design to create vivid data presentation – 3.2
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 3.3 Sparklines in Excel
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 3.4 Speedometer Diagram in Excel
    • Excel Tutorial: Pivot, Charts and Table Design to Visually Customize Data Presentation – 3.5 Excel Tables
    • Excel Tutorial: Pivot, Charts and Table Design to create vivid data presentation – 3.6
    • Excel Tutorial: Pivot, Charts and Table Design for illustrative data presentation – 3.7 Print settings on all worksheets
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 3.8 Print multiple worksheets on one page
    • Excel Tutorial: Pivot, Charts and Table Design for illustrative data presentation – 3.9 Manual page break when printing
    • Excel Tutorial: Pivot, Diagrams and Table Design for illustrative data presentation – 3.10 Excel table on a single page
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 3.11 Hide Error Messages When Printing
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 3.12 Format Codes in Header and Footer
  • Pivot 1×1
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 4.1 Pivot: Basics
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 4.2 Pivot: Calculations/Field Settings
    • Excel Tutorial: Pivot, Charts and Table Design for illustrative data presentation – 4.3 Pivot: Time axes and data section
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 4.4 Pivot: Filter
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 4.5 Pivot: Charts
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 4.6 Pivot: Layout
    • Excel Tutorial: Pivot, Charts and Table Design for illustrative data presentation – 4.7 Pivot: Options
  • Tips & tips Tricks for faster work
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 5.1
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 5.2 New Text Lines within a Cell
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 5.3 Lines in Cells
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 5.4 Change the large/small spell of text in Excel
    • Excel Tutorial: Pivot, Charts and Table Design to Transform Data Presentation – 5.5 Hours in Minutes
    • Excel Tutorial: Pivot, Diagrams and Table Design for illustrative data presentation – 5.6 Create rankings automatically
    • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 5.7 Rechnen mit der Statusbar
    • Excel Tutorial: Pivot, Diagrams and Table Design for illustrative data presentation – 5.8 Summ according to criteria of a cell range
    • Excel Tutorial: Pivot, Charts and Table Design to illustrate data presentation – 5.9 Count by criteria of a cell range
    • Excel Tutorial: Pivot, Charts and Table Design for illustrative data presentation – 5.10
  • Excel Tutorial: Pivot, Charts and Table Design for Visual Data Presentation – 5.11 Important Excel macros for everyday life

Create Excel charts and visualize data – the complete course

Details

  • Course type: by download
  • Content: 5th hour Video footage
  • License: private and commercial usage rights
  • Bonus: including work material
  • Further information

Contents

  • Excel Complete Course: Create Charts and Visualize Data
  • All important diagrams and visualizations step by step explained
  • From basics to simple columns to advanced gantt charts
  • About 5-hour training with practical tips and tricks from Excel expert Fabio Basler
  • Created by: Fabio Basler

Modules

  • Introduction
    • Create charts in Excel: 1.1 | Introduction and Lecturer Presentation
  • Basic data visualization
    • Create diagrams in Excel: 2.1 | Create visualizations
    • Create Charts in Excel: 2.2 | Manage Charts
    • Create diagrams in Excel: 2.3 | Link diagrams
  • Simple diagrams in Excel
    • Create charts in Excel: 3.1 | Column and Beam Diagrams
    • Create charts in Excel: 3.2 | Circle and Ring Diagrams
    • Create diagrams in Excel: 3.3 | Line diagrams and trend lines
    • Create charts in Excel: 3.4 | Area Graphics
    • Create charts in Excel: 3.5 | Histogram and Pareto chart
  • Advanced visualizations in Excel
    • Create Charts in Excel: 4.1 | Composite Diagrams
    • Create charts in Excel: 4.2 | Stacked column charts
    • Create charts in Excel: 4.3 | Panel charts
    • Create charts in Excel: 4.4 | Pivot charts
    • Create charts in Excel: 4.5 | Treemap
    • Create diagrams in Excel: 4.6 | funnel diagrams (pyramides)
    • Create charts in Excel: 4.7 | SmartArt models in Excel
    • Create charts in Excel: 4.8 | Sparklines
    • Create charts in Excel: 4.9 | Tornado Chart
    • Create charts in Excel: 4.10 | HeatMap Visualization
    • Create charts in Excel: 4.11 | Dynamic progress display
    • Create Charts in Excel: 4.12 | Dynamic Status Display
    • Create Charts in Excel: 4.13 | Sunburst Diagrams
    • Create Charts in Excel: 4.14 | Point XY Diagrams and Network Chart
    • Create charts in Excel: 4.15 | Boxplots
  • Special diagrams
    • Create charts in Excel: 5.1 | Thermometer Diagram
    • Create charts in Excel: 5.2 | Speedo Diagram
    • Create charts in Excel: 5.3 | Waterfall Diagrams 1
    • Create Charts in Excel: 5.4 | Waterfall Diagrams 2
    • Create diagrams in Excel: 5.5 | Dynamic planning steps 1
    • Create diagrams in Excel: 5.6 | Dynamic planning steps 2
    • Create charts in Excel: 5.7 | bubble charts as portfolio matrix
    • Create charts in Excel: 5.8 | Gantt chart (Balkenplan)
    • Create Charts in Excel: 5.9 | 2D Card Germany
    • Create Charts in Excel: 5.10 | 2D Card World
    • Create charts in Excel: 5.11 | Dynamic World Map
    • Create charts in Excel: 5.12 | Bing Maps
    • Create Charts in Excel: 5.13 | 3D Card (Power Map)
  • Secret professional visualizations
    • Create charts in Excel: 6.1 | Revenue and Target Corridor graphics
    • Create diagrams in Excel: 6.2 | Analyze deviation from number rows
    • Create charts in Excel: 6.3 | PowerView dashboard

Important information

Validity:

  • To 31.12.2026
  • Detachability:

  • Available online at www.tutkit.com/en/gutschein. Enter coupon code into the corresponding field during the payment process.
  • Redeem coupon code and fill in the registration for the customer account. After the registration, the immediate activation takes place to download the course contents.
  • Customer support: info@tutkit.com or www.tutkit.com/en/kontakt.
  • Please note:

  • Several vouchers per person can be redeemed or purchased for gifting.
  • Only valid for the purchased option.
  • No further fees.
  • Course ends automatically. No subscription.
  • Not combinable with other discounts.
  • No cash payment, no part payment and no repayment of balance.
  • Groupon sells the voucher and collects your payment; the dealer delivers the performance. For support and inquiries, please contact Customer Service. The dealer is solely responsible for the quality and care of the advertised products and services to buyers.