Microsoft Excel 2010 - Level 1

Enhance your productivity with Microsoft Excel 2010 - Level 1 by mastering essential skills to create and manage spreadsheets effortlessly, perfect for beginners and business professionals.

Course Thumbnail

Essential Skills Gained

Checkmark

Create basic worksheets using Microsoft Office Excel 2010.

Checkmark

Perform calculations and modify Excel worksheets.

Checkmark

Format and print Excel workbooks effectively.

Checkmark

Manage and organize Excel workbooks efficiently.

Format

  • Instructor-led
  • 1 days with lectures and hands-on labs.

Audience

  • Beginner Excel Users
  • Administrative Assistants
  • Business Professionals
  • Students

Description

You will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Lesson 1: Getting Started with Excel

  1. Identify the Elements of the Excel Interface

  2. Navigate and Select Cells in Worksheets

  3. Customize the Excel Interface

  4. Create a Basic Worksheet

Lesson 2: Performing Calculations in an Excel Worksheet

  1. Create Formulas in a Worksheet

  2. Insert Functions in a Worksheet

  3. Reuse Formulas

Lesson 3: Modifying an Excel Worksheet

  1. Edit Worksheet Data

  2. Find and Replace Data

  3. Manipulate Worksheet Elements

Lesson 4: Modifying the Appearance of a Worksheet

  1. Apply Font Properties

  2. Add Borders and Colors to Cells

  3. Align Content in a Cell

  4. Apply Number Formatting

  5. Apply Cell Styles

Lesson 5: Managing an Excel Workbook

  1. Manage Worksheets

  2. View Worksheets and Workbooks

Lesson 6: Printing Excel Workbooks

  1. Define the Page Layout

  2. Print a Workbook

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.