관리-도구

편집 파일: 1612163166.M477173P1287.server.saraya-global.com,S=92189,W=94333:2,

Envelope-to: jaisone@saraya.com.my
Delivery-date: Mon, 01 Feb 2021 15:06:06 +0800
Organization: OTC
Message-ID: <4c58e3eef7b89829845dcc9b003a6ef3@powerlearnings.com.my>
From: "linkallp@powerlearnings.com.my" <linkallp@powerlearnings.com.my>
To: "Sir/Madam," <linkallp@powerlearnings.com.my>
Date: Mon, 1 Feb 2021 14:45:08 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="fccf3c959f21f9fbddece9e1001f34c1"
Subject: ***SPAM*** IN HOUSE: MICROSOFT EXCEL-LEVEL 2: INTERMEDIATE LEVEL

--fccf3c959f21f9fbddece9e1001f34c1
Content-Type: text/plain;
	charset="windows-1252"
Content-Transfer-Encoding: quoted-printable

Kindly contact 012-588 2175 for more inquiry

MICROSOFT EXCEL - LEVEL 2:

INTERMEDIATE LEVEL

This program can be specially tailored and customized to meet your =
training=20
objectives

Kindly find above attached for the full brochure for this programs

We hope you find it informative and interesting and we look forward to =
seeing=20
you soon

(HRDF/SBL Claimable)

2 days In-House =
Program=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0 By Patrick

=A0

ABOUT THIS COURSE:

Managing data systematically and logically is very important to produce a =
proper=20
report. The latest Microsoft Excel offers more features and enhancements =
to=20
better manage your spreadsheet. In this Level, we will explore the usage =
of=20
Functions and Table to generate and analyse reports as well as digging =
deeper=20
into the features of selected topics learned in the Basic Level=2E

=A0

COURSE OBJECTIVE:

Upon completion of this program, participants should be able to:

-=A0=A0=A0=A0=A0=A0 Perform various cell locking methods=2E

-=A0=A0=A0=A0=A0=A0 Use various Statistical functions for reporting=2E

-=A0=A0=A0=A0=A0=A0 Use various Logical functions for reporting=2E

-=A0=A0=A0=A0=A0=A0 Use colours to spot important trends and data=2E

-=A0=A0=A0=A0=A0=A0 Apply data filters=2E

-=A0=A0=A0=A0=A0=A0 Apply data standardisation=2E

-=A0=A0=A0=A0=A0=A0 Apply various protection to Workbook and Worksheets

=A0

TARGET AUDIENCE:

This course is suitable for Administrative staff such as Human Resource, =
Sales=20
and Marketing, Technical staff such as Engineers, IT and Analysts as well =
as=20
Managers of all levels=2E

=A0

PREREQUISITE:

Completed Excel Basic Level training or have mastered the following skills:

-=A0=A0=A0=A0=A0=A0 Perform AutoFill=2E

-=A0=A0=A0=A0=A0=A0 Use basic formulas =96 Addition, Subtraction, =
Multiplication and Division=2E

-=A0=A0=A0=A0=A0=A0 Use basic functions =96 AutoSum=2E

-=A0=A0=A0=A0=A0=A0 Create a basic Chart=2E

-=A0=A0=A0=A0=A0=A0 Adjust page layout and print=2E

=A0

METHODOLOGY:

This program will be conducted through interactive lectures, practical =
exercises=20
and group assignments=2E

=A0

Outline Of Workshop

Chapter 1: Using Excel Functions

Lesson 1.1: Locking Cell References

-=A0=A0=A0=A0=A0=A0 Relative vs Absolute Cell References

-=A0=A0=A0=A0=A0=A0 Mixed Cell References

=A0

Chapter 2: Working with Functions=20

=A0

Lesson 2.1: Obtain Statistical Report

-=A0=A0=A0=A0=A0=A0 SUMIF Function

-=A0=A0=A0=A0=A0=A0 COUNTIF Function

-=A0=A0=A0=A0=A0=A0 AVERAGEIF Function

=A0

Lesson 2.2: Testing Data

-=A0=A0=A0=A0=A0=A0 IF Function

-=A0=A0=A0=A0=A0=A0 IFERROR Function

