Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Microsoft Excel 2013

Von Sonic Performance

(1)

Getting started with Excel 2013

This course will give you an appropriate insight to Excel and its features. You will learn Excel from the very start:

  • Performing calculations
  • Printing workbook contents
  • Creating advanced formulars
  • and so much more

Inhalte

play symbol Getting Started with Excel 2013 - Lesson Introduction
00:22
lecture locked Elements of the Application Window
08:06
lecture locked Elements of the Workbook Window
16:06
lecture locked Create a Basic Worksheet
07:14
lecture locked The Help System
03:58
Quiz zum Kurs „Excel 2013 Introduction“
play symbol Performing Calculations - Lesson Introduction
00:14
play symbol Create Formulas in a Worksheet
10:17
lecture locked Insert SUM and AVERAGE Functions
12:22
lecture locked Insert MIN and MAX Functions
10:37
lecture locked Cut and Paste Commands
08:48
lecture locked Absolute Cell References
10:11
Quiz zum Kurs „Performing Calculations in Excel 2013“
play symbol Modifying a Worksheet - Lesson Introduction
00:34
play symbol The Auto Fill Feature
09:20
lecture locked The Undo and Redo Commands
06:46
lecture locked Column Width and Row Height Alteration Methods
07:06
lecture locked The Hide and Unhide Options
04:35
lecture locked The Insert and Delete Options
08:37
lecture locked Cell Names and Range Names
07:01
lecture locked The Find and Replace Commands
05:02
lecture locked Spell Check a Worksheet
06:34
Quiz zum Kurs „Modifying a Worksheet in Excel 2013“
play symbol Formatting a Worksheet - Lesson Introduction
00:25
play symbol Modify Fonts
07:44
lecture locked Add Borders and Color to Cells
06:48
lecture locked Apply Number Formats
05:23
lecture locked Align Cell Contents
08:33
lecture locked Apply Cell Styles
09:18
Quiz zum Kurs „Formatting a Worksheet in Excel 2013“
play symbol Printing Workbook Contents - Lesson Introduction
00:28
lecture locked Define the Basic Page Layout
07:49
lecture locked Refine the Page Layout and Apply Print Options
08:10
Quiz zum Kurs „Printing Workbook Contents in Excel 2013“
play symbol Managing Large Workbooks - Lesson Introduction
00:24
lecture locked Format Worksheet Tabs
05:37
lecture locked Managing Worksheets
08:04
lecture locked Manage the View of Worksheets and Workbooks
05:17
Quiz zum Kurs „Managing Large Workbooks in Excel 2013“
play symbol Customizing the Excel Environment - Lesson Introduction
00:20
play symbol Customize General and Language Options
07:32
lecture locked Customize Formula Options
03:38
lecture locked Customize Proofing and Save Options
02:49
lecture locked Customize the Quick Access Toolbar
07:40
lecture locked Customize the Ribbon
09:18
lecture locked Customize the Functionality of Excel by Enabling Add-Ins
04:20
lecture locked Customize Advanced Options
05:06
lecture locked Customize Trust Center Options
03:11
Quiz zum Kurs „Customizing the Excel Environment“
play symbol Creating Advanced Formulas - Lesson Introduction
00:46
play symbol Add Range Names
06:49
lecture locked Edit and Delete Range Names
03:34
lecture locked Use Range Names in a Formula
06:12
lecture locked Use Specialized Functions
06:36
lecture locked Use the SUM Function
02:47
lecture locked Use the AVERAGE Function
03:20
lecture locked Use the MIN Function
03:40
lecture locked Use the MAX Function
03:10
lecture locked Use COUNT, COUNTA and COUNTIF Functions
07:03
lecture locked Use the ROUND Function
04:46
lecture locked Use the AND Function
04:23
lecture locked Use the CONCATENATE Function
04:44
lecture locked Use HLOOKUP and VLOOKUP Functions
05:02
Quiz zum Kurs „Creating Advanced Formulas in Excel 2013“
play symbol Analyzing Data with Logical Functions - Lesson Introduction
00:36
lecture locked Work with Logical Functions
06:09
lecture locked Use the Nested IF Function
03:53
Quiz zum Kurs „Analyzing Data with Logical Functions in Excel 2013“
play symbol Organizing Worksheet Data with Tables - Lesson Introduction
00:33
play symbol Create and Modify Tables
04:57
lecture locked Sort Data
03:52
lecture locked Filter Data with the Auto Filter
02:30
lecture locked Filter Data with the Advanced Filter
05:28
lecture locked Remove Duplicates
04:02
lecture locked Total Row
06:34
Quiz zum Kurs „Organizing Worksheet Data with Tables“
play symbol Visualizing Data with Charts - Lesson Introduction
00:31
play symbol Create Charts
09:37
lecture locked Change the Default Chart Type
03:37
lecture locked Modify Charts
10:04
lecture locked Edit Chart Axes
09:19
lecture locked Format Charts
03:37
lecture locked Create a Trendline in Excel 2013
09:41
lecture locked Create Advanced Charts
11:52
Quiz zum Kurs „Visualizing Data with Charts in Excel 2013“
play symbol Analyzing Data with PivotTables, Slicers, and PivotCharts - Lesson Introduction
00:25
play symbol Create a PivotTable
07:15
lecture locked Advanced Field Settings
07:09
lecture locked Filter Data by Using Slicers
05:40
lecture locked Analyze Data by Using PivotCharts
07:52
Quiz zum Kurs „Analyzing Data with PivotTables, Slicers, and PivotCharts“
play symbol Inserting Graphics - Lesson Introduction
00:25
lecture locked Insert and Modify Graphic Objects
06:59
lecture locked Insert and Group Shapes
07:12
lecture locked Incorporate SmartArt in Excel 2013
06:11
Quiz zum Kurs „Inserting Graphics in Excel 2013“
play symbol Enhancing Workbooks - Lesson Introduction
00:36
play symbol Comments in Excel 2013
05:00
lecture locked Hyperlinks in Excel 2013
05:21
lecture locked Watermarks in Excel 2013
04:39
lecture locked Manage Themes in Excel 2013
05:18
lecture locked Create and Use Templates
06:12
lecture locked Protect Files
08:27
Quiz zum Kurs „Enhancing Workbooks in Excel 2013“
play symbol Automating Worksheet Functionality - Lesson Introduction
00:25
play symbol Update Workbook Properties
03:40
lecture locked Apply Conditional Formatting
05:43
lecture locked Edit a Conditional Formatting Rule
04:47
lecture locked Add Data Validation Criteria
07:58
Quiz zum Kurs „Automating Worksheet Functionality in Excel 2013“
play symbol Auditing Worksheets - Lesson Introduction
00:39
play symbol Trace Cells
02:58
lecture locked Troubleshoot Invalid Data
02:26
lecture locked Troubleshoot Invalid Formulas
06:08
lecture locked Evaluate Formulas
02:39
lecture locked Watch Formulas
02:05
lecture locked Create a Data List Outline
03:00
lecture locked Add Subtotals to Grouped Data
03:52
Quiz zum Kurs „Auditing Worksheets in Excel 2013“
play symbol Analyzing and Presenting Data - Lesson Introduction
00:22
lecture locked Create Sparklines
04:51
lecture locked Create Scenarios
04:49
lecture locked Perform a What-If Analysis
03:02
Quiz zum Kurs „Analyzing and Presenting Data in Excel 2013“
play symbol Working with Multiple Workbooks - Lesson Introduction
00:28
lecture locked Consolidate Data
03:56
lecture locked Link Cells in Different Workbooks
04:52
lecture locked Merge Workbooks
02:38
Quiz zum Kurs „Working with Multiple Workbooks in Excel 2013“
play symbol Exporting Excel Data - Lesson Introduction
00:28
play symbol Export Excel Data
05:19
lecture locked Import a Delimited Text File
05:46
lecture locked Integrate Excel Data with the Web
06:01
lecture locked Create a Web Query
06:10
Quiz zum Kurs „Exporting Excel Data“
Quiz zum Kurs „Microsoft Excel 2013“

Details

  • Enthaltene Vorträge: 116
  • Laufzeit: 10:01 h
  • Enthaltene Quizfragen: 65
  • Enthaltene Lernmaterialien: 1

Diese Kurse könnten Sie interessieren


Dozenten des Kurses Microsoft Excel 2013

 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