Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
Intro Excel AdvancedPreview
|Section 1: Streamlining Workflow|
Streamlining Workflow - OverviewPreview
|Document properties contain a lot of important meta data of your workbooks. In this video you'll learn how to set the document properties.|
|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.|
|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.|
|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.|
|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.|
|Section 2: Collaborating with Other Users|
Collaborating with Other Users - Overview
|Protect your workbooks from unauthorized access. In this video you'll learn how to protect your workbooks.|
|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.|
|In Excel you can share or lock processing of individual sections. In this video you'll learn how to 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.|
|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.|
|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.|
|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.|
|Section 3: Auditing Worksheets|
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.|
|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.|
|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.|
|Section 4: Analyzing Data|
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.|
|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.|
|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.|
|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.|
|In this video you'll learn how to create a summary of the solver reports.|
|Section 5: Working with Multiple Workbooks|
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.|
|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.|
|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.|
|Section 6: Importing and Exporting Data|
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.|
|Section 7: Integrating Excel Data with the Web|
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.|
|Section 8: Structuring Workbooks with XML|
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.|
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.