Details
Overview
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.
Course Objective:
You will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.
Upon successful completion of this course, students will be able to:
- Create a basic worksheet by using Microsoft Office Excel 2010
- Perform calculations in an Excel worksheet
- Modify an Excel worksheet
- Format a worksheet
- Print the content of an Excel workbook
- Manage an Excel workbook
Outline
The Career Center Course Curriculum for Microsoft Excel 2010 Level 1:
Lesson 1: Creating a Basic Worksheet
- Topic 1A: Identify the Elements of the User Interface
- Topic 1B: Customize the Excel Interface
- Topic 1C: Work with Cells
- Topic 1D: Enter Data in an Excel Workbook
- Topic 1E: Obtain Help in Excel
Lesson 2: Performing Calculations in an Excel Worksheet
- Topic 2A: Create Basic Formulas
- Topic 2B: Calculate the Cell Values by Using Functions
- Topic 2C: Copy Formulas and Functions
Lesson 3: Modifying an Excel Worksheet
- Topic 3A: Manipulate Data
- Topic 3B: Modify the Worksheet Elements
- Topic 3C: Search for Data in a Worksheet
- Topic 3D: Modify Rows and Columns
Lesson 4: Formatting an Excel Worksheet
- Topic 4A: Modify Fonts
- Topic 4B: Check a Worksheet for Spelling Errors
- Topic 4C: Apply Number Formatting
- Topic 4D: Add Borders and Colors to Cells
- Topic 4E: Align the Content in a Cell
- Topic 4F: Apply Cell Styles
Lesson 5: Printing Excel Workbooks
- Topic 5A: Set the Page Layout Options
- Topic 5B: Set Page Breaks
- Topic 5C: Print a Workbook
Lesson 6: Managing an Excel Workbooks
- Topic 6A: Format Worksheet Tabs
- Topic 6B: Manage Worksheets
- Topic 6C: View Worksheets and Workbooks
The Career Center is a full-service training provider that offers training services in a wide array of courses, including applications such as Microsoft Office, the Adobe Creative Suite, SQL, QuickBooks and AutoCAD.
As a Microsoft Silver Learning Partner we also offer all of the Microsoft Official Courses (MOC) and proudly accept Microsoft Software Assurance Training Vouchers.
The Career Center offers computer courses and hands-on training that helps people of all levels, from beginners to advanced users, increase their computer knowledge & efficiency. Conveniently located on the corner of 34th Street & Madison Avenue, The Career Center offers over 100 public classes in popular softwares.
The Career Center also offers other training solutions including:
- Onsite Training
- Private Corporate Classes
- Private Computer Tutoring
- Lab Rentals
For more information about individual or corporate training, please contact us at your convenience at (212) 684-5151 or [email protected]