-=A0=A0=A0=A0=A0=A0 Nested IF Function

=A0

Lesson 2.3: Name Manager=20

-=A0=A0=A0=A0=A0=A0 Naming a Cell=20

-=A0=A0=A0=A0=A0=A0 Naming a Range

-=A0=A0=A0=A0=A0=A0 Using Names in Formula

-=A0=A0=A0=A0=A0=A0 Editing Names

-=A0=A0=A0=A0=A0=A0 Using 3D Formulas

=A0

Lesson 2.4: Formula Auditing

-=A0=A0=A0=A0=A0=A0 Trace Precedent

-=A0=A0=A0=A0=A0=A0 Trace Dependent

-=A0=A0=A0=A0=A0=A0 Displaying Formulas

-=A0=A0=A0=A0=A0=A0 Checking Formula Errors

=A0

Chapter 3: Using Table

=A0

Lesson 3.1: Working with Table

-=A0=A0=A0=A0=A0=A0 Creating a Table=20

-=A0=A0=A0=A0=A0=A0 Using the Table Tools

-=A0=A0=A0=A0=A0=A0 Formatting Table

-=A0=A0=A0=A0=A0=A0 Table Style Options

-=A0=A0=A0=A0=A0=A0 Adding Total Row

-=A0=A0=A0=A0=A0=A0 Removing Duplicate Records

-=A0=A0=A0=A0=A0=A0 Convert Table back as Range

=A0Lesson 3.2: Filtering Data=20

-=A0=A0=A0=A0=A0=A0 AutoFilter

-=A0=A0=A0=A0=A0=A0 Custom AutoFilter

-=A0=A0=A0=A0=A0=A0 Wildcard Filter

-=A0=A0=A0=A0=A0=A0 Advanced Filter

=A0

Chapter 4: Styling your Report

Lesson 4.1: Conditional Formatting=20

-=A0=A0=A0=A0=A0=A0 Highlight Cells Rules

-=A0=A0=A0=A0=A0=A0 Top / Bottom Rules

-=A0=A0=A0=A0=A0=A0 Using Bars, Color Scales & Icon Sets

-=A0=A0=A0=A0=A0=A0 Adding Multiple Rules

-=A0=A0=A0=A0=A0=A0 Editing Existing Rules

-=A0=A0=A0=A0=A0=A0 Sequencing Rules

-=A0=A0=A0=A0=A0=A0 Creating Rules using Formula

=A0

Lesson 4.2: Using Cell Styles

-=A0=A0=A0=A0=A0=A0 Applying Cell Styles

-=A0=A0=A0=A0=A0=A0 Editing Cell Styles

-=A0=A0=A0=A0=A0=A0 Creating New Cell Style

-=A0=A0=A0=A0=A0=A0 Merging Cell Styles

=A0

Lesson 4.3: Charts =96 Part 2

-=A0=A0=A0=A0=A0=A0 Adding Formulas to Report

-=A0=A0=A0=A0=A0=A0 Creating a Combo Chart

-=A0=A0=A0=A0=A0=A0 Manipulating Chart Display

=A0

Chapter 5: Managing Data =96 Part 2

=A0

Lesson 5.1: Custom AutoFill

-=A0=A0=A0=A0=A0=A0 Creating a Custom List

-=A0=A0=A0=A0=A0=A0 Using Custom Lists

-=A0=A0=A0=A0=A0=A0 Importing a Custom List

-=A0=A0=A0=A0=A0=A0 Modifying Custom Lists

=A0

Lesson 5.2: Find & Replace

-=A0=A0=A0=A0=A0=A0 Find & Replace Symbols

-=A0=A0=A0=A0=A0=A0 Find & Replace Format

=A0

Chapter 6:=A0Managing Data =96 Part 3

=A0

Lesson 6.1: Data Validation

-=A0=A0=A0=A0=A0=A0 Apply basic Data Validation

-=A0=A0=A0=A0=A0=A0 Edit Validation settings

-=A0=A0=A0=A0=A0=A0 Using Formulas as Data Validation=20

=A0Lesson 6.2: Excel Windows

-=A0=A0=A0=A0=A0=A0 Freezing the Window Panes

-=A0=A0=A0=A0=A0=A0 Opening a New Window

