[techtalk] WORD / EXCEL - Should I Use a Table or a Spreadsheet?

Tue Feb 25 15:10:03 PST 2020

Greetings and welcome to this week’s issue of Tech-Talk!
How to choose between the two
[http://r20.rs6.net/on.jsp?ca=7aba15f1-7f6a-4be5-8012-6b2f782ecaae&a=1100778316270&c=980e0ed0-0713-11e6-a7b7-d4ae528ed502&ch=981cb4d0-0713-11e6-a7b7-d4ae528ed502]

[http://files.constantcontact.com/ee1208b4001/34916cb2-412f-43fa-8294-1f7ecb0e9a3d.png]

 Want to give Tech-Talk to patrons, students, faculty? Contact support at Tech-Talk.com<mailto:info at tech-talk.com>

 ANNOUNCEMENTS

[https://files.constantcontact.com/ee1208b4001/8e8a2e94-d3d0-492e-ada7-235b3db0e6a8.png]

WEBINARS: MARCH & APRIL

1.  Mar 11th: Advanced PPT Tips & Techniques
2.  Apr 8th: Four and a Half Advanced Techniques in EXCEL

Click here to REGISTER and get RECORDINGS<http://r20.rs6.net/tn.jsp?f=0015QSzqkjx8cns31wsvTVhJB-pxefiT_QRpZyCS4QxJSE-45FOJa56PNL5xMg52TJihqshWGs_-d-_BZ9X0Ce-K0QjJL-T4EuuTP-PwiEBeQI3bLUXMk3pNSlIQyQha_D_LwGX2k6QFHW0KI1K6PjlgTCiAiHXBTpT&c=hoyE1NXv_C0jxCy7Dyv6WK3BZo65g-rHIcioexG6UVDw1xI7y--WAA==&ch=ApYajc9Q2bfmopieMMfqsZiqJ2USOJ66JFbKKBrees_To2a2rjR-VQ==>

 This Week's Topic: WORD / EXCEL / G-Suite

1. VIDEO & ARTICLE ... Which is Better, a Table or a Spreadsheet?
2. COMMUNICATING ... "Me" vs. "myself"
3. LEADERSHIP ... Broadening the "loop"

[https://files.constantcontact.com/ee1208b4001/858f97c9-7390-4349-9f04-15dbc367675b.jpg]<http://r20.rs6.net/tn.jsp?f=0015QSzqkjx8cns31wsvTVhJB-pxefiT_QRpZyCS4QxJSE-45FOJa56POgCZlSBOktS9RFigVGSZw3TCdjVv9_5lR9E-1IyXR8nNsteIfgMMJmnEHPMoj5twyT596Vy5Rj48EwbeK9azWfcOt7aH27OQwm2M6H_StGSH0SYL9ttWJxEwoUtVEe8SVLcJIzO4z_DKc1m_ZBaqS8=&c=hoyE1NXv_C0jxCy7Dyv6WK3BZo65g-rHIcioexG6UVDw1xI7y--WAA==&ch=ApYajc9Q2bfmopieMMfqsZiqJ2USOJ66JFbKKBrees_To2a2rjR-VQ==>

Photo by Paul Carroll<http://r20.rs6.net/tn.jsp?f=0015QSzqkjx8cns31wsvTVhJB-pxefiT_QRpZyCS4QxJSE-45FOJa56PNebHTphckptiLhPlkoz6Bu-bLq1KWwR_YNwSMqcnCnPSphPElowep2pigq4aSYFwYdK1m-utpkCZyrClaOI4VjQ_4QgO_yc3n6yb2qbL6ScjFiSpQwxBXm7jzJlJ-4uFhrMHwBgA4CXQWZUV0XpPjp3aFh5iAzhr1xU_kdWRHU2Yz-Dbm1oWM3uD2JW77phdTUWCr2eJP8QOoOSoAtmKMk=&c=hoyE1NXv_C0jxCy7Dyv6WK3BZo65g-rHIcioexG6UVDw1xI7y--WAA==&ch=ApYajc9Q2bfmopieMMfqsZiqJ2USOJ66JFbKKBrees_To2a2rjR-VQ==> on Unsplash<http://r20.rs6.net/tn.jsp?f=0015QSzqkjx8cns31wsvTVhJB-pxefiT_QRpZyCS4QxJSE-45FOJa56PNebHTphckptp03ZABXJylyXk26ik_6LHyOK6Yxea6yuxwpacXFeZK6qc-mv8TbyxllsKeXnKhmuKWj2zfTfZSB-fafvY8mIR7_CqvsnLYg29_RraV8qeT5hKfgVSAxVl3KYAVHvvtXK0YxeP-XXpZA6CGbowi-bZ-VYG1pMg2edbPC3deMI9ZXR44CoM-JZqgUYd_PcZzb8PTjAoQBjkNy2fcTJx6wUUg==&c=hoyE1NXv_C0jxCy7Dyv6WK3BZo65g-rHIcioexG6UVDw1xI7y--WAA==&ch=ApYajc9Q2bfmopieMMfqsZiqJ2USOJ66JFbKKBrees_To2a2rjR-VQ==>

Brought To You By State Library of Oregon

[State of Oregon]

Visit Tech-Talk.com Database<http://r20.rs6.net/tn.jsp?f=0015QSzqkjx8cns31wsvTVhJB-pxefiT_QRpZyCS4QxJSE-45FOJa56POAtitfqtXWwvZUawsjT8ET4w8Ga9EmUJoQ9EYQsD2kzqbZWKSr3ZvAxx1AvCSfAN8b__y55m6-7NUqB_YZk6JEIRpdPkghm3mkgiS_mH3Iq&c=hoyE1NXv_C0jxCy7Dyv6WK3BZo65g-rHIcioexG6UVDw1xI7y--WAA==&ch=ApYajc9Q2bfmopieMMfqsZiqJ2USOJ66JFbKKBrees_To2a2rjR-VQ==>

Username: ORLIBTECH
Password: ORLIBTECH

Questions about Tech-Talk?
darci.hanning at state.or.us<mailto:darci.hanning at state.or.us>

WORD vs. EXCEL - Should I Use a Table or a Spreadsheet?
Novice

[Table or Spreadsheet]

I was helping a colleague get her email list organized so that we could import it into a marketing program.

The problem was, she instinctively chose to use a Table in a Word doc to neatly set up the information because it was all text -- no computing of data was necessary.

However, when she tried to import the list into the email web tool, the required file type format was a spreadsheet (or .csv file).

Do you ever wonder when you are setting up a list of data elements … if it would be best to use a spreadsheet (or Google Sheet) or a table in Word (or a Google Doc)?

Tables and spreadsheets are great for presenting data in a neat and orderly fashion and for manipulating and sorting data. But, when should you use which?

The two of them are similar in that they both display information in columns and rows. However, they have their individual strengths and weaknesses. There are times when using one over the other truly has advantages.

Table or Spreadsheet... How to Choose?

So what things should you consider when wondering which to use?

Choose a Table in Word (or Google Doc) if:

[Table or spreadsheet]

·     Your information is text... mostly words or sentences.

·     If there is data in the table that contains numbers, you are limited to simple calculations<http://r20.rs6.net/tn.jsp?f=0015QSzqkjx8cns31wsvTVhJB-pxefiT_QRpZyCS4QxJSE-45FOJa56PNebHTphckptKcCFbgwJS1ag3YFaxWkR0MvqlObU25w6UZfr70Ve0KZQFZlBXO46td8iVgCnnUZwhuWGeWaD9zsNlE-f5TTNC2RT8f295ZWWgqiEgm3mUx2eFb-UnyUA2w9gA6HOLIs8&c=hoyE1NXv_C0jxCy7Dyv6WK3BZo65g-rHIcioexG6UVDw1xI7y--WAA==&ch=ApYajc9Q2bfmopieMMfqsZiqJ2USOJ66JFbKKBrees_To2a2rjR-VQ==>.

·     When the information you have in a Table will fit on a Word page.

·     And when you want another way to display lists of information in an organized way, appealing way.

Choose a Spreadsheet in Excel (or Google Sheet) when:

[table or spreadsheet]

·     Your data is mostly numeric and you plan to do a lot of calculations or the mathematical functions you will perform are complex.

·     You want to present your information to others in the form of charts and graphs.

·     You are importing into another program -- like a web tool that requires an .xlsx (Excel) or .csv (comma separated values) format so that the data will map correctly.

·     You are setting up data for a mail merge -- for labels or envelopes.

·     You need the ability to sort and filter the contents by multiple levels.

·     When you want to do analysis of data... like with the use of pivot tables.

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

Communications: Grammar
Is it Me or Myself?

Well I was surprised the other day when I received an email from a well-known online entrepreneur. He is known in the industry as a heavy-duty money maker.
We're talking millions of dollars.

So when the very first sentence had a grammatical error, it stood out like a sore thumb.

"I want to bring you up to speed on a problem that's starting to
really concern myself and many of the other industry leaders."

Did you catch it?

It's the use of "myself" instead of "me."

"I want to bring you up to speed on a problem that's starting to
really concern myself and many of the other industry leaders."

That was followed with yet another instance of poor grammar.

"He asked myself, along with other entrepreneurs to..."

No, no, no. These should be:

"I want to bring you up to speed on a problem that's starting to
really concern me and many of the other industry leaders."

"He asked me, along with other entrepreneurs to..."

Here are the rules for using "me" vs. "myself."

·     "Me" is used as an object. (Example: The songs are written by me.)

·     "Myself" is a reflexive pronoun used when you are the object of your own action – i.e., when "you" are doing something to "you." (Example: I could write the songs myself, but they sound better when they are written by Barry Manilow and me.

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

Leadership Thoughts To Consider
#8 – Broadening the loop

I have said in previous articles that managers are deluding themselves.

What do I mean by that?

I believe that a certain delusion occurs when managers and supervisors think things are going better than the team does. There's a gap in understanding how engaged everyone is.

I think this delusion happens partly because leaders want to see the best in their people. They think highly of their employees. So they assume everyone is engaged.

But here's the problem. Managers are "in the loop." That means that they know (for the most part) what's going on. They are high enough in the organization where their bosses keep them informed.

There's a certain comfort in that. It's a position of safety, of power, to have the knowledge ... be in the loop.

And with comfort, comes the forgetting of the pain of being on the outside. When you're in the loop, the discomfort of not knowing goes away.

Why does this happen? Because it isn’t instinctive to tell others, to make sure they are in the inner circle.  The information, the sharing of what you know ... gets put aside.

As a result, you have two groups ... those in the know (managers) and those who feel left out, on the outside.

Being an egalitarian leader means trying your best to keep everyone "in the loop" as much as possible. Show them respect by communicating openly with them.

What can you do?

Make a list of all the ways you can make sure the people around you are kept better informed. Make them feel they are "in the loop." Generate a habit of sharing. You'll gain their respect and support.

[http://files.constantcontact.com/ee1208b4001/b13a7a6a-7445-4d8e-b741-4b475385ef5b.png]<http://r20.rs6.net/tn.jsp?f=0015QSzqkjx8cns31wsvTVhJB-pxefiT_QRpZyCS4QxJSE-45FOJa56PJ7gutCjrqQeZA9amIMFtaEfjGHEDs1yuvbc36nZ-c0gjFdVHc7NiX7USNm9sAjaCHu_y0Rcpjb2ZTfv0l9T7oyYmVIRLiWiXtZ6mSFhFOk-&c=hoyE1NXv_C0jxCy7Dyv6WK3BZo65g-rHIcioexG6UVDw1xI7y--WAA==&ch=ApYajc9Q2bfmopieMMfqsZiqJ2USOJ66JFbKKBrees_To2a2rjR-VQ==>

[Ask a question]<http://r20.rs6.net/tn.jsp?f=0015QSzqkjx8cns31wsvTVhJB-pxefiT_QRpZyCS4QxJSE-45FOJa56PPpraQm64k7mFQG10aBSwh0l2zAPoBul7jblwU5Sxm0MFu8FPP0UOnyWbaaI2ISs7EqdnF_vj5BNeas8BULp-wN1iDTDb2ncZ4tztGFg3k1l-cRtbIM1eFE=&c=hoyE1NXv_C0jxCy7Dyv6WK3BZo65g-rHIcioexG6UVDw1xI7y--WAA==&ch=ApYajc9Q2bfmopieMMfqsZiqJ2USOJ66JFbKKBrees_To2a2rjR-VQ==>

Copyright 1996-2020 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 state.or.us<mailto:darci.hanning at state.or.us> 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
Public Library Consultant / CE Coordinator
darci.hanning at state.or.us<mailto:darci.hanning at state.or.us> | 503-378-2527| www.oregon.gov/library<https://www.oregon.gov/library>
Follow us: Facebook<http://fb.me/StateLibraryOR> | Twitter<https://twitter.com/StateLibraryOR> | Tumblr<http://www.statelibraryor.tumblr.com/> | Pinterest<https://pinterest.com/statelibraryor/>

[cid:image005.png at 01D31C27.4B9FEA30]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/techtalk/attachments/20200225/2532e5b9/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/20200225/2532e5b9/attachment.png>