Contents
Students will be able to:
1) Create and edit worksheets2) Format worksheet data3) Insert charts and graphics
Introduction
Introduction to Excel 2010
Setting Excel Options
Creating a New Workbook
Adding and Moving Data in a Worksheet
Lab: Creating a Worksheet and Adding Data
Modifying a Worksheet
Working with Worksheets
Adding Formulas
Lab: Manipulating Worksheets
Printing a Worksheet
Self Test
Modifying the Formatting of Cells
Using Borders and Margins
Lab: Formatting Cell Data
Introduction to Excel Table Styles
Sorting and Filtering a Data List
Reviewing Workbook Data
Using Proofing Tools
Creating and Editing Charts
Formatting Charts
Lab: Creating and Formatting Charts
Working with Shapes
Inserting Graphics
Inserting Objects in a Worksheet
Lab: Adding Graphics to a Worksheet
1)Enhance Excel 2010 workbooks.
2)Work with worksheet data.
3)Work with tables and charts.
4)Use the advanced features of Excel 2010
Modifying Worksheets
Adding Headers and Footers
Editing Worksheets
Working with Office Themes
Formatting and Editing Cells
Conditional Formatting
Inserting Hyperlinks
Formatting Cell Data
Extending a Data Series
Analyzing Data by Using Data Lists
Cleaning Up and Outlining Data Lists
Using What-If Analysis
Performing Calculations
Working with Data Lists
Creating and Editing Pivot Tables
Formatting PivotTables
Analyzing PivotTable Data
Working with a PivotTable
Working with PivotCharts
Editing Charts
Using Table Styles
Using PivotTables
Setting Workbook Properties
Customizing the Ribbon
Customizing the Quick Access Toolbar
The Track Changes Feature
Linking and Embedding Objects
Sharing a Workbook
Working with the Advanced Features
1)Customize Excel 2010.
3)Work with external data.
4)Work with tables and charts.
5)Automate workbooks.
Setting Excel 2010 Options
Defining Workbook Protection Levels
Customizing Worksheet Views
Manipulating Worksheet Data
Creating Named Ranges
Managing Named Ranges
Inserting Equations
Analyzing Data
Working with a PowerPivot Workbook
Lab: Working with Worksheet Data
Defining and Editing External Data Connections
Working with XML Data
Creating and Editing Web Queries
Lab: Working with External Data
Working with Charts
Creating a Sparkline Chart
Creating Different Types of Charts
Adding Trendline to a Chart
Analyzing Pivot Table Data
Lab: Working with Tables and Charts
Introduction to Macros
Creating a Macro
Editing a Macro
Running and Deleting a Macro
Lab: Working with Macros