-=A0=A0=A0=A0=A0=A0 Arranging Multiple Windows

-=A0=A0=A0=A0=A0=A0 Splitting Windows

=A0Lesson 6.3: Protecting Excel Files

-=A0=A0=A0=A0=A0=A0 Apply Protection to Workbook

-=A0=A0=A0=A0=A0=A0 Apply Protection to Worksheets

-=A0=A0=A0=A0=A0=A0 Apply Protection with Unlocked Cells

-=A0=A0=A0=A0=A0=A0 Apply Protection with Editing Rights

-=A0=A0=A0=A0=A0=A0 Apply Password to Open the File

=A0

ABOUT THE FACILITATOR=20

=A0

Patrick=20

MOS, Microsoft

ACS, ALB, Toastmasters International=20

=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=
=97=97=97=97=97=97=97=97=97=97=97=97=97=97

Patrick has been involved in the IT and Training industry since 2002. He =
is=20
very passionate about sharing practical knowledge and providing technical =
solutions.=20
His training involves interactive lectures, group assignments and =
presentations.=20
A Microsoft Certified Trainer and also a member of the Toastmasters =
International,=20
he has conducted trainings since 2005 to clients from various sectors. =
Patrick=20
is also involved in writing online IT articles=2E

=A0

Professional Certifications=A0=A0=20

1.Train-the-Trainer: Pembangunan Sumber Manusia Bhd (TTT/2960)

2.Teaching Methodology for Facilitator: International Islamic University =
Malaysia

3.Microsoft Office Specialist (MOS): Microsoft

4.Microsoft Certified Trainer (MCT): Microsoft

5.Advanced Communicator Silver (ACS): Toastmasters International

6.Advanced Leader Bronze (ALB): Toastmasters International

7.Level 1 Presentation Mastery: Toastmasters International

=A0 =A0

=A0

We hope you find it informative and interesting and we look

forward to seeing you soon=2E

Please act fast to grab your favourite training program! Please call =
012-588=20
2175

=A0

Do forward this email to all your friends and colleagues who might be =
interested=20
to attend these programs

=A0

If you would like to unsubscribe from our email list at any time, please =
simply=20
reply to the e-mail and type

Unsubscribein the subject area. We will remove your name from the list =
and=20
you will not receive any additional e-mail

=A0

Thanks

=A0

Regards

Paris Oo
Mobile No. : 012-5882175

=A0

--fccf3c959f21f9fbddece9e1001f34c1
Content-Type: text/html;
	charset="windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content=3D"text/html; charset=3D" http-equiv=3D"content-type">
