- To exclude the first row of data from the sort because it is a column heading, on the Home tab, in the Editing group, click Sort & Filter, click Custom Sort, and then select My data has headers.
- To include the first row of data in the sort because it is not a column heading, on the Home tab, in the Editing group, click Sort & Filter, click Custom Sort, and then clear My data has headers.
Tuesday, February 28, 2012
EXCEL: How to Turn the Heading Row “On” or “Off”
When we work in Excel (Spreadsheets) whether for numbers or data management, it's always best to be sure that we've typed in a heading row, so that when we sort a column - it will be easier to understand the meaning of the data. By default, the value in the heading is not included in the sort operation.
Occasionally, you may need to turn on or off the heading so that the value in the heading is or is not included in the sort operation. Do one of the following:
Friday, February 24, 2012
How to verify an emails accuracy - scam or hoax
It's always a good idea to verify email stories or warnings that you receive, no matter how accurate they may seem, before you forward them on to family and friends… Better to be safe – than to have to send a second email apologizing for a story that is urban legend, hoax or scam…
There are several different ways to do this and it only takes a minute - first you might want to check the accuracy on one of the following websites, such as:
www.hoax-slayer.com
www.truthorfiction.com
www.snopes.com
I’m sorry to say that one of my favorite websites to verify email stories has decided to get out of the business – that was: www.breakthechain.org
OR
Visit you favorite search engine and put the basics of the email story or warning into the “search bar” on your favorite search engine, such as
It's estimated that 99 out of 100 of these stories and warnings are false with little or no validity - but they certainly clog up email inboxes, mail servers, cause people to be spammed and damage to computers and waste so much time...
So be safe & check the story out for yourself before you forward it on...
www.truthorfiction.com
www.snopes.com
- google.com
- bing.com
- yahoo.com
- ask.com
It's estimated that 99 out of 100 of these stories and warnings are false with little or no validity - but they certainly clog up email inboxes, mail servers, cause people to be spammed and damage to computers and waste so much time...
So be safe & check the story out for yourself before you forward it on...
Monday, February 20, 2012
Presidents Day or Washingtons Birthday or both
Well, it’s Monday – February 20th, 2012 – and many of us have the day off – celebrating “Presidents' Day”, which is also known as "Washington's Birthday".
Yes, some states – including Arizona & Massachusetts, do celebrate Presidents' Day as a state holiday BUT remember President’s Day has never been recognized at the federal level. On the national level, the third Monday of February is the official observance of Washington's Birthday.
And did you realize, that some states that don’t honor/celebrate Presidents Day or Washington’s Birthday - those states that don't (according to Wikipedia) are Alabama, Delaware, Florida, Iowa, Kansas, Kentucky, Louisiana, North Carolina, Rhode Island and Wisconsin.
Washington's Birthday, February 22nd, was first declared a federal holiday by an 1879 act of Congress.. In 1968, legislation was enacted that affected several federal holidays celebrated at that time and one of the holidays, was Washington's Birthday this act was put in place in the hopes of simplifying the yearly calendar of holidays. President’s Day is now observed on the third Monday of February throughout the United States.
A common misconception is that Presidents' Day is the unification of Washington's Birthday and Lincoln's Birthday, or that it is a celebration of all U.S. Presidents, but neither of these are true..
And because we follow the school calendars - our computer classes are not held on Presidents Day - Washington's Birthday, so enjoy your day off.. I know we will...
Yes, some states – including Arizona & Massachusetts, do celebrate Presidents' Day as a state holiday BUT remember President’s Day has never been recognized at the federal level. On the national level, the third Monday of February is the official observance of Washington's Birthday.
And did you realize, that some states that don’t honor/celebrate Presidents Day or Washington’s Birthday - those states that don't (according to Wikipedia) are Alabama, Delaware, Florida, Iowa, Kansas, Kentucky, Louisiana, North Carolina, Rhode Island and Wisconsin.
Washington's Birthday, February 22nd, was first declared a federal holiday by an 1879 act of Congress.. In 1968, legislation was enacted that affected several federal holidays celebrated at that time and one of the holidays, was Washington's Birthday this act was put in place in the hopes of simplifying the yearly calendar of holidays. President’s Day is now observed on the third Monday of February throughout the United States.
A common misconception is that Presidents' Day is the unification of Washington's Birthday and Lincoln's Birthday, or that it is a celebration of all U.S. Presidents, but neither of these are true..
And because we follow the school calendars - our computer classes are not held on Presidents Day - Washington's Birthday, so enjoy your day off.. I know we will...
Friday, February 10, 2012
What does “cloud” computing mean?
No the angels in heaven aren’t going to help store your work and photos when you use "cloud computing"..
Cloud computing simply means that whatever task you are performing is happening on the internet, instead of on your own PC.. So for anyone who uses many of the free email accounts, such as hotmail – yahoo – gmail, well they’ve been using “cloud” computing, because when they went to that companies website, and signed in with their user name & password, they were working on that companies computer, not their own… If you use Walgreens.com to store your photos for prints, and projects – such as a photo book or mug, then you were using “cloud” computing..
Cloud computing isn't new - far from it - it's been around since the early 1960's..50 years!!!
Some sources say cloud computing began with the beginning of the IT (Information Technology) Outsourcing industry by using idle/excess compute power (processing, storage, and connectivity) of one entity, to carry out the work of another. It's possible the first such use was when Mr. Ross Perot started the IT Outsourcing industry in 1962, and then rented idle computing power from one company (Southwestern Life) to carry out the processing needs of another (Collins Radio).
Cloud computing simply means that whatever task you are performing is happening on the internet, instead of on your own PC.. So for anyone who uses many of the free email accounts, such as hotmail – yahoo – gmail, well they’ve been using “cloud” computing, because when they went to that companies website, and signed in with their user name & password, they were working on that companies computer, not their own… If you use Walgreens.com to store your photos for prints, and projects – such as a photo book or mug, then you were using “cloud” computing..
Cloud computing isn't new - far from it - it's been around since the early 1960's..50 years!!!
Some sources say cloud computing began with the beginning of the IT (Information Technology) Outsourcing industry by using idle/excess compute power (processing, storage, and connectivity) of one entity, to carry out the work of another. It's possible the first such use was when Mr. Ross Perot started the IT Outsourcing industry in 1962, and then rented idle computing power from one company (Southwestern Life) to carry out the processing needs of another (Collins Radio).
Sunday, February 5, 2012
Facebook's New "Timeline" Design & Features
WHAT IS FACEBOOK’S NEW PRIVACY FEATURE CALLED “TIMELINE”..
If you don't have Facebook Timeline already, you will soon - during the next month or so, Facebook is introducing its updated “Timeline” design to all Facebook users.
Facebook Timeline is basically a cosmetic design change, but it will affect the layout of your profile and also has some functional changes intended to make it easier for others to see your Facebook history and parts of your profile and this is where you want to pay attention, because now others will be able to see those embarrassing photos, status updates when you didn’t know any better, and what your friends have posted on your wall since the day you joined Facebook.
Profile (Timeline) Review is a new privacy option that lets you approve or reject posts that you've been tagged in before they go on your profile (timeline). When you turn it on, posts may already be visible in other places on Facebook, but they won't appear on your profile (timeline) until you approve them. When you have a post to review, it will show up in the Pending Posts section of your profile or in your ACTIVITY LOG (if you you've upgraded to timeline).
You may want to start deleting what you don't want anyone to see and setting limits on "the audience" (such as friends, friends of friends, vs. everyone) for the content you want only some people to see.
If you don't have Facebook Timeline already, you will soon - during the next month or so, Facebook is introducing its updated “Timeline” design to all Facebook users.
Facebook Timeline is basically a cosmetic design change, but it will affect the layout of your profile and also has some functional changes intended to make it easier for others to see your Facebook history and parts of your profile and this is where you want to pay attention, because now others will be able to see those embarrassing photos, status updates when you didn’t know any better, and what your friends have posted on your wall since the day you joined Facebook.
Profile (Timeline) Review is a new privacy option that lets you approve or reject posts that you've been tagged in before they go on your profile (timeline). When you turn it on, posts may already be visible in other places on Facebook, but they won't appear on your profile (timeline) until you approve them. When you have a post to review, it will show up in the Pending Posts section of your profile or in your ACTIVITY LOG (if you you've upgraded to timeline).
- Note-Your ACTIVITY LOG is a list of your posts and activity, from today back to the very beginning. You’ll also see stories and photos you’ve been tagged in, as well as the connections you’ve made, like when you liked a Page or added someone as a friend.
You may want to start deleting what you don't want anyone to see and setting limits on "the audience" (such as friends, friends of friends, vs. everyone) for the content you want only some people to see.
Wednesday, February 1, 2012
How to Use our Class Blog
We hope you find our “CLASS BLOG” helpful as you continue to learn your computer more effectively, because no doubt as soon as you learn something – it will change and there will be something new to learn. We hope our Class Blog helps with the ever changing technology… Feel free to become a follower, to comment, and to share this website with family and friends. And feel free to ask questions – your questions become the topics we cover on the blog and we continue to learn from each other.. ~ Cherie Houston - email me at: cherie_houston@hotmail.com
WHAT IS A BLOG AND HOW DO I USE IT?
All BLOGS are intended to be "informational" like any newsletter you might receive. But in addition to reading the "posts-otherwise called articles" that we publish on our BLOG, you can also copy any of the "post/articles" and save them to your word processing files so you can then print them and you can comment on what we've said in a specific "post/article" - The how to's are noted below..
TO COPY A POST/ARTICLE to save or print for yourself or to change the size and/or print: highlight any portion of the post/article - activate the paste command, now open or go to your word processing program and on a clean piece of paper - activate the paste command. What you highlighted is now on the page. Change the font size & style, and you may want to change the color of the entire post/article to BLACK because most blogs use a light gray print (even though it may look black)... To save it on your PC, go to File, Save As, Open or Create a folder you want it saved in - remember to give it a name that will make it easy for you to find in the future - Now print it...
TO COMMENT ON A "POST/ARTICLE" we’ve added, beneath each "post/article", left click on the word “comment” , which takes you to a dialog box, so you can type your comments about the "post" article that you have just read...
HOW & WHY TO FOLLOW A BLOG? For our blog or any blog you read often, become a follower, to easily keep track of the blogs via your Reading List on the Blogger dashboard - On our Blog, at the bottom of the right column, you will see a "Follow" button under the "Followers" widget, and when you left click on it, a popup window appears asking if you want to follow the blog publicly or privately
All BLOGS are intended to be "informational" like any newsletter you might receive. But in addition to reading the "posts-otherwise called articles" that we publish on our BLOG, you can also copy any of the "post/articles" and save them to your word processing files so you can then print them and you can comment on what we've said in a specific "post/article" - The how to's are noted below..
- EMAIL: Most blogs have an “email signup” so simply type in your email address and you will receive anemail whenever a new post is added
- FOLLOWING PUBLICLY: Your profile image will appear in the blog's Followers widget. You will also be subscribed to updates for this blog which will appear in your Reading List on your Dashboard and following a blog creates a listing in your Google Reader account.
- FOLLOWING PRIVATELY: Your profile image and will NOT be displayed in the blog's Followers widget, but you’ll be subscribed to updates for this blog which will appear in your Reading List on your Dashboard and following a blog creates a listing in your Google Reader account
Subscribe to:
Posts (Atom)