Microsoft^® Excel for Beginners

“Get started with Microsoft Excel for more insightful learning experience!”

By TED Integrated

PSMB Certified Training Provider

Request for In-house Training	Public program not yet available Register for Public Training
training@ted.com.my darrel@ted.com.my	+603-2386-7788 +6017-2000-933

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:

• Familiar with the fundamental components of Microsoft Excel
• Perform calculations with functions and formulas
• Manipulate worksheep data
• Format a worsheet
• Use the printing features of Excel
• Differentiate between worksheet and workbook

Course Outline

Lesson 1: Introduction to Excel 2007/2010

• Explore the User Interface and the Ribbon
• Customize the Quick Access Toolbar
• Understanding Workbooks
• Enter and Edit Data

Lesson 2: Performing Calculations

• Understanding Functions
• Create Basic Formulas
• Calculate with Functions
• Absolute and Mixed Cell References

Lesson 3: Modifying a Worksheet

• Manipulate Data
• Manage Cells, Columns, and Rows
• Finding and Replacing Data in a Worksheet

Lesson 4: Formatting a Worksheet

• Formatting Text
• Adding Borders and Color to Cells
• Applying Number Formats
• Applying Cell Styles

Lesson 5: Printing

• Print Workbook Contents with Default Print Options
• Setting Print Options
• Setting Page Breaks
• Setting Header Footers

Lesson 6: Worksheet and Workbooks

• Using Multiple Windows
• Freeze Panes
• Custom Views
• Format Worksheet Tabs
• Manage Worksheets in a Workbook
• Grouping and Ungrouping Worksheets

Request for Quotation Now

	+603-2386-7788, +6017-2000-933
	training@ted.com.my , darrel@ted.com.my