Page breaks is Microsoft Word’s method of signaling that the following text should begin at the top of a new page. You probably know that you can insert a page break by using your mouse and going to the drop down menu in Word. However, this involves removing your hands from the keyboard and using the mouse, which can disrupt the pace at which you are typing.
The quickest way to enter a page break using the keyboard is to simply press Ctrl+Enter. Word will add the page break and you can continue typing away.
March 3, 2010
Microsoft Excel - Changing your Worksheet Tab Color is Easy!
To change the worksheet tab color in Microsoft Excel 2003 & 2007 follow these simple steps:
1. Click on the tab of the worksheets you want to color.
2. Right click on the worksheet tab.
3. Click on Tab Color.
4. Pick a color.
1. Click on the tab of the worksheets you want to color.
2. Right click on the worksheet tab.
3. Click on Tab Color.
4. Pick a color.
March 2, 2010
There's no such thing as a computer expert
Sometimes when I'm introduced the person will say "Pamela's a computer expert." I always try to quickly correct that misconception. There is no such thing as a computer expert. There are people who know more than you do. Maybe people who know a lot more than you do. But no one knows everything about computers. It's such a huge topic and it's evolving so quickly, that at best you can learn one little aspect and be an expert at that.
Any computer person I know will tell you they get frustrated with new software and new hardware set ups just like everyone else. Because it's their job and maybe their passion, they just stick with it until they figure it out. That doesn't mean you're stupid because you can't figure out why your all-in-one printer won't fax. Or because you're struggling to learn a new piece of software. Computer knowledge doesn't come to you at birth or through osmosis. You have to work at it. It's a skill that requires training like all other skills.
I'm learning two new software programs right now. Trust me, there have been plenty of calls to tech support or searches through my reference books to find solutions. Tech support is one of the most important criteria for choosing software, in fact. You have to have assistance.
You and all of the other "experts."
Any computer person I know will tell you they get frustrated with new software and new hardware set ups just like everyone else. Because it's their job and maybe their passion, they just stick with it until they figure it out. That doesn't mean you're stupid because you can't figure out why your all-in-one printer won't fax. Or because you're struggling to learn a new piece of software. Computer knowledge doesn't come to you at birth or through osmosis. You have to work at it. It's a skill that requires training like all other skills.
I'm learning two new software programs right now. Trust me, there have been plenty of calls to tech support or searches through my reference books to find solutions. Tech support is one of the most important criteria for choosing software, in fact. You have to have assistance.
You and all of the other "experts."
February 25, 2010
Social Media - It's Only Networking
Micro View
If I attend a professional association dinner, I’m going to introduce myself as Your Computer Lady but I’m going to talk sports, make a joke about the rubber chicken, ask about Ron’s daughters or listen to the horror story about the building project in Tucson that one of my architect friends is working on. If someone asks me a computer question, I’ll give them an answer. Hopefully the person sitting beside them will listen in and think, “Oh, that’s a good answer. Pamela’s knows a thing or two about computers.” Down the road when either of those people have a computer project, they’ll think of me and give me a call.
Macro View
I set up a LinkedIn account. I introduce myself as Your Computer Lady but I’m going to talk about sports, make a joke about the rubber chicken, ask about Ron’s daughters, … …
Clear away the hype and fear of doing something new and social media is just plain old networking. You’re doing it on a grander scale (8 people at the dinner table vs 58 LinkedIn direct connections or 252,600+ with 3 levels of connection) but it is still networking.
Just like networking at an organization, networking online takes a little time. Joining a new organization means you’re seeing more new faces. You’re taking time to build the relationships. You’re gathering business cards and inputting them into your contact management system. But after those basics are done, maintaining the relationships is relatively easy and doesn’t require a lot of time. But you have to be consistent. If you only show up every six months, you’re always at square one. Once you’ve set up your online account and filled out your profile, started connecting with friends, you can switch to maintenance mode too. Show up once a week and respond to invitations, send some messages, add some info.
You want to use social media for the same reasons you network at a meeting. Get your name out there! Be viewed as an expert! We live in a big, high technology, information-explosion world. We want to – need to – connect with people. Social media gives your company the ability to do that. You can humanize your company. You can reach out person-to-person.
As Jennifer Maggiore of Maggiore Consulting pointed out, “There’s no penalty for being early to the game. But there is a big penalty for being late!” eMarketer reports that there was an 11% increase in the use of social media in 2008. 41% of all Internet users visited a social media site at least monthly. They predict that 79 million people (40% of all Internet users) will put content at least once a month on a social media site in 2009.
Your firm can start small. Encourage your employees to participate. All of the Fortune 500 firms have social media activities. 499 of them have vice president level and above participants. But any employee can assist the cause. Whole Foods has tweeters from several stores in addition to their central page. Build your presence. There are firms like Maggiore’s that specialize in social media. If you need to get to more in depth, locate your target audience or increase your presence quickly – you want to contact a specialist. This is an emerging technology. A guide can get you to the destination faster.
If you’re early to the game though, you can take your time.
1. Choose one, maybe 2, networks to join and build.
2. Get that network to the maintenance stage before you take on another one.
3. Tie your networks together. A post on my blog shows up on my LinkedIn page. A Twitter message shows on my Facebook wall.
4. Measure your activity and success. There are tools like TwitterGrader that help you measure what you’re accomplishing.
My recommendation is to start with LinkedIn. It’s a pure business site that is simple to use. You can make good connections. Then add Twitter. Those little 140 character messages have potential. Check out twitter.com/JetBlue, /Whole Foods or /ScottsdalePD to see some business results. Yes, you can follow John McCain now too. Then expand into Facebook, Yelp or some of the other sites.
The Arizona Small Business Association is doing a series of social media classes in April and May. Check their web site for details.
Connect with me:
www.LinkedIn.com/in/YourComputerLady
@PamelaBir at Twitter
Pamela Bir on Facebook
If I attend a professional association dinner, I’m going to introduce myself as Your Computer Lady but I’m going to talk sports, make a joke about the rubber chicken, ask about Ron’s daughters or listen to the horror story about the building project in Tucson that one of my architect friends is working on. If someone asks me a computer question, I’ll give them an answer. Hopefully the person sitting beside them will listen in and think, “Oh, that’s a good answer. Pamela’s knows a thing or two about computers.” Down the road when either of those people have a computer project, they’ll think of me and give me a call.
Macro View
I set up a LinkedIn account. I introduce myself as Your Computer Lady but I’m going to talk about sports, make a joke about the rubber chicken, ask about Ron’s daughters, … …
Clear away the hype and fear of doing something new and social media is just plain old networking. You’re doing it on a grander scale (8 people at the dinner table vs 58 LinkedIn direct connections or 252,600+ with 3 levels of connection) but it is still networking.
Just like networking at an organization, networking online takes a little time. Joining a new organization means you’re seeing more new faces. You’re taking time to build the relationships. You’re gathering business cards and inputting them into your contact management system. But after those basics are done, maintaining the relationships is relatively easy and doesn’t require a lot of time. But you have to be consistent. If you only show up every six months, you’re always at square one. Once you’ve set up your online account and filled out your profile, started connecting with friends, you can switch to maintenance mode too. Show up once a week and respond to invitations, send some messages, add some info.
You want to use social media for the same reasons you network at a meeting. Get your name out there! Be viewed as an expert! We live in a big, high technology, information-explosion world. We want to – need to – connect with people. Social media gives your company the ability to do that. You can humanize your company. You can reach out person-to-person.
As Jennifer Maggiore of Maggiore Consulting pointed out, “There’s no penalty for being early to the game. But there is a big penalty for being late!” eMarketer reports that there was an 11% increase in the use of social media in 2008. 41% of all Internet users visited a social media site at least monthly. They predict that 79 million people (40% of all Internet users) will put content at least once a month on a social media site in 2009.
Your firm can start small. Encourage your employees to participate. All of the Fortune 500 firms have social media activities. 499 of them have vice president level and above participants. But any employee can assist the cause. Whole Foods has tweeters from several stores in addition to their central page. Build your presence. There are firms like Maggiore’s that specialize in social media. If you need to get to more in depth, locate your target audience or increase your presence quickly – you want to contact a specialist. This is an emerging technology. A guide can get you to the destination faster.
If you’re early to the game though, you can take your time.
1. Choose one, maybe 2, networks to join and build.
2. Get that network to the maintenance stage before you take on another one.
3. Tie your networks together. A post on my blog shows up on my LinkedIn page. A Twitter message shows on my Facebook wall.
4. Measure your activity and success. There are tools like TwitterGrader that help you measure what you’re accomplishing.
My recommendation is to start with LinkedIn. It’s a pure business site that is simple to use. You can make good connections. Then add Twitter. Those little 140 character messages have potential. Check out twitter.com/JetBlue, /Whole Foods or /ScottsdalePD to see some business results. Yes, you can follow John McCain now too. Then expand into Facebook, Yelp or some of the other sites.
The Arizona Small Business Association is doing a series of social media classes in April and May. Check their web site for details.
Connect with me:
www.LinkedIn.com/in/YourComputerLady
@PamelaBir at Twitter
Pamela Bir on Facebook
Why Use Portable Document Format (PDF)?
Often you want to save your files so they cannot be modified, but you want to be able to share and print them. Examples include resumes, legal documents, newsletters, and files intended to be read and printed. PDF formats can help. By using an add-in, which is an extra function you download, you can convert a file, from your Microsoft Office programs, into a PDF format
Portable Document Format (PDF) preserves document formatting and enables file sharing. When the PDF format file is viewed online or printed, it retains the format that you intended. Data in the file cannot be easily changed. The PDF format is also useful for documents that will be reproduced by using commercial printing methods.
There are a lot of PDF Writers that you can purchase or download for free from the Internet. Please research and choose the one you feel will work best for your Company’s needs.
Portable Document Format (PDF) preserves document formatting and enables file sharing. When the PDF format file is viewed online or printed, it retains the format that you intended. Data in the file cannot be easily changed. The PDF format is also useful for documents that will be reproduced by using commercial printing methods.
There are a lot of PDF Writers that you can purchase or download for free from the Internet. Please research and choose the one you feel will work best for your Company’s needs.
February 24, 2010
PowerPoint 2007 Transition Effects Tip
Adding a transition to your presentation gives it a more polished look. However, it’s best not to use too many different types of transitions within a presentation. Pick one or two types of transaction and use them consistently through your whole presentation.
1.Click the animation tab.
2.Click the down arrow and the “More” option will appear. The Transition Gallery will appear.
3.Click a transition effect – a preview of the transition appears on the slide.
4.Pick a transition speed, fast, slow or medium, which you want the transition to appear.
5.Click Preview.
6.If you don’t like the transition or speed, just go back to the above steps to change to what you would like.
1.Click the animation tab.
2.Click the down arrow and the “More” option will appear. The Transition Gallery will appear.
3.Click a transition effect – a preview of the transition appears on the slide.
4.Pick a transition speed, fast, slow or medium, which you want the transition to appear.
5.Click Preview.
6.If you don’t like the transition or speed, just go back to the above steps to change to what you would like.
February 20, 2010
Automatically Sort Data - Microsoft Word 2007
When you're creating a list in Microsoft Word, you don't need to worry about putting it in alphabetical order. You can put it in alphabetical order after you complete the list, without any time-consuming cutting and pasting. All you need to do is use Word's Sort feature.
To use Word's Sort feature:
To use Word's Sort feature:
1. Start by highlighting the data you would like to sort.
2. Click the Sort button in the Paragraph section of the Home ribbon.
3. Use the dropdown box to select the type of data you selected. You can choose from text, date, or number.
4. Choose where you would like to put the data in ascending or descending order.
5. Click OK. Word automatically sorts your data.
Subscribe to:
Posts (Atom)
