Microsoft Excel 2010 Intermediate

Master Excel in this easy to follow, step-by-step course.
4.2 (5 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.
73 students enrolled
$30
Take This Course
  • Lectures 51
  • Contents Video: 7 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2013 English

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

What are the requirements?

  • Microsoft Excel 2010 Beginner Recommended

What am I going to get from this course?

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

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Intro Excel Intermediate
Preview
00:38
Section 1: Calculating Data with Advanced Formulas
Calculating Data with Advanced Formulas - Overview
00:23
08:33
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.
06:44
Link your content. In this video you'll learn how to define the cell references to other sheets and workbooks.
10:36
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.
12:11
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.
03:05
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.
11:59
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.
11:37
In Excel you can nest several functions with one another. In this video you'll learn how to set up a Nested IF function.
18:34
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.
Section 2: Organizing Worksheet and Table Data
Organizing Worksheet and Table Data - Overview
00:31
07:03
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.
08:11
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.
10:25
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.
08:56
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.
07:55
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.
08:38
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.
10:47
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.
06:28
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.
07:58
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.
Section 3: Presenting Data Using Charts
Presenting Data Using Charts - Overview
00:28
06:20
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.
12:24
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.
07:05
Choose a suitable chart for the evaluation and analysis of your data. In this video you'll learn how to change the chart type.
07:49
Arrange your charts in the way that suits you best. In this video you'll learn how to format charts.
09:04
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.
11:36
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.
07:11
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.
04:13
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.
Section 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
Analyzing Data Using PivotTables, Slicers, and PivotCharts - Overview S856_2000
00:31
07:31
PivotCharts can be extremely useful when analyzing and evaluating data. In this video you'll learn how to create a PivotChart.
14:20
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.
09:07
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.
07:22
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.
19:25
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.
07:31
PivotCharts can be extremely useful when analyzing and evaluating data. In this video you'll learn how to create a PivotChart.
Section 5: Inserting Graphic Objects
Inserting Graphic Objects - Overview Niklas: S856_1500_010_V_Graphics_and_Object
00:33
10:15
A picture says more than a thousand words! In this video you'll learn how to insert and edit objects in Excel.
05:31
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.
06:26
Content can be more easily explained with the aid of graphic elements. In this video you'll learn how to insert various drawings.
09:58
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.
08:50
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.
Section 6: Customizing and Enhancing the Excel Environment
Customizing and Enhancing the Excel Environment - S856_1000_010_V_Use_efficient_
00:26
12:53
In this video you'll learn the main things about the General Pane.
13:33
In this video you'll learn how to save documents.
12:29
In this video you'll learn how to set the save options in Excel 2010.
07:32
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.
06:37
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.
06:58
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.
07:21
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.
08:12
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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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.

Ready to start learning?
Take This Course