</head>
<body style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma, Tahoma">
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
#7030a0; mso-ansi-language: EN-MY'>Kindly=20
contact 012-588 2175 for more inquiry<?xml:namespace prefix =3D "o" ns =
=3D=20
"urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 22pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
blue; mso-ansi-language: EN-MY'>MICROSOFT=20
EXCEL - LEVEL 2:<o:p></o:p>
INTERMEDIATE=20
LEVEL<o:p></o:p>
This=20
program can be specially tailored and customized to meet your training=20
objectives<o:p></o:p>
<font=20
size=3D3>Kindly find above attached for the full brochure for this=20
programs<o:p></o:p>
We hope=20
you find it informative and interesting and we look forward to seeing you=20
soon<o:p></o:p>
<font=20
size=3D3>(HRDF/SBL Claimable)<o:p></o:p>
<font=20
size=3D3>2 days In-House=20
Program&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;=20
By Patrick<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-FAMILY: "Times New Roman",serif; mso-ansi-language: =
EN-MY'><o:p><font=20
size=3D3>&nbsp;</o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>ABOUT=20
THIS COURSE:<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>Managing=20
data systematically and logically is very important to produce a proper =
report.=20
The latest Microsoft Excel offers more features and enhancements to =
better=20
manage your spreadsheet. In this Level, we will explore the usage of =
Functions=20
and Table to generate and analyse reports as well as digging deeper into =
the=20
features of selected topics learned in the Basic =
Level.<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'><o:p><span=20
style=3D"TEXT-DECORATION: none">&nbsp;</o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>COURSE=20
OBJECTIVE:<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>Upon=20
completion of this program, participants should be able=20
to:<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
mso-ansi-language: EN-MY; mso-fareast-font-family: Arial'><span=20
style=3D"mso-list: Ignore">-<span=20
style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Perform=20
various cell locking methods.<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
mso-ansi-language: EN-MY; mso-fareast-font-family: Arial'><span=20
style=3D"mso-list: Ignore">-<span=20
style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Use=20
various Statistical functions for reporting.<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
mso-ansi-language: EN-MY; mso-fareast-font-family: Arial'><span=20
style=3D"mso-list: Ignore">-<span=20
style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Use=20
various Logical functions for reporting.<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
mso-ansi-language: EN-MY; mso-fareast-font-family: Arial'><span=20
style=3D"mso-list: Ignore">-<span=20
style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Use=20
colours to spot important trends and data.<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
mso-ansi-language: EN-MY; mso-fareast-font-family: Arial'><span=20
style=3D"mso-list: Ignore">-<span=20
style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Apply=20
data filters.<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
mso-ansi-language: EN-MY; mso-fareast-font-family: Arial'><span=20
style=3D"mso-list: Ignore">-<span=20
style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Apply=20
data standardisation.<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
mso-ansi-language: EN-MY; mso-fareast-font-family: Arial'><span=20
style=3D"mso-list: Ignore">-<span=20
style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Apply=20
various protection to Workbook and Worksheets<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'><o:p><span=20
style=3D"TEXT-DECORATION: none">&nbsp;</o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>TARGET=20
AUDIENCE:<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>This=20
course is suitable for Administrative staff such as Human Resource, Sales =
and=20
Marketing, Technical staff such as Engineers, IT and Analysts as well as=20
Managers of all levels.<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'><o:p><span=20
style=3D"TEXT-DECORATION: none">&nbsp;</o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>PREREQUISITE:<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'><o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>Completed=20
Excel Basic Level training or have mastered the following=20
skills:<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
mso-ansi-language: EN-MY; mso-fareast-font-family: Arial'><span=20
style=3D"mso-list: Ignore">-<span=20
style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Perform=20
AutoFill.<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
mso-ansi-language: EN-MY; mso-fareast-font-family: Arial'><span=20
style=3D"mso-list: Ignore">-<span=20
style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Use=20
basic formulas =96 Addition, Subtraction, Multiplication and=20
Division.<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
mso-ansi-language: EN-MY; mso-fareast-font-family: Arial'><span=20
style=3D"mso-list: Ignore">-<span=20
style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Use=20
basic functions =96 AutoSum.<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
mso-ansi-language: EN-MY; mso-fareast-font-family: Arial'><span=20
style=3D"mso-list: Ignore">-<span=20
style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Create=20
a basic Chart.<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
mso-ansi-language: EN-MY; mso-fareast-font-family: Arial'><span=20
style=3D"mso-list: Ignore">-<span=20
style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Adjust=20
page layout and print.<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'><o:p><span=20
style=3D"TEXT-DECORATION: none">&nbsp;</o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>METHODOLOGY:<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
mso-ansi-language: EN-MY'>This=20
program will be conducted through interactive lectures, practical =
exercises and=20
group assignments.<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
BACKGROUND: white; LINE-HEIGHT: 115%; mso-ansi-language: =
EN-MY'><o:p>&nbsp;</o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
BACKGROUND: white; COLOR: black; LINE-HEIGHT: 115%; mso-ansi-language: =
EN-MY'>Outline=20
Of Workshop<o:p></o:p>
<div align=3Dcenter>
<table class=3DMsoNormalTable=20
style=3D"BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; =
mso-padding-alt: 0in 0in 0in 0in"=20
cellSpacing=3D0 cellPadding=3D0 border=3D0>
 =20
 <tr=20
 style=3D"HEIGHT: 88.5pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes; =
mso-yfti-lastrow: yes">
 <td=20
 style=3D"BORDER-TOP: windowtext 1pt solid; HEIGHT: 88.5pt; =
