Microsoft Excel 2010 Intermediate
4.3 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
79 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2010 Intermediate to your Wishlist.

Add to Wishlist

Microsoft Excel 2010 Intermediate

Master Excel in this easy to follow, step-by-step course.
4.3 (7 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
79 students enrolled
Last updated 6/2013
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Upon successful completion of this course, students will be able to create and use advanced formulas
  • Organize their worksheet and table data using various options
  • Create and modify charts
  • Analyze data using PivotTables, Slicers, and PivotCharts
  • Insert and modify graphic objects in a worksheet
  • Customize and enhance workbooks and the Microsoft Office Excel environment.
View Curriculum
Requirements
  • Microsoft Excel 2010 Beginner Recommended
Description

Taking this intermediate course for Microsoft Excel will explain the processes of how to accomplish some common tasks you need in Excel. If you are anything like most people who use their computers for work, it is much easier to have an example and the explanation on how to do something, than to try and figure it out yourself.

The Microsoft Excel 2010 Level 2 will strengthen the skills that you have already, while also giving you some new techniques for Excel. The tasks that you will learn are:

• To organize your worksheet and table data using various options
• Create and modify charts
• Customize workbooks and enhance your Microsoft Office Excel environment
• Modify graphic objects in a worksheet, analyze data using Pivot Tables, slicers and Pivot Charts

Consider this Microsoft Excel 2010 Level 2 to improve your Microsoft Excel 2010 skills.

Our Microsoft courses help you to prepare for the official Microsoft Office Specialist exam.

Who is the target audience?
  • Everyone, who wants to work faster using Microsoft Excel 2010.
  • Everyone, who wants improve the look and feel of their spreadsheets.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 51 Lectures Collapse All 51 Lectures 06:50:43
+
Intro Excel Intermediate
1 Lecture 00:38
+
Calculating Data with Advanced Formulas
9 Lectures 01:23:42
Calculating Data with Advanced Formulas - Overview
00:23

With the help of the arrow keys in Excel, you can move really quickly from cell to cell. You can also use the mouse to target and select one of the visible cells, for example. But what do you do, though, if the cell you want to get to is really way down or over to the right in a column or row you can't see, e.g. cell “ADE7000”? In this case the so-called name box can help you to move to a target in the worksheet.
Apply Cell and Range Names
08:33

Link your content. In this video you'll learn how to define the cell references to other sheets and workbooks.
Cell References to other Sheets and Workbooks
06:44

There are over 300 functions in Excel that you can use for calculating your results. In this video you'll learn how to work with the function wizard.
The Function Wizard
10:36

Excel is a calculation tool. The correct entry of a formula is especially important for later calculations. In this video you'll learn about the configuration and entry of formulas.
Create and Enter Formulas
12:11

Formulas and functions have experienced change and improvement in Excel 2010. In the area of statistical functions, a new and more precise algorithm has been developed for normal distribution and standard normal distribution. Improvements have also been made in the areas of "Financial" and "Mathematics & Trigonometry". Functions have been given more appropriate names, so that they are easier to find. But don't worry! The old names can still be used. And you also learn about entirely new Excel 2010 functions.
Improvements to Excel Functions
03:05

If your calculating steps depend on certain conditions, you can use the IF function to define these conditions and check whether they are met or not. In this video you'll learn how to use the IF function.
The IF Function
11:59

In Excel you can nest several functions with one another. In this video you'll learn how to set up a Nested IF function.
The Nested IF Function
11:37

Use the LOOKUP function, for example, to compare two tables with each other. In this video you'll learn how to use the two functions VLOOKUP and HLOOKUP.
VLOOKUP and HLOOKUP Functions
18:34
+
Organizing Worksheet and Table Data
10 Lectures 01:16:52
Organizing Worksheet and Table Data - Overview
00:31

In this video you will learn how to create a table within a spreadsheet without changing your surrounding data. You will be shown two ways with which you can access a table in your spreadsheet.
Preview 07:03

You don't have to start from the beginning if you wish to change a table that is already on your spreadsheet. There are several ways to make changes. For example, you can delete or insert rows and columns. This video will also show you how to easily delete duplicates without having to search for them manually.
Modify Tables
08:11

You are free to shape the tables on your spreadsheets. Excel 2010 gives you a lot of options here. Not only can you highlight cells or change their sizes, but you can also choose different designs. To complement your highlights, you can also color the backgrounds to your liking.
Format Tables
10:25

Sorting data and putting it in the right order ist particularly important if you have to work with large amounts of data. In this video you'll learn how to sort your data within an Excel list.
Sorting
08:56

Filter your data by specifying the required criteria and selecting data directly via the filter. In this video you'll learn how to use the filter in Excel 2010.
Filter
07:55

Admittedly, the ”normal” filter offers you lots of possibilities to select your data and to filter data according to the required criteria, but if, for example, you not only want to filter data at the same point, but to copy these to a particular sheet directly after filtering, you will not get very far with the ”normal” filter. In this video you'll learn how to use a special filter in Excel 2010.
Special Filter
08:38

Admittedly, you can sum and add up data within a table relatively quickly and easily with a simple Sum function. If the addition has to consider certain criteria, however, you quickly reach the limits of the "simple" Sum function in Excel. In this video you'll learn how to evaluate databases with the database functions.
Database Functions
10:47

You want to make sure that all specified parameters are above a certain value? No problem. This can be done very easily using the AND function. With the OR function you can determine whether there is at least one parameter in the specified framework. This can be useful when you have huge amounts of data.
AND and OR Conditions
06:28

Subtotals are frequently required with long data lists. You can calculate these subtotals relatively easily with the subtotal function, and display them. In this video you'll learn how to use the subtotal function in Excel.
Subtotals
07:58
+
Presenting Data Using Charts
9 Lectures 01:06:10
Presenting Data Using Charts - Overview
00:28

Excel charts are extremely popular and are frequently used for data analysis and data evaluation. In this video you'll learn how to create an Excel chart.
Create Charts
06:20

Charts are inserted in Excel 2010 as objects next to the table (data source). This is not always practical, since they are often just in the way. In this video you'll learn how to move charts, or change their size.
Move and Resize Charts
12:24

Choose a suitable chart for the evaluation and analysis of your data. In this video you'll learn how to change the chart type.
Change Chart Type
07:05

Arrange your charts in the way that suits you best. In this video you'll learn how to format charts.
Format Charts
07:49

You can adapt the chart data range, that is the data source for your chart, at any time, or reselect it. In this video you'll learn how to adapt the chart data range at a later date.
Chart Data Range
09:04

You can process or adapt the axis captions or axis scaling in a chart. In this video you'll learn how to process the axes in a chart.
Format Axis
11:36

If an axis caption or even the chart title is missing, it is easy to have this displayed. In this video you'll learn how to change the labels in a chart.
Labels
07:11

In this video you'll learn how to insert a sparklines chart, and how you can present turnover development, for example, directly in the cell in the form of miniature charts.
Sparklines
04:13
+
Analyzing Data Using PivotTables, Slicers, and PivotCharts
7 Lectures 01:05:47
Analyzing Data Using PivotTables, Slicers, and PivotCharts - Overview S856_2000
00:31

PivotCharts can be extremely useful when analyzing and evaluating data. In this video you'll learn how to create a PivotChart.
Preview 07:31

The PivotTable Field List is the basis for working with Pivot columns. In this video you'll learn how to work with the PivotTable Field List.
PivotTable Field List
14:20

Individual data values can be summarized in groups, e.g. months or quarters, in Pivot. In this video you'll learn how to group your data within a PivotTable.
Data Grouping
09:07

If the data basis is incomplete, you can create additional fields in the PivotTable. In this video you'll learn how to insert a Calculated Field in a PivotTable.
Insert Calculated Field
07:22

The PivotTable is an especially powerful and very useful tool for the analysis and evaluation of data. In this video you'll learn how to evaluate and analyze data with the PivotTable tools.
Filter Data Using Slicers
19:25

PivotCharts can be extremely useful when analyzing and evaluating data. In this video you'll learn how to create a PivotChart.
Analyze Data Using PivotCharts
07:31
+
Inserting Graphic Objects
6 Lectures 41:33
Inserting Graphic Objects - Overview Niklas: S856_1500_010_V_Graphics_and_Object
00:33

A picture says more than a thousand words! In this video you'll learn how to insert and edit objects in Excel.
Insert and Edit Objects
10:15

Adapt your pictures and format them with the help of the image styles.In this video you'll learn how to work with image styles.
Image Styles
05:31

Content can be more easily explained with the aid of graphic elements. In this video you'll learn how to insert various drawings.
Insert Drawings
06:26

Excel offers numerous ready-made graphics, so-called SmartArts, that you can use for various purposes. In this video you'll learn how to use SmartArt graphics in Excel.
Insert SmartArts
09:58

You can easily move placed images. To do so, the corresponding picture has to be selected and moved with the cursor. If you are working with multiple images, the menu gives you further options with which you can for example place pictures behind others. If you want to handle multiple images as a single fixed object, you can do so with the "Group" function.
Layer and Group Graphic Objects
08:50
+
Customizing and Enhancing the Excel Environment
9 Lectures 01:16:01
Customizing and Enhancing the Excel Environment - S856_1000_010_V_Use_efficient_
00:26

In this video you'll learn the main things about the General Pane.
The General Pane
12:53

In this video you'll learn how to save documents.
The Save Pane
13:33

In this video you'll learn how to set the save options in Excel 2010.
Save Options
12:29

With important cell content it is especially important to leave tips for processing the content. In this way, each user can comprehend straightaway what to enter and where. In this video you'll learn how to insert comments in Excel 2010.
Comments
07:32

Link content between the worksheets, and within the files, with the aid of the hyperlink function. In this video you'll learn how to create hyperlinks.
Hyperlinks
06:37

One way to personalize your spreadsheet more is by inserting a watermark. Or do you want to give your spreadsheet a nice wallpaper? Again, this is not a problem with Excel 2010. Watch this video to learn more.
Watermarks & Background Pictures
06:58

Excel 2010 offers you a variety of pre-made designs that you can access for your needs. If the selection is too small or you have your own ideas, you can easily add your own designs to the available ones.
Manage Themes
07:21

If certain calculations or lists are required repeatedly, and if these always have to be filed under a (new) name, it makes sense to create a template for these recurring activities. In this video you'll learn how to use Excel templates.
Excel Templates
08:12
About the Instructor
SONIC - High Quality Training for Over 20 Years
4.1 Average rating
273 Reviews
4,883 Students
45 Courses

SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.