[techtalk] EXCEL – Using the AutoFill Shortcut

Tue Nov 9 11:09:39 PST 2021

Welcome to the latest issue of Tech-Talk!
Reminder: When accessing resources at the Tech-Talk website<https://www.tech-talk.com/>, use ORLIBTECH
for both the username and password when prompted.

Use autocomplete to save time

[https://files.constantcontact.com/ee1208b4001/470df2da-b8fb-4b32-95fb-8f6331e9910d.png]

[https://files.constantcontact.com/ee1208b4001/77ba500f-d6ea-4695-9ab1-644df4755c6c.png]<https://r20.rs6.net/tn.jsp?f=001Jrsla5G_uF4U4EKuODRIHkWngENQXf8Vq4aP7eekiWr_72x98nY88tWDCn8XMFsNvdS5vxfWR4wmCUeT58XSWmhs-asRT1Ef04ZM5cl80l05ZDSXYOC9dhPfTeb-xKSpd_fHJtzvZ0IMyWCbwp0FfhOyShZ9lqHj&c=tjkmFYhkda7UHHL1dsqLGlOaXTOkLQ2y6oVmIENCLvN84uaGiCYIEw==&ch=6U8uA3LniLF1gRGWUMKIPQL8AnzPB1xUI_zbt6lnJKYbByvBf7Uslw==>
See NOVEMBER THEME

View articles with topics on...

·     Communicating kindness
·     Ways to show appreciation
·     How NOT to give praise
·     Three rules for accepting compliments
More ..<https://r20.rs6.net/tn.jsp?f=001Jrsla5G_uF4U4EKuODRIHkWngENQXf8Vq4aP7eekiWr_72x98nY88tWDCn8XMFsNvdS5vxfWR4wmCUeT58XSWmhs-asRT1Ef04ZM5cl80l05ZDSXYOC9dhPfTeb-xKSpd_fHJtzvZ0IMyWCbwp0FfhOyShZ9lqHj&c=tjkmFYhkda7UHHL1dsqLGlOaXTOkLQ2y6oVmIENCLvN84uaGiCYIEw==&ch=6U8uA3LniLF1gRGWUMKIPQL8AnzPB1xUI_zbt6lnJKYbByvBf7Uslw==>.

This Week's Topic: EXCEL and Google SHEETS

1. ARTICLE & VIDEO ... Using the AutoFill Shortcut
2. COMMUNICATING ... Three ways to listen better
3. LEADERSHIP ... 5 Steps to Prevent Organizational Indifference
4. WEBINARS ... (Yes, Patrons, Students, Staff join with library's username. No fee.)

·     Nov 10: [VIDEO] Davinci Resolve - A Powerful and Free Video Editing Tool
·     Nov 17: [OFFICE/Google] Secrets for Working with New Office Templates
·     Dec 1: [Graphics] Best Tips for Using Graphics in Word & PPT (Basic & Inter)
·     Dec 15: [Excel] Best Tips for Working in Excel (Basic & Inter)

Register for Webinars<https://r20.rs6.net/tn.jsp?f=001Jrsla5G_uF4U4EKuODRIHkWngENQXf8Vq4aP7eekiWr_72x98nY88inxS9svqyqIYABb7KAGD86J3W8v5uzkiUBkODAukMkJGS2sX91gXBjIABOwApP-JFaYiAjHC1svYrQvrNnSC3J_HBubDmROCViQ5GfEGuNe&c=tjkmFYhkda7UHHL1dsqLGlOaXTOkLQ2y6oVmIENCLvN84uaGiCYIEw==&ch=6U8uA3LniLF1gRGWUMKIPQL8AnzPB1xUI_zbt6lnJKYbByvBf7Uslw==>

[https://files.constantcontact.com/ee1208b4001/b34a5590-5f6d-4f38-b016-eedf684ecec4.png]<https://r20.rs6.net/tn.jsp?f=001Jrsla5G_uF4U4EKuODRIHkWngENQXf8Vq4aP7eekiWr_72x98nY88pxCD7VUpDSnE-x3_SqENJ4szTaBQ3qqZLMR8oNOW_q_r_wlad27P4eon1iNFQ0nSwEmVRL9l5gn7j4Wp8IVyy3ESOo10LXv5IuUa5NdKqyzN61KYrInzELzFv5QLknB06AAK8ZMaLr39hnECtl5a1o=&c=tjkmFYhkda7UHHL1dsqLGlOaXTOkLQ2y6oVmIENCLvN84uaGiCYIEw==&ch=6U8uA3LniLF1gRGWUMKIPQL8AnzPB1xUI_zbt6lnJKYbByvBf7Uslw==>

Photo by Susan Holt Simpson<https://r20.rs6.net/tn.jsp?f=001Jrsla5G_uF4U4EKuODRIHkWngENQXf8Vq4aP7eekiWr_72x98nY88pxCD7VUpDSn5YSuXn7c9dYIrpMBfC7M1reeMiV_8f2MDRKqh-9-1pagFdWBJNdN3wOdncfulRf4pNw3inv9NXGZhrFBDZpRJxbg-OLEfKJu9CbJuB-TlJA4UcR4egjzYXM3AWJpunw9ceq7MNzSs9BxZAEL4CGIRpynt29hxUJpiogjekfctJ9iBb676qwc6e-rf0CdaizE&c=tjkmFYhkda7UHHL1dsqLGlOaXTOkLQ2y6oVmIENCLvN84uaGiCYIEw==&ch=6U8uA3LniLF1gRGWUMKIPQL8AnzPB1xUI_zbt6lnJKYbByvBf7Uslw==> on Unsplash<https://r20.rs6.net/tn.jsp?f=001Jrsla5G_uF4U4EKuODRIHkWngENQXf8Vq4aP7eekiWr_72x98nY88pxCD7VUpDSnWCSeUQHf8YpI1FUd48zlQvXc51INCwI2YMWtVX5NEypOztKiR2ZHHpLzaWge1sOgLEQIzQpkLl0oAYd4t4ZNjoihx5IoB0ioyERQpnLdyPVtYYjBf4IF423euTQOOVeyfj9Bkz32q2nKdRpTE0ztOYTvYEksZQRJHlHnRCorMjKEposhwLPp4Zbb4AvsK2YqRaAnbmvT5mSguUE5Q6Xt6g==&c=tjkmFYhkda7UHHL1dsqLGlOaXTOkLQ2y6oVmIENCLvN84uaGiCYIEw==&ch=6U8uA3LniLF1gRGWUMKIPQL8AnzPB1xUI_zbt6lnJKYbByvBf7Uslw==>

[https://files.constantcontact.com/ee1208b4001/e25f6bcf-26a8-4e59-91f2-cc248962042d.png]<https://r20.rs6.net/tn.jsp?f=001Jrsla5G_uF4U4EKuODRIHkWngENQXf8Vq4aP7eekiWr_72x98nY88pTO0VySrI9ph1oKFCqqo3hR7ForqWHgslzmkhH-WgZf6p6OQiOWmaPP4g8zZBTy4A-GDOxAyARCx24ctfJWRjn2yNYPXU70qxeXu6BueOqi&c=tjkmFYhkda7UHHL1dsqLGlOaXTOkLQ2y6oVmIENCLvN84uaGiCYIEw==&ch=6U8uA3LniLF1gRGWUMKIPQL8AnzPB1xUI_zbt6lnJKYbByvBf7Uslw==>

EXCEL – Using the AutoFill Shortcut
Novice

If you have ever wanted to create a series of data in your spreadsheets, like the months of the year or a list of numbers, did you know that Excel can fill it in for you? All you need to do is start typing the first few entries and this software is smart enough to detect a pattern and fill in the rest for you!

Once you type in the initial items, you can use the AutoFill function to complete the list. For example, you do this in situations like these:

·     Numbers in sequence: 1, 2, 3, 4
·     Numbers in a pattern: 10, 20, 30, 40
·     Alphabet: a, b, c, d
·     Days of the week: Sunday, Monday, Tuesday
·     Months of the year: January, February, March
·     Date sequence, 4/4/22, 4/5/22, 4/6/22
·     And so on…. Most anything that Excel can detect as a pattern will work with AutoFill.

Using AutoFill in Excel

Here's how it works:

·     Select the cell where you want the series to begin and type in the entry you want to start with – for example, the number 1.

·     Go to the next cell you want to be filled and type in the number 2 to begin creating the series.

[drag down column]

·     Highlight the two cells you just completed. Put the mouse in the lower right-hand corner (on the small black box) until it turns into a simple cross (looks like a plus (+) sign.

·     Drag the mouse down the column to the cell where you want the last value of the series to appear.

·     Release the mouse and the rest of the series will be filled in automatically!

NOTES: Sometimes, if it's a recognizable series, you can get away with just typing in one item, e.g. January and then drag with cross down.

TIP: The range can be filled downwards, upwards, rightwards or leftwards.
[autofill]

[autofill]

[https://files.constantcontact.com/ee1208b4001/e8d38e6b-9d8c-4144-af74-c826c98cbac5.png]

NOTE: By the way, you can also use autofill if you want to put the SAME number or text all the way down – instead of a series. Just type that repeated number in at least two cells; then drag the corner. Example: all 1’s or all January’s.

Using Autofill in Google Sheets

[autofill in Google Sheets]

Yes, the auto-complete feature works exactly the same way in Google Sheets.

·     Select the cell where you want the series to begin and type in the entry you want to start with.
·     Go to the next cell you want to be filled and type the next character in creating the series.
·     Highlight the two cells you just completed. Put the mouse in the lower right-hand corner (on the small square box) until it turns into a cross.
·     Drag the mouse down the column to the cell where you want the last value of the series to appear.

[https://files.constantcontact.com/ee1208b4001/41d9a61c-7e5a-4de3-b0a4-4021dd05cea3.png]

Communication: Listening
Three ways to listen better

There are a number of things you can do to show you are listening well and to also increase your understanding of what is being said.

Here are three habits that could serve you well.

1. Look at the person who is speaking.
2. Question the speaker to clarify what is being said.
3. Repeat some of the things the person stated.

By the way, the reason we chose to list three this time and another three next week is because studies show that three items are the most people tend to remember. When you add a fourth, typically, memory fog sets in.

[https://files.constantcontact.com/ee1208b4001/da1c6ee9-ba35-4af5-9c80-8e1b5781189e.png]

Leadership
5 Steps to Prevent Organizational Indifference

If you want your organization to flourish, you need to keep your employees motivated so indifference doesn't set in. You must maintain that initial enthusiasm they had when they were first promoted or hired.

Although leadership plays a big role in the organization's operation, a team is only as strong as its employees. When your workforce becomes organizationally indifferent, productivity will suffer.

Fortunately, there are steps you can take to ward off apathy among your employees. By simply following these five steps, you will be on your way to keeping your folks energized. You'll start seeing your organization rise to a new level of excellence.

Keep in mind that each of these steps is interconnected. So if you neglect any one of them, indifference will creep in.

1. Set goals and have a clear vision.
2. Keep employees informed.
3. Equip your workers.
4. Create a motivational environment and provide incentives.
5. Empower your employees.

NOTE: Watch for the next issues to explain each one more fully.

[http://files.constantcontact.com/ee1208b4001/b13a7a6a-7445-4d8e-b741-4b475385ef5b.png]<https://r20.rs6.net/tn.jsp?f=001Jrsla5G_uF4U4EKuODRIHkWngENQXf8Vq4aP7eekiWr_72x98nY88lbPDcurZAGEkXO9OA0S8I2Tfmuc3BOuVtOYN46x-2i1DWW5EjmRSBiZzYF578kl-Wu_weQ3pxec-l2O6bDMJVGh6oCtv8F6wzHykN8onS9W&c=tjkmFYhkda7UHHL1dsqLGlOaXTOkLQ2y6oVmIENCLvN84uaGiCYIEw==&ch=6U8uA3LniLF1gRGWUMKIPQL8AnzPB1xUI_zbt6lnJKYbByvBf7Uslw==>
[Ask a question]<https://r20.rs6.net/tn.jsp?f=001Jrsla5G_uF4U4EKuODRIHkWngENQXf8Vq4aP7eekiWr_72x98nY88mrV3iKPViAbPAzc_7ddVX5m82ayS7HRDuF5hRzzrO9238cnos4qVBNjA-dhsIZ-Rto_vg7Q8xPAZ6TrTieu4wMZJ50sFLdNybCq9OwAcpWCxZ83_a3EBUg=&c=tjkmFYhkda7UHHL1dsqLGlOaXTOkLQ2y6oVmIENCLvN84uaGiCYIEw==&ch=6U8uA3LniLF1gRGWUMKIPQL8AnzPB1xUI_zbt6lnJKYbByvBf7Uslw==>

Copyright 1996-2021 Shared Results International. Published weekly. Distribution is limited by license. For information on how to include additional recipients, contact support at tech-talk.com<mailto:support at tech-talk.com> 941-355-2092.

The Tech-Talk e-newsletter for Oregon library staff is distributed weekly via the Libs-OR and TechTalk mailing lists. Know someone who might be interested in receiving a copy but they’re not on TechTalk or Libs-OR mailing lists? Have them contact darci.hanning at slo.oregon.gov<mailto:darci.hanning at slo.oregon.gov> or visit http://listsmart.osl.state.or.us/mailman/listinfo/techtalk to subscribe to just the Tech-Talk newsletter!

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.

Cheers,
Darci Hanning, MLIS (she/her/hers)
Public Library Consultant / CE Coordinator
State Library of Oregon | Library Support and Development Services
971-375-3491 | darci.hanning at slo.oregon.gov<mailto:darci.hanning at slo.oregon.gov> | www.oregon.gov/library<http://www.oregon.gov/library>
Follow @StateLibraryOR: Facebook<http://fb.me/StateLibraryOR> | Twitter<https://twitter.com/StateLibraryOR> | Instagram<https://www.instagram.com/statelibraryor/> | Pinterest<https://pinterest.com/statelibraryor/> | YouTube<https://www.youtube.com/channel/UC0-kU8Gu0jS_YcnXg-b_TRA/featured>
Continuing Education Resources: https://libguides.osl.state.or.us/conted
 [cid:image001.png at 01D7D559.F6B28820]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/techtalk/attachments/20211109/0db5a13a/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 15548 bytes
Desc: image001.png
URL: <https://omls.oregon.gov/pipermail/techtalk/attachments/20211109/0db5a13a/attachment.png>