Excel 2010 Advanced
Welcome to the Microsoft Excel 2010 Advanced course. Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into useable information – and better information leads to better decision making!
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:
- Insert SmartArt
- Add text to a diagram
- Resize and move a diagram
- Reset a diagram
- Understand the contextual tabs
- Add pictures from your computer
- Add Clip Art
- Add text boxes
- Draw shapes
- Trace precedent cells
- Trace dependents of a cell
- Display formulas within the sheet
- Work with comments
- Insert a chart
- Use the Chart Tools tab
- Understand the parts of a chart
- Change the chart style
- Resize and move a chart
- Insert a Pivot Table
- Use the Pivot Table Tools tab
- Choose fields and group data in a Pivot Table
- Change Pivot Table data and refresh the view
- Apply a Style to a Pivot table
- Use Real-life examples in a Pivot Table
- Create a Pivot Chart from a Pivot Table
- Create a Pivot Chart from Data
- Display the Developer tab
- Record and run macros
- Change the security level
- Customize and Change the Quick Access Toolbar
- Use named ranges in formulas
- Understand formula errors
- Trace dependents and precedents in formulas
- Use the Trace Errors Commands
- Evaluate formulas
- Use Goal Seek
- Use the Scenario Manager
- Use a One Input Data Table
- Use a Two Input Data Table
- Transposing Data from rows to columns
- Use the Text to Columns feature
- Check for duplicates
- Create data validation rules
- Consolidate Data
- Group Data
- Add Subtotals
- Outline Data view Grouped and Outlined Data
Categories
Microsoft Excel