Microsoft Excel 2010 Advanced
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
28 students enrolled

Microsoft Excel 2010 Advanced

Master Excel in this easy to follow, step-by-step course.
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
28 students enrolled
Last updated 6/2013
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 31 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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.
  • SONIC's Excel 2010 Intermediate Course Recommended

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 this course is for:
  • Everyone, who wants improve the look and feel of their spreadsheets.
  • Everyone, who wants to work faster using Microsoft Excel 2010.
Course content
Expand all 35 lectures 03:40:32
+ 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
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
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
+ Collaborating with Other Users
8 lectures 51:47
Collaborating with Other Users - Overview
Protect your workbooks from unauthorized access. In this video you'll learn how to protect your workbooks.
Protect Files
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
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
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
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
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
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
+ Auditing Worksheets
4 lectures 25:09
Auditing Worksheets - Overview
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
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
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
+ Analyzing Data
6 lectures 44:37
Analyzing Data - Overview
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
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
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
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
In this video you'll learn how to create a summary of the solver reports.
The Solver Parameters Dialog Box
+ Working with Multiple Workbooks
4 lectures 19:15
Working with Multiple Workbooks - Overview
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
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
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
+ Importing and Exporting Data
2 lectures 11:23
Importing and Exporting Data - Overview
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
+ Integrating Excel Data with the Web
2 lectures 05:53
Integrating Excel Data with the Web - Overview
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
+ Structuring Workbooks with XML
2 lectures 11:03
Structuring Workbooks with XML - Overview
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