Excel 2010 - Part 1 - Class Outline

Print Preview \| E-Mail Outline

Excel 2010 - Part 1 Duration: Traditional Instructor Led Learning - 1.00 Day(s) Online Anytime - Self Paced Online Live - 1.00 Sessions Mentored Learning - Flexible Overview: In this course, students will use Microsoft® Office Excel® 2010 to create spreadsheets and workbooks that they can use to store, manipulate, and share data.
Prerequisite(s) or equivalent knowledge:
Windows 2000 - Level 1 Windows XP Professional - Installation and Administration
Prerequisite Comments:
To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders

Outline:	Top
Lesson 1: Getting Started with Microsoft Excel 2010
Identify the Elements of the Excel Interface Create a Basic Worksheet Use the Help System	Top
Lesson 2: Performing Calculations
Create Formulas in a Worksheet Insert Functions in a Worksheet Reuse Formulas
Lesson 3: Modifying a Worksheet
Manipulate Data Insert, Manipulate, and Delete Cells, Columns, and Rows Search for and Replace Data Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
Modify Fonts Add Borders and Color to Cells Apply Number Formats Align Cell Contents Apply Cell Styles
Lesson 5: Printing Workbook Contents
Define the Basic Page Layout for a Workbook Refine the Page Layout and Apply Print Options	Top
Lesson 6: Managing Large Workbooks
Format Worksheet Tabs Manage Worksheets Manage the View of Worksheets and Workbooks
Lesson 7: Customizing the Excel Environment
Customize General and Language Options Customize Formula Options Customize Proofing and Save Options Customize the Ribbon and Quick Access Toolbar Customize the Functionality of Excel by Enabling Add-Ins Customize Advanced and Trust Center Options

*Content, days, and times vary depending on your location. Please view the outline on the checkout page prior to purchase or
contact the local center for more information.