Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Excel 2016 - Intermediate (EN)

Von Sonic Performance

In this course you'll learn create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

You will:
• Work with functions.
• Work with lists.
• Analyze data.
• Visualize data with charts.
• Use PivotTables and PivotCharts

Upon successful completion of this course, you will be able to leverage the power of data analysis and
presentation in order to make informed, intelligent organizational decisions.

Inhalte

play symbol Course Overview: Excel 2016 – Intermediate
02:27
play symbol Introduction to Functions in Excel 2016
01:04
lecture locked Introduction to Ranges in Excel 2016
00:56
lecture locked Naming and Editing Ranges
05:34
lecture locked Using Defined Names in a Formula
03:12
lecture locked Using Specialized Functions
05:06
lecture locked Introduction to Logical Functions in Excel 2016
02:13
lecture locked How to Use the IF Function in Excel
04:29
lecture locked How to Use the AND, OR and NOT Function
05:40
lecture locked Combining Functions in Excel
06:18
lecture locked Alternatives to the IF Function
05:14
lecture locked Introduction to Date and Time Functions in Excel 2016
01:24
lecture locked Using Date Functions in Excel: TODAY, NOW and DATE
02:54
lecture locked Functions to Calculate Working Days And Weeknumbers: NETWORKDAY, WEEKDAY and More
05:28
lecture locked Introduction to Text Functions in Excel 2016
00:47
lecture locked How to Use the String Functions in Excel: LEFT, RIGHT and MID
02:40
lecture locked How to Use the FIND Function in Excel
03:19
lecture locked Split Text into Different Columns
03:38
lecture locked Combining Names in Excel: CONCATENATE
02:59
lecture locked Converting Text to Upper, Lower, or Proper Case
02:38
Quiz zum Kurs „Working with Functions in Excel 2016 (EN)“
play symbol Introduction to Sorting Data in Excel 2016
00:30
lecture locked How to Sort Data in Excel
03:00
lecture locked Introduction to Filter Data in Excel 2016
00:36
lecture locked How to Filter Data in Excel
02:29
lecture locked Using Functions for Database Queries
00:42
lecture locked Using Database Functions: SUM and AVERAGE
03:12
lecture locked Preventing Double-counting in Excel: SUBTOTAL
00:36
lecture locked Summarize Data with Subtotals
03:28
Quiz zum Kurs „Working with Lists in Excel 2016 (EN)“
play symbol Introduction to Tables in Excel 2016
00:44
lecture locked How to Create and Format Tables in Excel
06:49
lecture locked Using Summary Functions to Summarize Data
03:21
lecture locked Introduction to Intermediate Conditional Formatting in Excel 2016
00:41
lecture locked How to Apply Intermediate Conditional Formatting in Excel
02:44
lecture locked Introduction to Advanced Conditional Formatting in Excel 2016
00:35
lecture locked Using Logical Functions to Apply Conditional Formatting
03:32
Quiz zum Kurs „Data Analysis in Excel 2016 (EN)“
play symbol Introduction to Charts in Excel 2016
00:38
lecture locked How to Create Charts in Excel
04:28
lecture locked Introduction to Creating and Modifying Charts in Excel 2016
01:09
lecture locked How to Create and Modify Charts in Excel
05:15
lecture locked Introduction to Using Advanced Chart Features in Excel 2016
00:29
lecture locked How to Create a Dual Axis Chart in Excel
04:27
lecture locked Creating Chart Templates in Excel
03:02
lecture locked Data Visualization: Best Practices
03:52
Quiz zum Kurs „Visualizing Data in Excel 2016 (EN)“
play symbol Introduction to PivotTables in Excel 2016
00:17
lecture locked How to Create a PivotTable in Excel
04:03
lecture locked Introduction to Using PivotTables for Data Anylsis in Excel 2016
00:38
lecture locked Analyzing Data with PivotTables
04:29
lecture locked Introduction to PivotCharts in Excel 2016
00:50
lecture locked How to create a PivotChart in Excel
05:01
lecture locked Introduction to Slicers and Timelines in Excel 2016
00:54
lecture locked Filtering Data with Slicers and Timelines
04:18
lecture locked Follow-Up: Excel 2016 – Intermediate
01:35
Quiz zum Kurs „Using PivotTables and PivotCharts in Excel 2016 (EN)“
Quiz zum Kurs „Excel 2016 - Intermediate (EN)“

Details

  • Enthaltene Vorträge: 52
  • Laufzeit: 2:26 h
  • Enthaltene Quizfragen: 22
  • Enthaltene Lernmaterialien: 6

Dozenten des Kurses Excel 2016 - Intermediate (EN)

 Sonic Performance

Sonic Performance

Sonic Performance Support is a provider of web-based video learning solutions in multiple languages for consumers, corporations of every size, associations and educational institutions.

All videos can be accessed instantly from any computer or mobile device via any browser and come with a human touch. Experienced trainers guide you step-by-step through the software features.


Rezensionen

(1)
5,0 von 5 Sternen
5 Sterne
5
4 Sterne
0
3 Sterne
0
2 Sterne
0
1  Stern
0