Excel 2010 – Level 3 (Foramatting Cells and Worksheets)

Description

When you have completed this course, you will be able to:

• Create cell content using AutoFill
• Use paste options and perform operations with Paste Special and copy formatting with Paste Special
• Modify existing worksheets, hiding and unhiding rows and columns, hiding and displaying entire worksheets, inserting multiple rows and columns, and moving columns to a different location
• Apply styles to both cells and tables and also learn how to create your own styles
• Add backgrounds, mimic the use of watermarks used in programs such as Word, format rows and columns, and transpose data
• Use proofing tools such as its Spelling Checker, Error Checker, AutoComplete, and AutoCorrect features that can assist you in checking, detecting and avoiding errors
• Create macros to automate repetitive tasks and perform special calculations

Modules:

• Adding Cell Content
• Modifying Worksheets
• Cell and Table Styles
• Formatting Worksheets
• Proofing Tools
• Using Macros

The online course takes approximately 3 hours to complete and is available for six months from the date first accessed.