Microsoft Excel 2010 Advanced
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.
27 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

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.
27 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:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow
Collaborate with others using workbooks
Audit worksheets
Analyze data and work with multiple workbooks
Import and export data
Use Excel with the Web and structure workbooks with XML.
View Curriculum
Requirements
  • SONIC's Excel 2010 Intermediate Course Recommended
Description

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.

Consider this Microsoft Excel 2010 Advanced 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 improve the look and feel of their spreadsheets.
  • Everyone, who wants to work faster using Microsoft Excel 2010.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 35 Lectures Collapse All 35 Lectures 03:40:32
+
Intro Excel Advanced
1 Lecture 00:33
+
Streamlining Workflow
6 Lectures 50:52

Document properties contain a lot of important meta data of your workbooks. In this video you'll learn how to set the document properties.
Preview 03:39

Macros provide the possibilities to repeat frequently taken steps by recording them and being able to repeat them automatically. In this video you'll learn how to create macros and run them.
Preview 10:22

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.
Develop XML Maps
10:31
About the Instructor
SONIC - High Quality Training for Over 20 Years
4.2 Average rating
245 Reviews
4,715 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.