|
Archives of Amy’s Biz Tips
February 23, 2012 - Volume 15
- PowerPoint - Using Slide Masters
A master page is used to determine a standard format for your slides. Here you can set guides that will appear on all slides, define your fonts, bullets, placeholders for text and graphics, headings, footers and more. Read more about using Slide Masters here.
- Who’s Behind That Domain Name?
Have you ever gone to a web site and wondered who is the person/organization behind that domain name (such as www.aapk.com)? Or have you searched for a domain name only to find it’s been purchased and want to know who owns it? Well there is a very simple and easy way to find out. Click here to learn how.
- You Have To Laugh
Video: Office humor - http://www.youtube.com/watch?v=mNq3ljtw118
February 16, 2012 - Volume 14
- Excel - Insert/Delete Columns or Rows
When working with Excel there are times when you need to add or delete rows or columns in your spreadsheet. Find out how simple it is to add or delete rows/columns, and get some tips that will save you a lot of frustration. Click here.
- Another Way to Search The Web
Did you know there is another way to search the web without using Google or Bing that actually combines multiple search engines to give you better results? Click here to find out the site.
- You Have To Laugh
Video: Dog happy listening to music - till it stops - http://www.youtube.com/watch?v=KBluUZ4NnZg
February 9, 2012 - Volume 13
- Word - Creating Labels
A friend asked me the other day to create labels from an Excel list. Once I finished the labels he asked me to write an up explanation on how I had done this. So, here’s the explanation for you and my friend – click here to see how easy this is.
- CMS - What is it?
CMS stands for Content Management System and is way to build a dynamic web site that enables users to maintain some or all of their content when needed, without the help of a web designer. Click here to learn more about it and why and when it is used to create a web site.
- You Have To Laugh
Video: Some odd looking animals http://www.youtube.com/watch?v=vQp1czWvuDU&feature=related
February 2, 2012 - Volume 12
- Word - Tracking Changes
When working with a document of any type (i.e. proposal, article, brochure, report, etc) there are times when it’s necessary for other people to edit and comment on the document. The problem is if you give them a Word file and they make edits you don’t know what they changed. Word alleviates this by enabling you to track changes in Word. Read on for instructions in using.
- Sending Mass Emails Using BCC
We have been asked many times by folks who want to send out emails to a large group (be it a non-profit, school, organization or small business) if using BCC is an acceptable way to send their message. While this might seem the cost effective way to send out a mailing, it’s not the best solution. Click here to read the pros and cons.
- You Have To Laugh
Video: Dog trying to throw a stick at a "Stranger" http://www.wimp.com/throwstick/
January 26, 2012 - Volume 11
- PowerPoint - A Great Place to Gather Your Thoughts
PowerPoint is not just for making presentations it also serves as a great tool to gather and save your thoughts on a project. In PowerPoint you can jot down your ideas, keep track of graphics or pictures you might use, follow your progress, combine excel tables, create your own graphic looks and flow charts, and save web links to pertinent information. Read more about how to harness the power of PowerPoint to gather your thoughts.
- Graphic Formats for Print and Web
Using the right graphic type for your web or print project can make a big difference in quality and file size of your pieces. Each gaphic type (.bmp, .gif, .eps, etc.) has a different use and format. Knowing which type works best for each application will ensure that your work always looks professional. To learn about the different types, click here.
- You Have To Laugh
Video: Cars slipping and sliding: http://www.youtube.com/watch?v=xrJuigh2aCc
January 19, 2012 - Volume 10
- Excel - Centering Text
I get a lot of questions from people that are confused on how to best center a title (text) in a spreadsheet either within one column or over a series of columns. I find many people try using spaces in front of the text to get it to center – please don’t do that anymore! Let me explain how Excel allows you to center text, click here to read on.
- Using Google Alerts
Want a quick and simple way to find out daily what is new on the web about your brand, competitor or favorite topic? Using Google Alerts you can receive an email alerting you to information about the key words/topics you have chosen. Click here to read how to use these alerts to your benefit…
- You Have To Laugh
Video: Crow Sledding on Roof Top: http://www.grindtv.com/outdoor/blog/32422/sledding%20crow%20in%20russia%20soars%20to%20internet%20stardom/
January 12, 2012 - Volume 9
- Word - Using Graphics
Adding and working with graphics in Word can seem daunting, but if you know a few tricks you can add a graphic into your document with ease. Click here to learn how.
- Using LinkedIn - Part 9
LinkedIn Answers. LinkedIn’s Answer area is a great resource if you have a question that you need answered, want to help others by answering their questions, establish yourself as an expert or even to find sales leads. Read more ....
- You Have To Laugh
Video: Girl with dancing eyebrows: http://www.youtube.com/watch?v=6Zx39v3JUUI
January 5, 2012 - Volume 8
- PowerPoint - Cutting File Size
Have you found yourself emailing a presentation to someone only to have it bounce back because it’s too large for your email system (or the person receiving it)? Then read on to find out some quick tips to alleviate this challenge.
- Using LinkedIn - Part 8
LinkedIn Finding People. To extend your search for connections or jobs further, you can use the Advanced Search feature in LinkedIn. This is especially useful for a variety of needs: seeking an old friend or work buddy, finding potential sales leads or determining the name of an executive in a company with a specific job function. Click here to explore the options available.
- You Have To Laugh
Video: Cat launcher: http://www.youtube.com/user/wacoantv?v=1ggzvZ8Kxbk&feature=pyv
December 22, 2011 - Holiday Volume
Enjoy your holiday and these funny videos:
(We will get back to serious discussions after the New Year)
December 15, 2011 - Volume 7
- Excel - Setting Column/Row Widths/Heights
Make your spreadsheets look neater and easier to read by adjusting the column width and row heights to accommodate your entries. Learn how to make these adjustments by clicking here.
- Using LinkedIn - Part 7
LinkedIn Finding Jobs. If you are looking for a job or just curious what’s available in the marketplace LinkedIn is a great resource for finding a job and being found for one. It a logical place; you have established connections and by joining Groups within your industry their members could be a potential employer or connection to one. Find out more here.
- You Have To Laugh
Video: St Bernard Balancing Objects: http://www.youtube.com/watch?v=r2WvKTBg5ME
December 8, 2011 - Volume 6
- Word - Setting Up Your Page
The default setting when you open a Word document is an 8-1/2 x 11 inch sheet set in portrait with set margins on top, bottom and both sides. But what if you want your document to be set going horizontally (landscape), need to adjust the margins or add a border to one page or the whole document? Click here to learn where to make these changes so your document will look the way you want.
- Using LinkedIn - Part 6
LinkedIn Groups. LinkedIns Groups provide a place for professionals in similar industries or with the same interests to share content, find answers, keep up with trends, post and view jobs, make business contacts, and establish themselves as industry experts. Groups can range in size from just a few people to thousands of members. Find out how to use these groups to help you succeed.
- You Have To Laugh
Video: We will we will Rock You - song by babies - http://www.youtube.com/watch?v=sO2PYbsHWJ4
December 1, 2011 - Volume 5
- PowerPoint - File Types Explained
PowerPoint lets you save files in a variety of formats (.ppt, .pps, .pot, and htm). Each format serves a different purpose. Click here to learn all about them.
- Using LinkedIn - Part 5
Using Degrees of Connection. LinkedIn is based on degrees of connection (think of the theory of the “6 degrees of separation”). On LinkedIn, people in your network are called connections and your network is made up of your 1st-degree, 2nd-degree, and 3rd-degree connections and fellow members of your LinkedIn Discussion Groups. Click here to find out how to use and why to take advantage of these degrees.
- You Have To Laugh
Video: What happens when you twirl your backpack? http://www.youtube.com/watch?v=SDYiHzHXj68
November 23, 2011 - Volume 4
- Excel - Text to Column
Excel makes it easy to separate data into columns – using either a character or a specific number of characters to determine where the break occurs. Let’s assume you were just given an excel list that contains name and addresses. The first and last name is in one column, the street, city and zip are in another column, and the phone number is in the third column. But you need each field (first, last, street, city, etc) in separate columns. Click here to learn how to do this quickly and simply.
- Using LinkedIn - Part 4
Making Connections. The key to using LinkedIn is taking advantage of making connections with people you know currently and from your past; colleagues, friends, business associates, and friends of friends. You can use these connections to find a job, generate business, share conversations and ideas with people in your industry or who have similar interests, or just catch up with old friends. LinkedIn helps you find people you know through a variety of ways. Click here to find out more.
- You Have To Laugh
Video: Kids talk about Thanksgiving and what it means to them. http://www.youtube.com/watch?v=pZPCxF9YtDE
November 17, 2011 - Volume 3
- Word – Changing Text Cases
Have you ever been given a list or document and the text is in UPPER CASE when you needed it in Title Case? How many times have you retyped that list? Be honest. No need to retype anymore - you can use Word or PowerPoint to quickly change the cases of text (even if it’s in Excel). Find out how simple this is - click here.
- Using LinkedIn - Part 3
Using Your Profile Page to Your Advantage. In the last issue we talked about how to create your profile. Now it’s time to edit and add more information to expand your profile. You do this by viewing your profile and taking advantage of the features it offers: tracking the progress of completing your profile, see who’s viewed your profile, view your connections, ask for recommendations and see your profile the way the public sees it. Click here to learn how. Click here to learn more.
- You Have To Laugh
Video: Cat Waking You Up (this one has been around for a while but is still funny) http://www.youtube.com/watch?v=w0ffwDYo00Q
November 10, 2011 - Volume 2
- PowerPoint: Slide Design
Excel is a great way to “massage” data into a format that you can use for a variety of applications (i.e., Word merges, e-mail lists, or tracking transactions). Excel allows you to sort a section of data or specific rows or columns. The sort can be done in three levels and in ascending or descending order. Read more.
- Using LinkedIn - Part 2
Creating and Updating Your Profile. It’s important to have your profile as complete as possible and kept up-to-date. This is the place people come to find out more about you – whether it’s a potential employer, client or and old colleague. You can also “strut your stuff” in your profile and it’s not limited to the standard 2 sheets for your resume. This gives you the room to expand upon your experience and let others comment on your expertise. Read the 2nd in this series.
- You Have To Laugh
Video: “We ate all your halloween candy” (I know it’s after the season, but I couldn’t wait till next year to show this one) http://www.youtube.com/watch?v=_YQpbzQ6gzs
November 3, 2011 - Volume 1
- Excel Sorting
Excel is a great way to “massage” data into a format that you can use for a variety of applications (i.e., Word merges, e-mail lists, or tracking transactions). Excel allows you to sort a section of data or specific rows or columns. The sort can be done in three levels and in ascending or descending order. Read more.
- Using LinkedIn - Part 1
What is LinkedIn? Have you subscribed and just don’t know what to do with it? What can you gain by being on LinkedIn? I will guide you through how to take advantage of this massive network of business professionals. Read the first in a series.
- You Have To Laugh
Video: Who Got Into the Garbage? http://www.youtube.com/watch?v=PuA6ZjpEJys
|
