SkillSoft Explore Course – Lambers, Inc.

Collections Essentials Microsoft Office 2010: Beginning Excel (No Assessments)

It's possible to manually edit data in Excel; however, this can become tedious, especially with a lot of data. Work smarter, not harder, by exploring various methods for efficiently and effectively inserting and manipulating data in Excel.

Asset ID	ds_msex2010_03_enus
Course Type	Video Course
Course Category	Essentials

Objectives
Excel 2010: Manipulating Data Selecting cells Inputting data Inserting special characters Editing multiple worksheets simultaneously Deleting items in your spreadsheet Undoing & redoing actions Creating automatic data series Using the AutoComplete function Inserting dropdown menus Using the spell check tool Using AutoCorrect Transferring data Transferring data between sheets Copying & pasting values Transposing data Consolidating your data

Objectives

Excel 2010: Manipulating Data

Selecting cells
Inputting data
Inserting special characters
Editing multiple worksheets simultaneously
Deleting items in your spreadsheet
Undoing & redoing actions
Creating automatic data series
Using the AutoComplete function
Inserting dropdown menus
Using the spell check tool
Using AutoCorrect
Transferring data
Transferring data between sheets
Copying & pasting values
Transposing data
Consolidating your data