Computer E-Learning

Welcome to the Excel 2010 Expert workshop. Excel includes some powerful tools to help you manipulate your data. From sharing workbooks to advanced functions and formulas, this workshop will help you become a true power user of Excel 2010.

This module introduces you to the Information tab on the Backstage View. You’ll learn about marking a workbook as final, which makes the workbook read-only. You’ll also learn about permissions – both encrypting the workbook with a password and restricting permissions. This module explains how to protect both the current sheet and an entire workbook’s structure. You’ll also learn how to add a digital signature, which is helpful if your workbook contains macros that you want to share with others. Then we’ll move on to exploring the Excel options dialog box, where you can set advanced options and properties. We’ll look at managing versions, which can help you recover unsaved work if you have Autosave turned on. Finally, we’ll look at saving your workbook as a template to simplify new workbook creation.

This module helps you understand the issues concerned with sharing a workbook. First, we’ll look at how to inspect the workbook for issues. Then, you’ll learn how to share a workbook and edit a shared workbook. You’ll also learn about tracking changes to document other users changes and comments. Finally, you’ll learn how to merge copies of a shared workbook to consolidate the changes.

This module will help you with formulas and calculations. We’ll start with learning how to use the Watch Window, where you can monitor results of different areas of your workbook and even different workbooks related to the one you are changing. Then we’ll learn about Excel’s methodology when calculating worksheets. You’ll learn how to set the calculation options for the current workbook and for all workbooks. Finally, we’ll look at the IFERROR function, which can help you evaluate formulas and display specific results if the formula contains an error.

There are many functions available in Excel 2010. This module will introduce you to all of the functions available in the math and trigonometry, date and time, financial, text, cube and statistical functions. We’ll also look at the SUMIF function closely.

There are many functions available in Excel 2010. This module will introduce you to all of the functions available in the math and trigonometry, date and time, financial, text, cube and statistical functions. We’ll also look at the SUMIF function closely.

In this module, you’ll learn how to assign a macro you have created to a command button, which you can easily access each time you want to run the macro. You’ll also learn how to set up a graphical area that causes a macro to run when it is clicked. Similarly, this module explains how to run a macro automatically when a spreadsheet is opened. Finally, you’ll learn how to change a macro.

This module takes a closer look at forms. Really, all Excel spreadsheets are a type of form where you can enter data. However, we’ll take a look at data forms and form controls a little more closely as other ways to collect information with more flexibility. You’ll also learn how to create and use a data form, including adding a new row of data, finding information by navigating or by entering search criteria, and changing or deleting a row of data. Next, we’ll look at some specific examples of using different types of form controls. This module covers the list box control, the combo box control, the spin button control, and the scroll bar control.

In this module, you’ll learn about some advanced chart features. First, we’ll look at the different types of trend lines to help you analyze your data. You’ll also learn how to add a trend line. Then, we’ll take a look at how to plot one of your data series on a secondary axis. Finally, you’ll learn how to save a chart you have formatted to your liking as a chart template to be available for use when creating other new charts.

This module allows you to take a look at some of the tools available when working with PivotTables and PivotCharts. First, we’ll look at each of the tool tabs that are available when you select a PivotTable or PivotChart. Then, you’ll learn more about slicers. You’ll learn how to create a slicer in an existing PivotTable, as well as how to create a standalone slicer to use with other PivotTables. You’ll also learn how to format a slicer and how to disconnect or delete a slicer.

This module introduces you to using the analysis ToolPak Add-in. You’ll also get an introduction to the purpose of each of the tools in the Analysis ToolPak.

Although this workshop is coming to a close, we hope that your journey to improve your Excel skills is just beginning. Please take a moment to review and update your action plan. This will be a key tool to guide your progress in the days, weeks, months, and years to come. We wish you the best of luck on the rest of your travels!