BORDER-RIGHT: windowtext 1pt solid; WIDTH: 521.75pt; BORDER-BOTTOM: =
windowtext 1pt solid; PADDING-BOTTOM: 0in; PADDING-TOP: 0in; PADDING-LEFT: =
5.4pt; BORDER-LEFT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BACKGROUND-COLOR: transparent"=20
 vAlign=3Dtop width=3D696>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: #004376'>Chapter=20
 1: Using Excel Functions<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>Lesson=20
 1.1: Locking Cell References<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Relative=20
 vs Absolute Cell References<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Mixed=20
 Cell References<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: #004376; LINE-HEIGHT: 115%'>Chapter=20
 2: Working with Functions <o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>Lesson=20
 2.1: Obtain Statistical Report<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>SUMIF=20
 Function<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>COUNTIF=20
 Function<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>AVERAGEIF=20
 Function<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>Lesson=20
 2.2: Testing Data<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>IF=20
 Function<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>IFERROR=20
 Function<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Nested=20
 IF Function<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>Lesson=20
 2.3: Name Manager <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Naming=20
 a Cell <o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Naming=20
 a Range<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Using=20
 Names in Formula<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Editing=20
 Names<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Using=20
 3D Formulas<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>Lesson=20
 2.4: Formula Auditing<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Trace=20
 Precedent<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Trace=20
 Dependent<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Displaying=20
 Formulas<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Checking=20
 Formula Errors<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: #004376; LINE-HEIGHT: 115%'>Chapter=20
 3: Using Table<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>Lesson=20
 3.1: Working with Table<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Creating=20
 a Table <o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Using=20
 the Table Tools<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Formatting=20
 Table<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Table=20
 Style Options<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Adding=20
 Total Row<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Removing=20
 Duplicate Records<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Convert=20
 Table back as Range<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;Lesson=20
 3.2: Filtering Data <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>AutoFilter<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Custom=20
 AutoFilter<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Wildcard=20
 Filter<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Advanced=20
 Filter<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p>&nbsp;</o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New =
Roman",serif'><o:p>&nbsp;</o:p></td>
 <td=20
 style=3D"BORDER-TOP: windowtext 1pt solid; HEIGHT: 88.5pt; =
BORDER-RIGHT: windowtext 1pt solid; WIDTH: 510.15pt; BORDER-BOTTOM: =
windowtext 1pt solid; PADDING-BOTTOM: 0in; PADDING-TOP: 0in; PADDING-LEFT: =
5.4pt; BORDER-LEFT: #f0f0f0; PADDING-RIGHT: 5.4pt; BACKGROUND-COLOR: =
transparent"=20
 vAlign=3Dtop width=3D680>
 <p=20
 style=3D"TEXT-ALIGN: justify; MARGIN-LEFT: 19.7pt; TEXT-AUTOSPACE: =
ideograph-numeric; TEXT-INDENT: -19.7pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: #004376'>Chapter=20
 4: Styling your Report<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>Lesson=20
 4.1: Conditional Formatting <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Highlight=20
 Cells Rules<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Top=20
 / Bottom Rules<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Using=20
 Bars, Color Scales &amp; Icon Sets<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Adding=20
 Multiple Rules<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Editing=20
 Existing Rules<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Sequencing=20
 Rules<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Creating=20
 Rules using Formula<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>Lesson=20
 4.2: Using Cell Styles<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Applying=20
 Cell Styles<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Editing=20
 Cell Styles<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Creating=20
 New Cell Style<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Merging=20
 Cell Styles<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>Lesson=20
 4.3: Charts =96 Part 2<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Adding=20
 Formulas to Report<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Creating=20
 a Combo Chart<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Manipulating=20
 Chart Display<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: #004376; LINE-HEIGHT: 115%'>Chapter=20
 5: Managing Data =96 Part 2<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>Lesson=20
 5.1: Custom AutoFill<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Creating=20
 a Custom List<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Using=20
 Custom Lists<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Importing=20
 a Custom List<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Modifying=20
 Custom Lists<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>Lesson=20
 5.2: Find &amp; Replace<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Find=20
 &amp; Replace Symbols<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Find=20
 &amp; Replace Format<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: #004376; LINE-HEIGHT: 115%'>Chapter=20
 6:<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: #004376; LINE-HEIGHT: 115%'>&nbsp;Managing=20
 Data =96 Part 3<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>Lesson=20
 6.1: Data Validation<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Apply=20
 basic Data Validation<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Edit=20
 Validation settings<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Using=20
 Formulas as Data Validation <o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;Lesson=20
 6.2: Excel Windows<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Freezing=20
 the Window Panes<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Opening=20
 a New Window<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Arranging=20
 Multiple Windows<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Splitting=20
 Windows<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
