In this course, students will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.
Who Should Attend?
This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.
Upon successful completion of this course, students will be able to:
- Create a basic worksheet by using Microsoft Excel 2010. - Perform calculations in an Excel worksheet. - Modify an Excel worksheet. - Modify the appearance of data within a worksheet. - Manage Excel workbooks. - Print the content of an Excel worksheet.
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.
It is recommended that delegates attend the following courses before attending the Microsoft Excel 2010 Level 1 course:
- Windows 2000 -Level 1 - Windows XP Professional - Installation and Administration
Lesson 1: Getting Started with Excel
- Identify the Elements of the Excel Interface - Navigate and Select Cells in Worksheets - Customize the Excel Interface - Create a Basic Worksheet
Lesson 2: Performing Calculations in an Excel Worksheet
- Create Formulas in a Worksheet - Insert Functions in a Worksheet - Reuse Formulas
Lesson 3: Modifying an Excel Worksheet
- Edit Worksheet Data - Find and Replace Data - Manipulate Worksheet Elements
Lesson 4: Modifying the Appearance of a Worksheet
- Apply Font Properties - Add Borders and Colors to Cells - Align Content in a Cell - Apply Number Formatting - Apply Cell Styles
Lesson 5: Managing an Excel Workbook
- Manage Worksheets - View Worksheets and Workbooks
Lesson 6: Printing Excel Workbooks
- Define the Page Layout - Print a Workbook
The course either has new dates in data loading, or is only run as a dedicated or In Company course.