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.

Microsoft Excel 2010 Advanced

Master Excel in this easy to follow, step-by-step course.

0.0
(0 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.

Taking this advanced 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.

In this course students will automate common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

If a macro has already been created and you need to edit or change it (maybe because it is not functioning the way you want to or you want to refine something), this video will show you how to edit macros so you don't have to re-record it all over again.

Edit a Macro

08:26

In this video you'll learn how to use the Conditional Formatting in Excel. Conditional Formatting makes sense particularly if the content should only be formatted if a certain condition is met.

Apply Conditional Formatting

20:48

In this video you'll learn how to activate the data validation in Excel to see, for example, who changed what and when on the worksheet.

Add Data Validation Criteria

07:07

+–

Collaborating with Other Users

8 Lectures
51:47

Collaborating with Other Users - Overview

00:32

Protect your workbooks from unauthorized access. In this video you'll learn how to protect your workbooks.

Protect Files

05:18

Data protection in Excel can be defined at several different levels. You can protect individual cells, whole worksheets, or even workbooks. In this video you'll learn how to protect worksheets and cells.

Protect Sheets and Cells

08:39

In Excel you can share or lock processing of individual sections. In this video you'll learn how to share a workbook.

Share a Workbook

07:44

Do you want to work with your colleagues on a spreadsheet? Use the SharePoint Server to do so. This makes it possible for several people to work together on a spreadsheet and make changes. Use the SharePoint Server to quickly display changes of your colleagues and comprehend them. Work more efficiently as a team by sharing documents.

The SharePoint® Server

08:18

You have worked together with your colleagues on spreadsheets using the SharePoint server. There are now multiple versions of the document. You do not have to transfer all of the changes manually to your final document at all. In this video you will learn how you can automatically bring together the various versions of the document.

Merge Workbooks

04:48

Digital signatures indicate on the one hand who the author of a document is. On the other hand, the authenticity of a document can be checked this way. In this video you will learn what valid and invalid digital signatures are about and how to create and manage digital signatures.

Administer Digital Signatures and Install A Digital Certificate

12:36

Tell your colleagues that the processing of the workbook is finished and that it should not longer be changed. In this video you'll learn how to mark a document as final.

The Mark As Final Option

03:52

+–

Auditing Worksheets

4 Lectures
25:09

Auditing Worksheets - Overview

00:33

Lots of formulars are very complex and refer to several other cells that can be spread across many different worksheets. In this video you'll learn how to use the formula auditing.

Formula Auditing

12:01

If a formula is wrong, Excel will display an error message. But what do these error messages mean? In this video you'll learn about the Standard Error Messages in Excel 2010.

Troubleshoot Invalid Data and Formula Errors

08:20

Grouping data means collating logically related data and working with it. In this video you'll learn how to use the Group and Outline functions in Excel 2010.

Create a Data List Outline

04:15

+–

Analyzing Data

6 Lectures
44:37

Analyzing Data - Overview

00:26

You have created a diagram which represents the sales of your company for the last 6 months, for example. If you now want to see how sales have relatively developed or you want to make a prediction as to how revenue will look in the coming months, then the trend lines in Excel 2010 will help you further along. Based on the previous data in the chart, they make a trend or a forecast in the form of a line. In this video you will learn about various forms of the trend line and how to apply them.

Create a Trendline

07:37

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.

Create Sparklines

04:13

Save different kinds of calculation cases and exchange the raw figures for calculation of the data without any complications. In this video you'll learn how to use the scenario manager in Excel 2010.

Create Scenarios

07:40

With the aid of the Solver function in Excel, you have the possibility of solving even quite complex optimization tasks. In this video you'll learn how to use the Solver in Excel.

Perform a What-If Analysis

17:51

In this video you'll learn how to create a summary of the solver reports.

The Solver Parameters Dialog Box

06:50

+–

Working with Multiple Workbooks

4 Lectures
19:15

Working with Multiple Workbooks - Overview

00:28

Are you simultaneously working with multiple spreadsheets and it bothers you that you always have to reorganize them after every time you start Excel 2010? Save yourself the work by creating a workspace only once. You can now use it again and again. The following video shows how this works.

Create a Workspace

03:50

If you want to bring together the contents of multiple tables or spreadsheets together on a new spreadsheet, it would be pretty time-consuming to have to perform this manually. With the "consolidate data" function, Excel 2010 gives you the ability to automate this and summarizes values from multiple fields in a new area. The following video shows you how much time you save as a result.

Consolidate Data

08:20

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.

Use Hyperlinks

06:37

+–

Importing and Exporting Data

2 Lectures
11:23

Importing and Exporting Data - Overview

00:37

You can use external data sources to import these into Excel, for example. In this video you'll learn how to import or export data.

Import a Delimited Text File and Export Excel Data

10:46

+–

Integrating Excel Data with the Web

2 Lectures
05:53

Integrating Excel Data with the Web - Overview

00:25

Do you want to open and edit your Excel file from anywhere on any system? Then you should publish your data on the web. You can choose in Excel 2010 whether you publish only a selected part of a worksheet, the entire worksheet or all of the spreadsheets. The video shows you how you can directly obtain your data from Excel 2010 for use in a browser.

Publish a Worksheet to the Web

05:28

+–

Structuring Workbooks with XML

2 Lectures
11:03

Structuring Workbooks with XML - Overview

00:32

If you want to edit or display an XML file in Excel 2010, you first need to import this XML file into a worksheet. To do so, you have the developer of XML mappings in Excel 2010 at your disposal. You will learn how you can deal with XML files in Excel 2010 and which options Excel 2010 provides when assigning XML files.

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.