COLOR: black; LINE-HEIGHT: 115%'>&nbsp;Lesson=20
 6.3: Protecting Excel Files<span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 115%'><o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Apply=20
 Protection to Workbook<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Apply=20
 Protection to Worksheets<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Apply=20
 Protection with Unlocked Cells<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Apply=20
 Protection with Editing Rights<o:p></o:p>
 <p=20
 style=3D"MARGIN-LEFT: 20.9pt; LINE-HEIGHT: 105%; TEXT-INDENT: =
-20.9pt; mso-list: l1 level1 lfo3; tab-stops: list 21.0pt"><span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Arial",sans-serif; =
LINE-HEIGHT: 105%; mso-fareast-font-family: Arial; mso-bidi-font-weight: =
bold'><span=20
 style=3D"mso-list: Ignore">-<span=20
 style=3D'FONT: 7pt "Times New =
Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'>Apply=20
 Password to Open the File<o:p></o:p>
 <span=20
 style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; =
LINE-HEIGHT: 105%'><o:p><span=20
 style=3D"TEXT-DECORATION: =
none">&nbsp;</o:p></td></tr></table></div>
<span=20
lang=3DEN-MY=20
style=3D"BACKGROUND: white; COLOR: black; mso-ansi-language: =
EN-MY"><o:p><font=20
size=3D3 face=3D"Times New Roman">&nbsp;</o:p>
<font=20
size=3D3>ABOUT =
THE=20
FACILITATOR <o:p></o:p>
<font=20
size=3D3>&nbsp;<span=20
lang=3DEN-MY=20
style=3D"BACKGROUND: white; mso-ansi-language: =
EN-MY"><o:p></o:p>
Patrick=20
<o:p></o:p>
MOS,=20
Microsoft<o:p></o:p>
ACS,=20
ALB, Toastmasters International <o:p></o:p>
=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=
=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97=97<o:p></o:p>
Patrick=20
has been involved in the IT and Training industry since 2002. He is very=20
passionate about sharing practical knowledge and providing technical =
solutions.=20
His training involves interactive lectures, group assignments and =
presentations.=20
A Microsoft Certified Trainer and also a member of the Toastmasters=20
International, he has conducted trainings since 2005 to clients from =
various=20
sectors. Patrick is also involved in writing online IT=20
articles.<o:p></o:p>
<o:p><span=20
style=3D"TEXT-DECORATION: none">&nbsp;</o:p>
Professional=20
Certifications&nbsp;&nbsp; <o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
#0d0d0d; LINE-HEIGHT: 115%; mso-ansi-language: EN-MY'>1.<span=20
lang=3DEN-MY=20
style=3D"FONT-SIZE: 10pt; COLOR: black; LINE-HEIGHT: 115%; =
mso-ansi-language: EN-MY"><font=20
face=3DCalibri> Train-the-Trainer:=20
Pembangunan Sumber Manusia Bhd (TTT/2960)<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
#0d0d0d; LINE-HEIGHT: 115%; mso-ansi-language: EN-MY'>2.<span=20
lang=3DEN-MY=20
style=3D"FONT-SIZE: 10pt; COLOR: black; LINE-HEIGHT: 115%; =
mso-ansi-language: EN-MY"><font=20
face=3DCalibri> Teaching=20
Methodology for Facilitator: International Islamic University=20
Malaysia<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
#0d0d0d; LINE-HEIGHT: 115%; mso-ansi-language: EN-MY'>3.<span=20
lang=3DEN-MY=20
style=3D"FONT-SIZE: 10pt; COLOR: black; LINE-HEIGHT: 115%; =
mso-ansi-language: EN-MY"><font=20
face=3DCalibri> Microsoft=20
Office Specialist (MOS): Microsoft<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
#0d0d0d; LINE-HEIGHT: 115%; mso-ansi-language: EN-MY'>4.<span=20
lang=3DEN-MY=20
style=3D"FONT-SIZE: 10pt; COLOR: black; LINE-HEIGHT: 115%; =
mso-ansi-language: EN-MY"><font=20
face=3DCalibri> Microsoft=20
Certified Trainer (MCT): Microsoft<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
#0d0d0d; LINE-HEIGHT: 115%; mso-ansi-language: EN-MY'>5.<span=20
lang=3DEN-MY=20
style=3D"FONT-SIZE: 10pt; COLOR: black; LINE-HEIGHT: 115%; =
mso-ansi-language: EN-MY"><font=20
face=3DCalibri> Advanced=20
Communicator Silver (ACS): Toastmasters International<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
#0d0d0d; LINE-HEIGHT: 115%; mso-ansi-language: EN-MY'>6.<span=20
lang=3DEN-MY=20
style=3D"FONT-SIZE: 10pt; COLOR: black; LINE-HEIGHT: 115%; =
mso-ansi-language: EN-MY"><font=20
face=3DCalibri> Advanced=20
Leader Bronze (ALB): Toastmasters International<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D'FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman",serif; COLOR: =
#0d0d0d; LINE-HEIGHT: 115%; mso-ansi-language: EN-MY'>7.<span=20
lang=3DEN-MY=20
style=3D"FONT-SIZE: 10pt; COLOR: black; LINE-HEIGHT: 115%; =
mso-ansi-language: EN-MY"><font=20
face=3DCalibri> Level=20
1 Presentation Mastery: Toastmasters International<o:p></o:p>
<span=20
lang=3DEN-MY=20
style=3D"FONT-SIZE: 10pt; COLOR: black; LINE-HEIGHT: 115%; =
mso-ansi-language: EN-MY"><font=20
face=3DCalibri>&nbsp; &nbsp;<span=20
lang=3DEN-MY style=3D"mso-ansi-language: EN-MY"><o:p></o:p>
<font=20
size=3D3><o:p></o:p>&nbsp;
<font=20
size=3D3>We hope you find it informative and interesting and we=20
look<o:p></o:p>
<font=20
size=3D3>forward to seeing you soon.<o:p></o:p>
<font=20
size=3D3>Please act fast to grab your favourite training program! =
Please call=20
012-588 2175<o:p></o:p>
<o:p><font=20
size=3D3></o:p>&nbsp;
<font=20
size=3D3>Do forward this email to all your friends and colleagues who =
might be=20
interested to attend these programs<o:p></o:p>
<o:p><font=20
size=3D3>&nbsp;</o:p>
<font=20
size=3D3>If you would like to unsubscribe from our email list at any time, =
please=20
simply reply to the e-mail and type<o:p></o:p>
Unsubscribe<span=20
lang=3DEN-MY=20
style=3D'FONT-FAMILY: "Times New Roman",serif; BACKGROUND: white; COLOR: =
#c00000; mso-ansi-language: EN-MY'>=20
in the subject area. We will remove your name from the list and you will =
not=20
receive any additional e-mail<o:p></o:p>
<o:p>&nbsp;</o:p>
<o:p>&nbsp;</o:p>
<o:p>&nbsp;</o:p>
<o:p>&nbsp;</o:p>
<font=20
size=3D3>Thanks<o:p></o:p>
<o:p><font=20
size=3D3 face=3DCalibri>&nbsp;</o:p>
<font=20
size=3D3>Regards<o:p></o:p>
Paris=20
Oo<span=20
style=3D"COLOR: black"> Mobile No. : =
012-588<span=20
lang=3DEN-GB style=3D"mso-ansi-language: EN-GB"> <span=20
style=3D"COLOR: black">2175<span=20
style=3D"COLOR: black"><o:p></o:p>
<span=20
lang=3DEN-GB style=3D"COLOR: black; mso-ansi-language: =
EN-GB"><span=20
style=3D"FONT-SIZE: 12pt; COLOR: =
black"><o:p></o:p>&nbsp;
<o:p>&nbsp;</o:p>
<o:p><font=20
size=3D3>&nbsp;</o:p>
<o:p>&nbsp;</o:p>

</body>
</html>

--fccf3c959f21f9fbddece9e1001f34c1--