Excel 2010 Expert
Welcome to the Excel 2010 Expert course. Excel includes some powerful tools to help you manipulate your data. From sharing workbooks to advanced functions and formulas, this course will help you become a true power user of Excel 2010.
Course Objectives
Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly.
By the end of this course, participants should be able to:
- Mark Workbook as Final
- Encrypt with a Password and Restrict Permissions
- Protect the Current Sheet or the Workbook Structure
- Add a Digital Signature
- Set Excel Options
- Manage Versions
- Save a Workbook as an Excel Template
- Inspect Documents
- Share Workbooks
- Edit a Shared Workbook
- Track Changes
- Merge Copies of a Shared Workbook
- Use the Watch Window
- Set Calculation Options
- Enable or Disable Automatic Workbook Calculations
- Use the IFERROR Function to Evaluate Formulas
- Use Array Formulas
- Understand a Variety of different Functions
- Assign Macros to a Command Button on the Ribbon
- Run a Macro by Clicking an Area of a Graphic Object
- Configure a Macro to Run Automatically Upon Opening the Workbook
- Change a Macro
- Insert Form Controls
- Use a data form
- Use Trend Lines
- Add a Secondary Axis
- Use Chart Templates
- Work with PivotTable Tools
- Work with PivotChart Tools
- Use the Slicer
- Choose External Data Sets with the Slicer
- Understand the Analysis ToolPak
Categories
Microsoft Excel