Welcome to TED Learning!

  • 12-07, Binjai 8 Premium SOHO, No. 2 Lorong Binjai, 50450 Kuala Lumpur
  • Phone: +603-2742 1828
  • training@ted.com.my

Ms Excel Beginner 2007/2010 - TED Learning

Introduction

In this level, students will explore the new user interface of Excel 2007/2010, create and edit basic Excel worksheets and workbooks, understand the foundation of formulas, and apply common formatting and printing techniques. This course is suitable for beginners of Microsoft Excel who want to have a proper guidance for a more insightful start-up learning experience.

Prerequisites

To ensure success, each student is expected to have a general knowledge of Microsoft Windows and Microsoft Office concepts.

Course Objectives

At the end of this course, participants should be able to:

  1. Familiar with the fundamental components of Microsoft Excel
  2. Perform calculations with functions and formulas
  3. Manipulate worksheep data
  4. Format a worsheet
  5. Use the printing features of Excel
  6. Differentiate between worksheet and workbook

Course Outline

DAY 1

LESSON 1: INTRODUCTION TO EXCEL 2007/2010

  1. Explore the User Interface and the Ribbon
  2. Customize the Quick Access Toolbar
  3. Understanding Workbooks
  4. Enter and Edit Data

LESSON 2: PERFORMING CALCULATIONS

  1. Understanding Functions
  2. Create Basic Formulas
  3. Calculate with Functions
  4. Absolute and Mixed Cell References

LESSON 3: MODIFYING A WORKSHEET

  1. Manipulate Data
  2. Manage Cells, Columns, and Rows
  3. Finding and Replacing Data in a Worksheet

LESSON 4: FORMATTING A WORKSHEET

  1. Formatting Text
  2. Adding Borders and Color to Cells
  3. Applying Number Formats
  4. Applying Cell Styles

LESSON 5: PRINTING

  1. Print Workbook Contents with Default Print Options
  2. Setting Print Options
  3. Setting Page Breaks
  4. Setting Header Footers

LESSON 6: WORKSHEET AND WORKBOOKS

  1. Using Multiple Windows
  2. Freeze Panes
  3. Custom Views
  4. Format Worksheet Tabs
  5. Manage Worksheets in a Workbook
  6. Grouping and Ungrouping Worksheets
 Register Now

.

.

.

.

.

FEEL FREE TO ENQUIRE ABOUT OUR RANGE OF TRAINING COURSES