Microsoft Excel level 3

Course details

Audience Profile

• This course is intended for novice information workers who want to learn advanced-level Excel 2010 skills.

At Course Completion

After completing this course, students will be able to:

• Define an alternative data set.
• Define multiple alternative data sets.
• Vary your data to get a desired result by using Goal Seek.
• Find optimal solutions by using Solver.
• Analyze data by using descriptive statistics.
• Analyze data dynamically by using PivotTables.
• Filter, show, and hide PivotTable data.
• Edit PivotTables.
• Format PivotTables.
• Create PivotTables from external data.
• Create charts.
• Customize the appearance of charts.
• Find trends in your data.
• Summarize your data by using sparklines.
• Create dynamic charts by using PivotCharts.
• Create diagrams by using SmartArt.
• Create shapes and mathematical equations.
• Enable and examine macros.
• Create and modify macros.
• Run macros when a button is clicked.
• Run macros when a workbook is opened.
• Include Office documents in workbooks.
• Store workbooks as parts of other Office documents.
• Create hyperlinks.
• Paste charts into other documents.
• Share workbooks.
• Manage comments.
• Track and manage colleagues’ changes.
• Protect workbooks and worksheets.
• Authenticate workbooks.
• Save workbooks for the Web.