<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
h1
{mso-style-priority:9;
mso-style-link:"Heading 1 Char";
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:24.0pt;
font-family:"Calibri",sans-serif;
font-weight:bold;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
p.indent-1, li.indent-1, div.indent-1
{mso-style-name:indent-1;
margin:0in;
text-indent:-12.0pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.Heading1Char
{mso-style-name:"Heading 1 Char";
mso-style-priority:9;
mso-style-link:"Heading 1";
font-family:"Calibri Light",sans-serif;
color:#2F5496;}
span.EmailStyle25
{mso-style-type:personal-reply;
font-family:"Arial",sans-serif;
color:windowtext;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:306513695;
mso-list-template-ids:-792423756;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1
{mso-list-id:407772647;
mso-list-template-ids:-1435191926;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2
{mso-list-id:782306153;
mso-list-template-ids:-418229688;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l2:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3
{mso-list-id:789318813;
mso-list-template-ids:607934238;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l3:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4
{mso-list-id:992754998;
mso-list-template-ids:70556686;}
@list l4:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l4:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l5
{mso-list-id:1129856480;
mso-list-template-ids:-369050128;}
@list l5:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l5:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l5:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l5:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l5:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l5:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l5:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l5:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l6
{mso-list-id:1328677082;
mso-list-template-ids:-1609804992;}
@list l6:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l6:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l6:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l6:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l6:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l6:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l6:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l6:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l6:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7
{mso-list-id:1485001730;
mso-list-template-ids:753026554;}
@list l7:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l7:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l7:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l8
{mso-list-id:1796362106;
mso-list-template-ids:1760583754;}
@list l8:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l8:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l8:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l8:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l8:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l8:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l8:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l8:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l8:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal" align="center" style="margin-bottom:12.0pt;text-align:center">
<b><span style="font-family:"Arial",sans-serif;color:#1F497D">Welcome to the latest issue of Tech-Talk!<o:p></o:p></span></b></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-family:"Arial",sans-serif;color:#1F497D">Reminder:
</span></b><span style="font-family:"Arial",sans-serif;color:#1F497D">When accessing resources at the
<a href="https://www.tech-talk.com/login/oregon">Tech-Talk website</a>, use ORLIBTECH<br>
for <b>both</b> the username and password when prompted.</span><span style="font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="margin-bottom:12.0pt;text-align:center">
<b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Tech-Talk is a paid subscription service for staff of Oregon libraries and is supported in whole by the Institute of Museum and Library Services (IMLS) through the Library Services and Technology
Act (LSTA), administered by the State Library of Oregon.</span></b><span style="font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div id="preheader">
<p class="MsoNormal" style="mso-line-height-alt:.75pt"><span style="font-size:1.0pt">Quick trick to fill in data<o:p></o:p></span></p>
</div>
<div id="tracking-image">
<p class="MsoNormal" style="mso-line-height-alt:.75pt"><span style="font-size:1.0pt"><img border="0" width="1" height="1" style="width:.0138in;height:.0138in" id="_x0000_i1111" src="https://r20.rs6.net/on.jsp?ca=404d94d2-134a-4cff-a265-42d35a4cbf1d&a=1100778316270&c=4f52e898-6edc-11ea-9474-d4ae529a85ae&ch=69c188cc-cdfb-11eb-b3db-fa163e6b8330"></span><span style="font-size:1.0pt"><o:p></o:p></span></p>
</div>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;background:#DBDBDB">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="620" style="width:465.0pt">
<tbody>
<tr>
<td valign="top" style="padding:11.25pt 7.5pt 11.25pt 7.5pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="border:solid #68ABD6 1.0pt;background:white;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="490" height="115" style="width:5.1041in;height:1.2013in" id="_x0000_i1110" src="https://files.constantcontact.com/ee1208b4001/f83449a5-bce3-4d6a-9fcf-1833537cf016.png" alt="Tech-Talk 27 years"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 4.5pt 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="6" height="1" style="width:.0625in;height:.0138in" id="_x0000_i1109" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<p class="MsoNormal" align="center" style="text-align:center"><a href="https://r20.rs6.net/tn.jsp?f=001GmZja005FchU1jvzgsVZBBywWT0GR3qqPYJTq3715mJb1A9bcpG-cHE1t8e3cpAW04x7iZg5erctlRHN4cP_WXA64vLfmfTq4-98_poIonPBMgFj2zgCr3MC1HRuI20aiD8HvTtsERRygtCVF1Y6KB6QLATKwzhXPY5GBxwR7I_jRQRXG5MBxQKUv_mzKTxn&c=mk6YlYQ5aRgXDFl-27xZuRbKlyLCvFjTNMBy1yT1Hu7agPnjFog00A==&ch=NS4-aV7rTMjYs98V3cGulekEPtL-vXVkDo8lCYRrGMq6rESE8Y4eyg=="><span style="text-decoration:none"><img border="0" width="600" height="333" style="width:6.25in;height:3.4652in" id="_x0000_i1108" src="https://files.constantcontact.com/ee1208b4001/1f40a18c-55d2-49f9-aa2c-40499c167e6a.png" alt="video"></span></a><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 2.25pt 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="6" height="1" style="width:.0625in;height:.0138in" id="_x0000_i1107" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<p align="center" style="text-align:center"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Photo by
<a href="https://r20.rs6.net/tn.jsp?f=001GmZja005FchU1jvzgsVZBBywWT0GR3qqPYJTq3715mJb1A9bcpG-cHE1t8e3cpAWXWzBNdeOaWanqr9Ex7m3m_PWVPKIyfUnrghvUsbY93-OzVgUIADJQ9wW5HyxEvkHzl1Rn2uwXrQGyphhc2szJBpWxzlUG5sLhFz1vimQ_inm4UvkfUznt3-JKa0ANticADmnlFEsbomoSRYY9TeO796j6doeMNA7jcM7u-lpy86KLh2F1e5W9kw7SWhGV4H-7Yk0Fd0j48w=&c=mk6YlYQ5aRgXDFl-27xZuRbKlyLCvFjTNMBy1yT1Hu7agPnjFog00A==&ch=NS4-aV7rTMjYs98V3cGulekEPtL-vXVkDo8lCYRrGMq6rESE8Y4eyg==" target="_blank">
<b><span style="color:#428BCA">Pascal Debrunner</span></b></a> on <a href="https://r20.rs6.net/tn.jsp?f=001GmZja005FchU1jvzgsVZBBywWT0GR3qqPYJTq3715mJb1A9bcpG-cHE1t8e3cpAWZ4wLVqJ9MKFYKYe7wvXPrOKY3bUlc9saPo66GdDO9mMvIPm2ThIS0BMi8jRHKwoes9EHnTqW32PZtZgmk82gqcYSRCK0xo0j0ggE4_cFI8kOhl_DqC17WMdNg1AwcqlLiC0ao3IZfIaJ-Fu2YuFKBsj4GIXjj_fzZbNK1Tzb9SBl9Qy9zAqletG7MQCVjW4AgWaHTD8rEM0hBDE2tYSiYg==&c=mk6YlYQ5aRgXDFl-27xZuRbKlyLCvFjTNMBy1yT1Hu7agPnjFog00A==&ch=NS4-aV7rTMjYs98V3cGulekEPtL-vXVkDo8lCYRrGMq6rESE8Y4eyg==" target="_blank">
<b><span style="color:#428BCA">Unsplash</span></b></a><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 2.25pt 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="6" height="1" style="width:.0625in;height:.0138in" id="_x0000_i1106" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><a href="https://r20.rs6.net/tn.jsp?f=001GmZja005FchU1jvzgsVZBBywWT0GR3qqPYJTq3715mJb1A9bcpG-cO_LYqwVHC6FfkEBddOibheChmzMoU44VrM9niDIQtzyLdC5yseIkoq3Tep6jXXd9m_g6npc70fKTTGzef2lLdnujMWZQhIfdljzjdS6zIBE&c=mk6YlYQ5aRgXDFl-27xZuRbKlyLCvFjTNMBy1yT1Hu7agPnjFog00A==&ch=NS4-aV7rTMjYs98V3cGulekEPtL-vXVkDo8lCYRrGMq6rESE8Y4eyg=="><span style="text-decoration:none"><img border="0" width="560" height="208" style="width:5.8333in;height:2.1666in" id="_x0000_i1105" src="https://files.constantcontact.com/ee1208b4001/e25f6bcf-26a8-4e59-91f2-cc248962042d.png"></span></a><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 2.25pt 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="5" height="1" style="width:.0555in;height:.0138in" id="_x0000_i1104" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<p><b><span style="font-size:16.0pt;font-family:"Arial",sans-serif;color:#315FC3">Webinars for You </span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="indent-1" style="margin-left:.5in"><b><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:#C03E30">NOTE</span></b><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:black">: Register for one of the "Favorites"
below and get both. </span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l1 level1 lfo1">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><b><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:black">Sep 13: [FAVORITES -</span></b><b><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:#C03E30">PART 1</span></b><b><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:black">]</span></b><i><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:black">
Graphics, Windows, Email: Supercharge Your Productivity </span></i><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:black">[3 pm ET for 1 hour]
<o:p></o:p></span></p>
<p class="indent-1" style="margin-left:.5in"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l7 level1 lfo2">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><b><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:black">Sep 27: [FAVORITES -</span></b><b><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:#C03E30">PART 2</span></b><b><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:black">]</span></b><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:black">
<i>Formatting Docs, Spreadsheets, Quirky Challenges:</i> <i>Productivity Tips </i>
[3 pm ET for 1 hour] <o:p></o:p></span></p>
<p align="center" style="text-align:center"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l4 level1 lfo3">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><b><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:black">Oct 11: [VIDEO]</span></b><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:black">
<i>Creating Simple Tool Kits Using Three-Minute Video Tutorials </i>[3 pm ET for 1 hour]
<o:p></o:p></span></p>
<p align="center" style="text-align:center"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l6 level1 lfo4">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><b><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:black">Oct 25: [GRAPHICS]</span></b><span style="font-size:13.5pt;font-family:"Times New Roman",serif;color:black">
<i>From Still to Thrill: Create Moving Images That Will Bring Your Content to Life
</i>[3 pm ET for 1 hour] <o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;width:inherit;border-radius: 10px;border-spacing: 0">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="background:#315FC3">
<tbody>
<tr>
<td style="padding:7.5pt 30.0pt 7.5pt 30.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:black"><a href="https://r20.rs6.net/tn.jsp?f=001GmZja005FchU1jvzgsVZBBywWT0GR3qqPYJTq3715mJb1A9bcpG-cDkzr2cdfoBCJiBFCpL1tBQbVoB07c-IDqo-hg1yTlL8_CP-6VqoiIir36gXhVMDhJeVkp_zGmNMJNVWhV4JZWap94-8Ut_haG8FyVhtjLs9&c=mk6YlYQ5aRgXDFl-27xZuRbKlyLCvFjTNMBy1yT1Hu7agPnjFog00A==&ch=NS4-aV7rTMjYs98V3cGulekEPtL-vXVkDo8lCYRrGMq6rESE8Y4eyg=="><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:white;text-decoration:none">View
Webinars and Register Here</span></b></a> </span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 2.25pt 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="5" height="1" style="width:.0555in;height:.0138in" id="_x0000_i1103" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<h1 style="margin:0in"><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#315FC3">EXCEL/G-Sheets - Speed Up Your Work with Flash Fill<o:p></o:p></span></h1>
<p><i><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Intermediate</span></i><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="margin-left:3.5pt">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" style="width:.1597in;height:.0138in" id="_x0000_i1102" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td style="padding:0in 0in 7.5pt 0in;height:.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><img border="0" width="266" height="231" style="width:2.7708in;height:2.4097in" id="_x0000_i1101" src="https://files.constantcontact.com/ee1208b4001/b6079af1-acd9-4dcc-a792-2b8e470558ea.png" alt="spreadsheet"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Do you ever
</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">get an Excel spreadsheet that has long lists of names, email addresses, and other info? Maybe you want to upload the data into an email program to send a note to everyone.
You would like to personalize the message, but the problem is, <b>the first and last names are in the
<i>same </i>column</b>. You just need the first.<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">I had that issue! I wanted to separate the names to be in individual columns.
<b>I could manually re-type the entries,</b> but with over 100 lines of data, that would take a long time!<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Or the
<i>Text to Columns</i> option is an option…<b> but there's an even easier way! </b><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" style="margin-right:3.5pt">
<tbody>
<tr style="height:.75pt">
<td style="padding:0in 0in 7.5pt 0in;height:.75pt">
<p class="MsoNormal"><img border="0" width="213" height="122" style="width:2.2222in;height:1.2708in" id="_x0000_i1100" src="https://files.constantcontact.com/ee1208b4001/f7de6a8f-442e-475e-834c-8858b452dfe0.png" alt="flash fill"><o:p></o:p></p>
</td>
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" style="width:.1597in;height:.0138in" id="_x0000_i1099" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">The<i> Flash Fill
</i>feature is designed to <b><i>automatically </i>detect a pattern in the first few rows</b>… and then it will complete the new content in the lower rows for you… magically!
<b>If you use Google Sheets, it has a similar option called <i>Smart Fill</i></b> (see how to use this at the end of the article).<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">You can use this feature to separate all kinds of text</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">, but using the first and last
name as an example is easy. So Flash Fill not only works for names, but you can split address fields, change the case of text, or combine fields together. Or, perhaps there is a list of phone numbers, but they are an unrecognizable string of seven numbers
instead of formatted like a regular phone number with dashes.<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">NOTE:</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"> This is different from <i>Autofill</i> -- which is about Excel automatically
<i>completing </i>lists (like months of the year or numbers) by dragging a cell's Autofill feature down the column to create consecutive data. For more on Autofill,
<a href="https://r20.rs6.net/tn.jsp?f=001GmZja005FchU1jvzgsVZBBywWT0GR3qqPYJTq3715mJb1A9bcpG-cHE1t8e3cpAWOEhLBBhA4Yuq4LUo0fDHVxftdybOlv7bzuEcbUvT-KFfHJ6kaYwuOP8UEHtdq6mmk4759Z3F4C60nRaKZ2XOsTNxEzgmBWBAyrEShMiDeq00kVkDKRxJ0zYMa0nGVDxr&c=mk6YlYQ5aRgXDFl-27xZuRbKlyLCvFjTNMBy1yT1Hu7agPnjFog00A==&ch=NS4-aV7rTMjYs98V3cGulekEPtL-vXVkDo8lCYRrGMq6rESE8Y4eyg==" target="_blank">
<b><span style="color:#428BCA">see this article</span></b></a>.<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="5" height="1" style="width:.0555in;height:.0138in" id="_x0000_i1098" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<h1 style="margin:0in"><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#315FC3">Flash (or Smart) Fill Basics<o:p></o:p></span></h1>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<p><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">When Excel (or Google Sheets) senses a pattern </span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">in the data that you are entering, Flash
Fill (or Smart Fill) will complete the column with data based on the example you entered. This feature is great for repetitive information - and it will apply to every row in your list - no matter if it is 10 or 10,000 rows long.<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">A few notes to make this process work smoothly:</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l8 level1 lfo5">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">The content must have some degree of consistency.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l8 level1 lfo5">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Make sure you have a Header row.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l8 level1 lfo5">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">The column you want Flash/Smart Fill to complete must be <i>adjacent </i>to the columns of data.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l8 level1 lfo5">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Make sure you add the desired punctuation (like if you want to format a name with a comma after the last name and a period after the middle initial:
Durham, David S.)<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">TIP:</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"> If you try the example below and the Flash Fill does not kick in,
<b>see the manual option you can use to turn it on at the end of this article.</b><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="5" height="1" style="width:.0555in;height:.0138in" id="_x0000_i1097" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<h1 style="margin:0in"><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#315FC3">EXCEL: Let's Take a Look at a Few Examples<o:p></o:p></span></h1>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<h1 style="margin:0in"><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#315FC3">From One Column to Two<o:p></o:p></span></h1>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">I<b>f you have data in one cell,
</b>and you want to <b>split it into multiple cells</b>, create a <i>new </i>column with the heading you want the un-merged data to go into. In this case, we added one for <i>First </i>Name and one for <i>Last </i>Name. Then just start typing the First Name
in the first row, and continue to a second row until the Flash Fill detects the pattern and gives you a preview window. All good? Just hit <i>Enter </i>to accept the update. <o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="520" height="223" style="width:5.4166in;height:2.3194in" id="_x0000_i1096" src="https://files.constantcontact.com/ee1208b4001/b365f0fa-3ead-47b3-ac7b-949dd3fcbe98.png" alt="flash fill"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="5" height="1" style="width:.0555in;height:.0138in" id="_x0000_i1095" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<h1 style="margin:0in"><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#315FC3">From Multiple Columns to One<o:p></o:p></span></h1>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Spreadsheets with names are very common. We get lists set up in multiple cells (or one cell), and sometimes we need them in a different format.<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">In the example below
<b>you'll see a <i>separate </i>column</b> for <i>First, Middle</i> and <i>Last </i>Names.
<b>But we want them in <i>one</i> column.</b><o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Once we start typing the format in the adjacent cell, <i>Flash Fill</i> will detect it and then Excel provides a "preview" of the data. If it looks correct, we just push the <i>Enter</i> key
and the remaining data will be filled in.<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">In the image</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"> below you see the
<b>"preview" of content (grayed-out text)</b> that <i>Flash Fill</i> suggests based on the first row ... and the first few characters of the second that were typed.<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="display:none"><o:p> </o:p></span></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="560" height="239" style="width:5.8333in;height:2.4861in" id="_x0000_i1094" src="https://files.constantcontact.com/ee1208b4001/2ae33027-6931-45f2-8724-5e176f7abab3.png"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="5" height="1" style="width:.0555in;height:.0138in" id="_x0000_i1093" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="display:none"><o:p> </o:p></span></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<h1 style="margin:0in"><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#315FC3">Formatting Number Series<o:p></o:p></span></h1>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="margin-left:3.5pt">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" style="width:.1597in;height:.0138in" id="_x0000_i1092" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td style="padding:0in 0in 7.5pt 0in;height:.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><img border="0" width="313" height="191" style="width:3.2638in;height:1.9861in" id="_x0000_i1091" src="https://files.constantcontact.com/ee1208b4001/28b42dd4-1ca0-43e2-a8aa-de35783205dd.png" alt="numbers"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">When you have a string of
<i>numbers</i></span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">, like a date, telephone number, social security number, etc… and you need to change the way it is
<i>formatted</i>, there's an automated way to do this as well.<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">As an example, we have a spreadsheet with digits listed in a format that isn't recognizable as a phone number.
<b>To easily update the formatting, </b>in an adjacent cell, we started typing in the first few cells the way that we want it to appear so that <i>Flash Fill</i> could complete the list.<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="5" height="1" style="width:.0555in;height:.0138in" id="_x0000_i1090" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="display:none"><o:p> </o:p></span></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<h1 style="margin:0in"><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#315FC3">Change the Case of Text <o:p></o:p></span></h1>
<h1 style="margin:0in"><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#315FC3"> <o:p></o:p></span></h1>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">You may inevitably receive a spreadsheet that has
<i>case </i>inconsistencies or the wrong structure. That often happens with forms that different individuals fill out. Unlike Word,
<b>Excel doesn't have a <i>Change Case</i> button</b>. But, if you want all of your data to be in the name/title case (each word capitalized), you can use
<i>Flash Fill</i> to change it.<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="margin-left:3.5pt">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" style="width:.1597in;height:.0138in" id="_x0000_i1089" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td style="padding:0in 0in 7.5pt 0in;height:.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><img border="0" width="267" height="218" style="width:2.7777in;height:2.2708in" id="_x0000_i1088" src="https://files.constantcontact.com/ee1208b4001/0443c956-149f-40bc-ab52-1d1b72c24538.png" alt="all caps"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">In the example to the right</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">, we see several names in uppercase (in red). We want to
use <i>Flash Fill </i>to extract the First and Last names into new columns and convert the upper to title case.
<b>The trick is to type at least one row that has an uppercase name in it ... </b>
to give<i> Flash Fill </i>a clue. In fact, you may want to change the first row to ALL CAPS (if it is not already) so that you can give it as an example.<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">There are tons of other ways you can use the <i>Flash Fill</i>!</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="5" height="1" style="width:.0555in;height:.0138in" id="_x0000_i1087" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<h1 style="margin:0in"><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#315FC3">How to Give Flash Fill a Manual “Kick”<o:p></o:p></span></h1>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">If <i>Flash Fill </i>doesn't understand the pattern when you fill in the first cell and you don't get any "preview" content:<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l2 level1 lfo6">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Fill in a few more rows</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"> until it sees what you are trying
to accomplish by giving it<i> several more examples</i>.<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l3 level1 lfo7">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">If it still doesn't engage,
</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">to manually employ this tool, either:<o:p></o:p></span></p>
<p class="indent-1" style="margin-left:102.0pt;mso-list:l3 level1 lfo7"><![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">On the Home menu, in the
<i>Editing </i>section, go to <i>Fill, Flash Fill</i> ... or<o:p></o:p></span></p>
<p class="indent-1" style="margin-left:102.0pt;mso-list:l3 level1 lfo7"><![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Go to the
<i>Data </i>tab and in the <i>Data Tools </i>section click the <i>Flash Fill </i>button (it has a lightning bolt in the icon) to give it a kick.<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="display:none"><o:p> </o:p></span></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="525" height="239" style="width:5.4722in;height:2.493in" id="_x0000_i1086" src="https://files.constantcontact.com/ee1208b4001/7295a22f-a369-4e0e-a4a8-06daecc720cf.png"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="5" height="1" style="width:.0555in;height:.0138in" id="_x0000_i1085" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<h1 style="margin:0in"><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#315FC3">Google Sheets – Smart Fill<o:p></o:p></span></h1>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">As with<i> Flash Fill
</i>in Excel, you can <b>use Google Sheets's <i>Smart Fill </i>to detect patterns</b> and fill in columns of data with text or numbers instantly for you as in the scenarios above.<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">When getting your data ready,</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"> the content must have some consistency and the column
you want <i>Smart Fill </i>to complete must be adjacent to the columns of data.<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l0 level1 lfo8">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Make sure you have a
<i>Header</i> row.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l0 level1 lfo8">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Start typing the data you want
<i>Smart Fill</i> to detect a pattern. It can take 2-6 rows to trigger this feature.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l0 level1 lfo8">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">A
<i>Smart Fill</i> window will open with formula suggestions. Press the <i>checkmark
</i>to approve the changes.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l0 level1 lfo8">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Or, to give it a "kick," if
<i>Smart Fill</i> doesn't detect a pattern, type the first few lines of data and then press
<b>Ctrl+Shift+Y. </b>If a pattern is detected, <i>Smart Fill </i>will complete the column of content.<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="display:none"><o:p> </o:p></span></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="535" height="251" style="width:5.5763in;height:2.618in" id="_x0000_i1084" src="https://files.constantcontact.com/ee1208b4001/5406476e-0e0c-4149-86c0-3e186e6269fd.png"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 3.0pt 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="5" height="1" style="width:.0555in;height:.0138in" id="_x0000_i1083" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;background:#FCFAD5">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" style="margin-right:3.5pt">
<tbody>
<tr style="height:.75pt">
<td style="padding:0in 0in 7.5pt 0in;height:.75pt">
<p class="MsoNormal"><img border="0" width="249" height="166" style="width:2.5972in;height:1.7291in" id="_x0000_i1082" src="https://files.constantcontact.com/ee1208b4001/d8034ac0-6ed3-45d2-a779-97654f34cba7.png"><o:p></o:p></p>
</td>
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" style="width:.1597in;height:.0138in" id="_x0000_i1081" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<h1 style="margin:0in"><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#315FC3"><o:p> </o:p></span></h1>
<h1 align="center" style="margin:0in;text-align:center"><span style="font-size:15.0pt;font-family:"Georgia",serif;color:#17B1B0">Want to Learn MORE Productivity Tips
</span><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#315FC3"><o:p></o:p></span></h1>
<h1 align="center" style="margin:0in;text-align:center"><span style="font-size:15.0pt;font-family:"Georgia",serif;color:#17B1B0">Like This One?</span><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#315FC3"><o:p></o:p></span></h1>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Georgia",serif;color:black">Join us on Wednesday, September 13th
<b><i>and </i></b>27th for a two-part webinar ... </span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p align="center" style="text-align:center"><b><i><span style="font-size:15.0pt;font-family:"Georgia",serif;color:black">Supercharge Your Productivity
</span></i></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p></o:p></span></p>
<p align="center" style="text-align:center"><b><i><span style="font-size:15.0pt;font-family:"Georgia",serif;color:black">Using Tech-Talk's Best 24 Tips</span></i></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p align="center" style="text-align:center"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><a href="https://r20.rs6.net/tn.jsp?f=001GmZja005FchU1jvzgsVZBBywWT0GR3qqPYJTq3715mJb1A9bcpG-cEc5ue6CMN-GrQl1W424P5aF-a3JwanlKDj4IVjP2Lv8F1mwpDupqeLDG_UcZfmh3WYnS03p9hoxqxab1dYu8_n8xtPt3Gsa6nLCtqREBkHmbqWsfh37Wavb2BGlm1F0xedGgtfO1tIwYN9adOcJy1PWaER2UpwgnQpLQ3mi8xZJeFmV2SMtKAk=&c=mk6YlYQ5aRgXDFl-27xZuRbKlyLCvFjTNMBy1yT1Hu7agPnjFog00A==&ch=NS4-aV7rTMjYs98V3cGulekEPtL-vXVkDo8lCYRrGMq6rESE8Y4eyg==" target="_blank"><b><span style="font-size:15.0pt;font-family:"Georgia",serif;color:#17B1B0">Register
Here</span></b></a><o:p></o:p></span></p>
<p align="center" style="text-align:center"><span style="font-size:13.5pt;font-family:"Tahoma",sans-serif;color:black"></span><span style="font-size:13.5pt;font-family:"Georgia",serif;color:black">to attend one or both!</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Georgia",serif;color:black">Can't attend? Register and you'll receive an email with the recording links.
</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 3.75pt 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="5" height="1" style="width:.0555in;height:.0138in" id="_x0000_i1080" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" style="margin-right:3.5pt">
<tbody>
<tr style="height:.75pt">
<td style="padding:0in 0in 7.5pt 0in;height:.75pt">
<p class="MsoNormal"><img border="0" width="200" height="136" style="width:2.0833in;height:1.4166in" id="_x0000_i1079" src="https://files.constantcontact.com/ee1208b4001/f8f1ecc8-4884-4c21-8ed0-cf647e6db944.png"><o:p></o:p></p>
</td>
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" style="width:.1597in;height:.0138in" id="_x0000_i1078" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#333333">Communications: Writing</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Is it
<i>wherever </i>or <i>where ever</i>?<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Have you ever stumbled</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"> when writing the word "<i>whereever</i>"? If you think there
are too many "e's" ... you're right! <b>Drop that extra "e" in the middle.</b><o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><b><span style="font-size:15.0pt;font-family:"Times New Roman",serif;color:black">It's
</span></b><b><i><span style="font-size:15.0pt;font-family:"Times New Roman",serif;color:#C03E30">wherever</span></i></b><b><i><span style="font-size:15.0pt;font-family:"Times New Roman",serif;color:black">!</span></i></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">And
<i>don't</i> split the word</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"> into
<i>where ever.</i> Look at the examples of using this tricky word and you'll notice that separating the two words would be clunky at best.<o:p></o:p></span></p>
<p><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l5 level1 lfo9">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Wherever you go, always remember to be kind to others.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l5 level1 lfo9">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Place flowers wherever you see an empty spot in the garden of life.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l5 level1 lfo9">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Wherever there's music and dancing, you'll find happiness in the middle of it.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l5 level1 lfo9">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">What about traveling without a plan and stop wherever your heart desires?<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:66.0pt;text-indent:-12.0pt;mso-list:l5 level1 lfo9">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:black"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:black">Wherever there's a will, there's a way.<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:.75pt">
<td style="background:#5E81CA;padding:0in 0in 3.75pt 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="color:black"><img border="0" width="5" height="1" style="width:.0555in;height:.0138in" id="_x0000_i1077" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"></span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;background:#3661BD">
<tbody>
<tr>
<td width="50%" valign="top" style="width:50.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 7.5pt 7.5pt 15.0pt">
<p class="MsoNormal" align="center" style="text-align:center"><a href="https://r20.rs6.net/tn.jsp?f=001GmZja005FchU1jvzgsVZBBywWT0GR3qqPYJTq3715mJb1A9bcpG-cJc41tA5EDWlrvWB3rcQZefv41h-wQHL_okCJc-S06r_HzILeFJq9Jge0t50VFPCYe4IvPIZpo3kMpX2UtU2l1csFoPPmC8DaaDwgan_FeCs&c=mk6YlYQ5aRgXDFl-27xZuRbKlyLCvFjTNMBy1yT1Hu7agPnjFog00A==&ch=NS4-aV7rTMjYs98V3cGulekEPtL-vXVkDo8lCYRrGMq6rESE8Y4eyg=="><span style="text-decoration:none"><img border="0" width="300" height="201" style="width:3.125in;height:2.0902in" id="_x0000_i1076" src="https://files.constantcontact.com/ee1208b4001/b13a7a6a-7445-4d8e-b741-4b475385ef5b.png"></span></a><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
<td width="50%" valign="top" style="width:50.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 7.5pt">
<p class="MsoNormal" align="center" style="text-align:center"><a href="https://r20.rs6.net/tn.jsp?f=001GmZja005FchU1jvzgsVZBBywWT0GR3qqPYJTq3715mJb1A9bcpG-cHJnm6QRz-IPiK6rgf1OR6kFyxjHL7DVw2ZtlkesJlC0O8lYAWVjlpLtLZ0B5ti6ajHWgQxRQdYESKclZ2kQQa0-XanY5UfLqvLLoLi2zuGnKldZDKzfRI8=&c=mk6YlYQ5aRgXDFl-27xZuRbKlyLCvFjTNMBy1yT1Hu7agPnjFog00A==&ch=NS4-aV7rTMjYs98V3cGulekEPtL-vXVkDo8lCYRrGMq6rESE8Y4eyg=="><span style="text-decoration:none"><img border="0" width="300" height="201" style="width:3.125in;height:2.0902in" id="_x0000_i1075" src="https://files.constantcontact.com/ee1208b4001/8751eb23-fa9b-43ba-9f5f-7e80a465c6c5.png" alt="Ask a question"></span></a><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<p><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#333333">Copyright 1996-2023 Shared Results International. Published weekly. Distribution is limited by license. For information on how to include additional recipients, contact
<a href="mailto:support@tech-talk.com">support@tech-talk.com</a> 941-355-2092. </span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black"><o:p></o:p></span></p>
<p><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Cheers,<br>
</span><b><span style="font-size:14.0pt;mso-ligatures:standardcontextual">Darci Hanning, MLIS (she/her/hers)</span></b><b><span style="font-size:14.0pt"><o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="mso-ligatures:standardcontextual">Public Library Consultant / CE Coordinator<br>
<b>Continuing Education Resources: </b><a href="https://libguides.osl.state.or.us/conted"><span style="color:#0563C1">https://libguides.osl.state.or.us/conted</span></a></span><span style="font-size:8.0pt;mso-ligatures:standardcontextual"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:115%"><span style="mso-ligatures:standardcontextual">State Library of Oregon
<b>|</b> Library Support and Development Services <o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:115%"><span style="mso-ligatures:standardcontextual">971-375-3491
<b>|</b> <a href="mailto:darci.hanning@slo.oregon.gov"><span style="color:#0563C1">darci.hanning@slo.oregon.gov</span></a>
<b>|</b> <a href="http://www.oregon.gov/library"><span style="color:#0563C1">www.oregon.gov/library</span></a>
<u><span style="color:#0563C1"><o:p></o:p></span></u></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">Follow @StateLibraryOR:
<a href="http://fb.me/StateLibraryOR"><span style="color:#0563C1">Facebook</span></a>
<b>|</b> <a href="https://twitter.com/StateLibraryOR"><span style="color:#0563C1">Twitter</span></a>
<b>|</b> <a href="https://www.instagram.com/statelibraryor/"><span style="color:#0563C1">Instagram</span></a>
<b>|</b> <a href="https://pinterest.com/statelibraryor/"><span style="color:#0563C1">Pinterest</span></a>
<b>|</b> <a href="https://www.youtube.com/channel/UC0-kU8Gu0jS_YcnXg-b_TRA/featured">
<span style="color:#0563C1">YouTube</span></a><o:p></o:p></span></p>
<p><span style="mso-ligatures:standardcontextual"><br>
</span><img border="0" width="408" height="51" style="width:4.25in;height:.5347in" id="Picture_x0020_34" src="cid:image001.png@01D9E7C2.36AF2560"><span style="font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="display:none"><o:p> </o:p></span></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:7.5pt">
<o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>