Discover what you can learn.

With video courses for work, study and leisure.

Microsoft Excel 2010

By Sonic Performance

(1)

Get a professional user of Microsoft Exel 2010!

Your skills in Excel 2010 include no more than creating a table or two? In this course you will be shown how to unlock its full potential and use features like Saving and Closing Workbooks, create PivotCharts or sharing workbooks. Additional contents are:

  • Printing Worksheets
  • The Function Wizard
  • The General Pane
  • Moving and Resizing Charts
  • The Excel Application Window

Content

play symbol How to Open and Close Excel
05:24
lecture locked The Excel Application Window
06:03
lecture locked How to Zoom In and Out
04:31
lecture locked How to Expand, Minimize and Move Windows
05:11
lecture locked The Ribbon in Excel
05:32
lecture locked The Quick Access Toolbar in Excel
09:21
play symbol Navigating the Worksheet
06:01
lecture locked How to Input Numbers, Dates and Text Into Cells
06:16
lecture locked How to Create and Open Workbooks
07:13
lecture locked Changing and Deleting Cell Contents
08:19
lecture locked Selecting Elements of a Table
11:59
lecture locked How to Undo
05:12
lecture locked Printing Worksheets
08:23
lecture locked Switching Between Open Windows
09:45
lecture locked How to Add and Delete New Worksheets
09:44
lecture locked How to Copy, Move and Rename Worksheets
06:10
lecture locked Switching Between Worksheets
03:50
play symbol Create and Enter Formulas
12:11
lecture locked Use Relative Cell References in Formulas
08:46
lecture locked Use Absolute Cell References in Formulas
13:16
lecture locked The Sum Function
17:12
lecture locked The Average, Minimum and Maximum Function
08:47
lecture locked The Count Function
08:21
lecture locked The Round Function
10:07
lecture locked Improvements to Excel Functions
03:05
lecture locked AND and OR Conditions
06:27
lecture locked The Help Function
08:58
play symbol How to Save and Close Workbooks
09:05
lecture locked The General Pane in Excel
12:53
lecture locked The Save Pane in Excel
13:33
lecture locked The Font Size and Type
04:02
lecture locked Bold, Italic and Underline
05:10
lecture locked Cell Alignment in Excel
03:54
lecture locked Line Break in Excel
04:48
lecture locked Merging Cells
05:45
lecture locked The Cell Borders
13:01
lecture locked Decimals in Excel
07:40
lecture locked Percent in Excel
06:56
lecture locked Format Painter in Excel
05:12
play symbol The Column Width and Row Height
10:58
lecture locked How to Insert and Delete Columns, Rows and Cells
09:30
lecture locked Showing and Hiding Colums and Rows
05:26
lecture locked The Function Wizard
10:36
lecture locked The IF Function in Excel
11:59
lecture locked The Nested IF Function in Excel
03:55
lecture locked VLOOKUP and HLOOKUP
18:34
lecture locked Standard Error Message
08:20
lecture locked Formula Auditing
12:01
lecture locked Consolidate Data
08:20
play symbol How to Insert and Format Time and Date
11:42
lecture locked Simple Time Calculation in Excel
09:05
lecture locked Working With Date and Time Functions
12:25
lecture locked How to Save in a Different File Type
10:08
lecture locked Cell References to Other Sheets and Workbooks
06:44
lecture locked Protecting Workbooks
05:18
lecture locked Protecting Sheets and Cells
08:39
lecture locked How to Share Workbooks
07:44
play symbol Favorite Links
04:32
lecture locked Saving Options
12:29
lecture locked Document Properties in Excel
03:39
lecture locked How to Import and Export Data
10:46
lecture locked Merging Workbooks
04:47
play symbol The Print Preview in Excel
05:13
lecture locked Arranging Windows in Excel
05:36
lecture locked Margins in Excel
06:07
lecture locked The Scale in Excel
06:26
lecture locked Page Breaks
08:36
lecture locked The Header and Footer
10:23
lecture locked The Page Setup
08:44
lecture locked The Print Titles
05:06
lecture locked Editing Cell Styles
11:21
lecture locked Excel Templates
08:12
play symbol How to Create Charts
06:20
lecture locked How to Move and Resize Charts
12:24
lecture locked Changing Chart Type
07:05
lecture locked Formatting Charts in Excel
07:49
lecture locked Formatting Axis in Excel
11:36
lecture locked The Labels in Excel
07:11
lecture locked How to Create a Trendline
07:37
play symbol How to Insert and Edit Objects
10:15
lecture locked The Image Styles in Excel
05:31
lecture locked How to Insert Drawings
06:26
lecture locked How to Insert SmartArts
09:58
lecture locked Layer and Group Graphic Objects
08:50
play symbol Quick Access to Cells
08:33
lecture locked How to Split Sheet Window in Sections
07:57
lecture locked Freezing Lines and Columns
07:44
lecture locked How to Find and Replace Cells
09:38
play symbol Conditional Formatting
20:48
lecture locked Custom Cell Formats
08:12
lecture locked The Data Validation in Excel
07:07
lecture locked Comments in Excel
07:32
lecture locked How to Use Hyperlinks
06:37
lecture locked Watermarks & Background Pictures in Excel
06:58
lecture locked Managing Themes in Excel
07:21
lecture locked Data Grouping
04:15
lecture locked Subtotal in Excel
07:57
play symbol Creating a Data Base
04:22
lecture locked Sorting in Excel
08:56
lecture locked How to Use Filters in Excel
07:55
lecture locked How to Use Special Filters in Excel
08:37
lecture locked Database Functions
10:46
play symbol How to Create Pivot Table
03:43
lecture locked The Pivot Table Field List
14:20
lecture locked Data Grouping in Pivot Tables
09:07
lecture locked The Pivot Table Tools
19:25
lecture locked Inserting Calculated Field
07:22
lecture locked How to Create a Pivot Chart
07:31
play symbol The Goal Seek in Excel
07:55
lecture locked The Solver in Excel
17:51
lecture locked Solver Reports in Excel
06:50
lecture locked How to Create Scenarios
07:40
play symbol How to Prepare for Sharing
09:38
lecture locked How to Mark as Final
03:51
lecture locked The IFERROR Function
04:58
lecture locked Deleting Duplicates
06:32
lecture locked Text in Columns
10:16
lecture locked Administer Digital Signatures
12:36
lecture locked How to Create a Workspace
03:50
lecture locked Developing XML Maps
10:31

Details

  • Included lectures: 119
  • Duration: 16:40 h
  • Available documents: 1

These courses may be of interest to you


Authors of course Microsoft Excel 2010

 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.


Customer reviews

(1)

5,0 of 5 stars
5 Stars
1
4 Stars
0
3 Stars
0
2 Stars
0
1  Star
0
 
Übersichtlich!
By Deborah S. on 08. November 2015 for Excel 2010 as Data Base

Der Kurs erklärt die Basic sehr gut. Ist genau das, was jeder Anfänger wissen sollte. Gerade wenn man mit Datenbanken arbeiten will.