Discover what you can learn.

With video courses for work, study and leisure.

# Microsoft Excel 2010 (EN)

By Sonic Performance

#### 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

### Overview: Excel 2010

 How to Open and Close Excel 05:24 The Excel Application Window 06:03 How to Zoom In and Out 04:31 How to Expand, Minimize and Move Windows 05:11 The Ribbon in Excel 05:32 The Quick Access Toolbar in Excel 09:21

### Basic Table Editing in Excel 2010

 Navigating the Worksheet 06:01 How to Input Numbers, Dates and Text Into Cells 06:16 How to Create and Open Workbooks 07:13 Changing and Deleting Cell Contents 08:19 Selecting Elements of a Table 11:59 How to Undo 05:12 Printing Worksheets 08:23 Switching Between Open Windows 09:45 How to Add and Delete New Worksheets 09:44 How to Copy, Move and Rename Worksheets 06:10 Switching Between Worksheets 03:50

### Work With Formulas & the Help Function in Excel 2010

 Create and Enter Formulas 12:11 Use Relative Cell References in Formulas 08:46 Use Absolute Cell References in Formulas 13:16 The Sum Function 17:12 The Average, Minimum and Maximum Function 08:47 The Count Function 08:21 The Round Function 10:07 Improvements to Excel Functions 03:05 AND and OR Conditions 06:27 The Help Function 08:58

### Options & Basic Cell Formatting in Excel 2010

 How to Save and Close Workbooks 09:05 The General Pane in Excel 12:53 The Save Pane in Excel 13:33 The Font Size and Type 04:02 Bold, Italic and Underline 05:10 Cell Alignment in Excel 03:54 Line Break in Excel 04:48 Merging Cells 05:45 The Cell Borders 13:01 Decimals in Excel 07:40 Percent in Excel 06:56 Format Painter in Excel 05:12

### Changing the Table Structure & More Features in Excel 2010

 The Column Width and Row Height 10:58 How to Insert and Delete Columns, Rows and Cells 09:30 Showing and Hiding Colums and Rows 05:26 The Function Wizard 10:36 The IF Function in Excel 11:59 The Nested IF Function in Excel 03:55 VLOOKUP and HLOOKUP 18:34 Standard Error Message 08:20 Formula Auditing 12:01 Consolidate Data 08:20

### Work With Date and Time & Use Efficient Workbooks in Excel 2010

 How to Insert and Format Time and Date 11:42 Simple Time Calculation in Excel 09:05 Working With Date and Time Functions 12:25 How to Save in a Different File Type 10:08 Cell References to Other Sheets and Workbooks 06:44 Protecting Workbooks 05:18 Protecting Sheets and Cells 08:39 How to Share Workbooks 07:44

### Managing Workbooks in Excel 2010

 Favorite Links 04:32 Saving Options 12:29 Document Properties in Excel 03:39 How to Import and Export Data 10:46 Merging Workbooks 04:47

### Print Settings & Styles and Templates in Excel 2010

 The Print Preview in Excel 05:13 Arranging Windows in Excel 05:36 Margins in Excel 06:07 The Scale in Excel 06:26 Page Breaks 08:36 The Header and Footer 10:23 The Page Setup 08:44 The Print Titles 05:06 Editing Cell Styles 11:21 Excel Templates 08:12

### Charts in Excel 2010

 How to Create Charts 06:20 How to Move and Resize Charts 12:24 Changing Chart Type 07:05 Formatting Charts in Excel 07:49 Formatting Axis in Excel 11:36 The Labels in Excel 07:11 How to Create a Trendline 07:37

### Graphics and Objects in Excel 2010

 How to Insert and Edit Objects 10:15 The Image Styles in Excel 05:31 How to Insert Drawings 06:26 How to Insert SmartArts 09:58 Layer and Group Graphic Objects 08:50

### Edit Large Tables in Excel

 Quick Access to Cells 08:33 How to Split Sheet Window in Sections 07:57 Freezing Lines and Columns 07:44 How to Find and Replace Cells 09:38

### Special Graphical Possibilities & Outlining Tables in Excel 2010

 Conditional Formatting 20:48 Custom Cell Formats 08:12 The Data Validation in Excel 07:07 Comments in Excel 07:32 How to Use Hyperlinks 06:37 Watermarks & Background Pictures in Excel 06:58 Managing Themes in Excel 07:21 Data Grouping 04:15 Subtotal in Excel 07:57

### Excel 2010 as Data Base

 Creating a Data Base 04:22 Sorting in Excel 08:56 How to Use Filters in Excel 07:55 How to Use Special Filters in Excel 08:37 Database Functions 10:46

### Pivot Table in Excel 2010

 How to Create Pivot Table 03:43 The Pivot Table Field List 14:20 Data Grouping in Pivot Tables 09:07 The Pivot Table Tools 19:25 Inserting Calculated Field 07:22 How to Create a Pivot Chart 07:31

### Goal Seek and Solver & Scenarios in Excel 2010

 The Goal Seek in Excel 07:55 The Solver in Excel 17:51 Solver Reports in Excel 06:50 How to Create Scenarios 07:40

### Practice Tips in Excel 2010

 How to Prepare for Sharing 09:38 How to Mark as Final 03:51 The IFERROR Function 04:58 Deleting Duplicates 06:32 Text in Columns 10:16 Administer Digital Signatures 12:36 How to Create a Workspace 03:50 Developing XML Maps 10:31

## Details

• Included lectures: 120
• Duration: 16:47 h
• Available documents: 1

## Authors of course Microsoft Excel 2010 (EN)

### 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.