These Tips Are Courtesy of AAPK

Subscribe to Amy’s Biz Tips e-newsletter.

Enjoy a weekly e-newsletter that gives you tips on using Excel, Word, PowerPoint,
Social Media, the Web and Marketing to help make your job easier.

Archives of Amy’s Biz Tips

February 26, 2015 - Volume 156

  • PowerPoint  - Creating Custom Layouts
    At the beginning of the month I walked you through how to work with Layouts in PowerPoint. In that article I talked about the standard layouts that are built in to PowerPoint. This time I am going to show you how to create a custom layout ...  Read on

  • Organizing Your Twitter Followers
    Have you been using Twitter and have (hopefully) many followers? Do you have them organized and know which are potential fakes? If not then read on for help to keep your list of followers ...  Read more.
  • You Have To Laugh
     Dog walks 15 blocks to find owner in the hospital.... view it here

February 19, 2015 - Volume 155

  • Word - List Sorting
    You don’t have to use Excel to sort a list of names, addresses or other data from a Word document. Word lets you sort a simple list or a table ...  Read on

  • Myths About Content Marketing
    The definition of SEO (Search Engine Optimization) has changed … now it’s not all about how high you can get your URL listing on the search engines instead it’s about making connections and using content ...  Read more.
  • You Have To Laugh
     Couple lives in the cloud.... view it here

February 12, 2015 - Volume 154

  • Excel - Format Painter
    Looking for a quick and simple way to set up the formatting of objects and text in your Excel sheet? Format Painter is a feature that is most likely overlooked but shouldn’t be ...  Read on

  • Using Short Videos
    You’ve seen them before, short videos featuring a product or service. Did you think these short videos are only for use by the big budget advertisers? Think again ...  Read more.
  • You Have To Laugh
     Dog rides bus on own to dog park.... view it here

February 5, 2015 - Volume 153

  • PowerPoint - Slide Layouts
    You have seen these before, the placeholders (containers) on your slides when you open a new document or add a slide. But do you really know how to use them or how to get rid of them if you prefer your own ...  Read on

  • Small Business Marketing Budgets
    Are you a small business trying to figure out how to achieve search marketing on a very tight budget? If so you are not alone. In December 2014, a survey of small online marketing ...  Read more.
  • You Have To Laugh
     Pingpong balls and mouse traps.... view it here

January 29, 2015 - Volume 152

  • MS Office Document Recovery Task Pane
    I am sure you have encountered this before – you open an MS Office program (such as Word, Excel or PowerPoint) and you are presented with the Document Recovery task pane and you wonder first why and second, which file do I choose to recover ...  Read on

  • The 3P’s to Great Branding
    In this crazy world of social media and marketing with all the new trends and bell and whistles, sometimes it is good to stop and look at some basic marketing principles before doing anything more with your brand or marketing ...  Read more.
  • You Have To Laugh
     Walrus exercising - too funny.... view it here

January 22, 2015 - Volume 151

  • Word - Adding a Date to a Document
    Word offers a few ways to add a date to a documen;, whether you want today’s date to appear in the document or in a header/footer or need to track a documents history by  inserting the creation, print or last save date   ...  Read on

  • Astronauts are Mailed a Wrench
    Times are a changin’! Because of the advances in technology and the way data is moved, you can literally send, electronically, a physical object (well sort of) to anyone – even if they are in space  ...  Read more.
  • You Have To Laugh
     Never challenge Gaston .... view it here

January 15, 2015 - Volume 150

  • Excel - Combining Tricks to Manipulate Data
    There are so many tricks in Excel to help you. Over the past two years I have shown you these tips one at a time. But if you combine these tricks you can manipulate data to make   ...  Read on

  • Trends in Measuring Social Media
    Over the past four years, as social media has become a larger part of every company’s marketing toolbox, there have been shifts in what is measured to determine the success of campaigns. These shifts are different than  ...  Read more.
  • You Have To Laugh
     Cat Owners’ Struggles .... view it here

January 8, 2015 - Volume 149

  • PowerPoint – Create Your Own Theme
    PowerPoint provides many pre-designed theme/templates, but they get boring after awhile and if you need something specific for your brand, they don’t cut it. So, what to do? Create your own  ...  Read on

  • Social Marketing Organization for 2015
    Now that it’s a new year it is the perfect time to get your social media marketing organized to achieve the best results for your brand. Having an outline and a plan for how and when you are going to use social media is of the utmost importance ...  Read more.
  • You Have To Laugh
     Extreme weight loss for a dog? .... view it here

December 18, 2014 - Volume 148

  • Word - Opening Menu Windows
    Sometimes when working in Word (or another MS Office program) you need to have a specific menu window open for ease of use vs. opening the menu ribbon every time you need to use an option. An example of this would be when you are making multiple font  ...  Read on

  • Going Incognito When Viewing Your Web Presence
    Do you know how to see your web site or social media venues the same way a viewer does when visiting for the first time? There is a browser feature that will allow you to do this and you might be amazed at what  ...  Read more.
  • You Have To Laugh
     Sever year old wants off the “Naughty” List .... view it here

December 11, 2014 - Volume 147

  • Excel - Function Insert
    Functions in Excel make calculating numbers a breeze. Did you know there are over 330 pre-defined Excel functions? That’s a lot to choose from. Some of them are commonly used like AVG (average a group of numbers), SUM ...  Read on

  • Tips to a Marketable Website
    Whether you have an existing web site or are starting a new business and need one, understanding some simple tricks to keep your site current and fresh is important. To avoid mistakes, lost time and revenue ...  Read more.
  • You Have To Laugh
     Cops give gifts instead of tickets .... view it here

December 4, 2014 - Volume 146

  • PowerPoint - Insert Menu - Part 1
    Of course adding things to your PowerPoint slide set is part of creating a presentation but did you know there are many things you can insert that you might not have thought of? Open up the Insert tab on the menu and follow me as I give you the low-down  ...  Read on

  • Changing Your Hosting Provider
    Your web hosting provider is an important part to have a web presence, they house your web files for the world to access via your web address. During the course of having a web site there will most likely be at least one time that you need to change hosting provider  ...  Read more.
  • You Have To Laugh
     How a dog drinks water - fascinating .... view it here

November 20, 2014 - Volume 145

  • Word - Keyboard Navigation
    Sometimes, when working within a Word document (as you are typing) it’s easier to use the keyboard than the mouse to move around the document. Yes, you can use the arrows to move around, but by combining key strokes you can move the insertion point ...  Read on

  • Finding Blog Content ... From Your Competitors
    If you are responsible for providing the content for your web site, blog or newsletter you know it can be a chore to think of new and interesting information every week or so.  Why not troll your competitors’ site and blogs for ideas  ...  Read more.
  • You Have To Laugh
     A Toddler Tries to Get His Point Across to His Mom .... view it here

November 13, 2014 - Volume 144

  • Excel - Function Keys
    You’ve seen the keys on your keyboard – F1, F2, etc. Have you ever played with them to discover what they do in Excel? You might be surprised what some of the upper numbered ones do that you didn’t know about. These keys give you a quick way ...  Read on

  • Marketing Tips for Hastags
    You continue to see them more and more – hashtags (#). Many companies are using them in their marketing campaigns such as Travelocity (Go & Smell the Roses) to successfully implement  ...  Read more.
  • You Have To Laugh
    A Horse Snores While Being Rescued From a Pool .... view it here

November 6, 2014 - Volume 143

  • PowerPoint - Using the Guide Lines
    When creating a slide set you want all your elements to line up from slide to slide to avoid your viewers’ attention being disrupted as you advance through the presentation. The way to keep everything in its place is to use ...  Read on

  • What Really is the “Cloud”?
    If you haven’t heard of the “Cloud” your head has been in the clouds.  But do you really know what the “Cloud” is and where it resides? ...  Read more.
  • You Have To Laugh
    Literally, see Paris from an Eagle’s Eye View .... view it here

October 30, 2014 - Volume 142

  • Word - Changing Table Margins
    Using tables in Word is great but sometimes it can be tricky to get the text to appear where you want it. The text could be cut off or not fill the whole box. To fix this problem ...  Read on

  • Employees Promoting Your Company Thru Social Media
    Are you wondering how to empower your employees to use social media to promote your business/brand? Adobe uses their employees to be brand ambassadors with great success   ...  Read more.
  • You Have To Laugh
    A kid gets stuck in a claw-vending machine .... view it here

October 23, 2014 - Volume 141

  • Excel - So You Have a List of...
    So, you have a list of names, numbers, parts, etc. that you need to convert from a list in Word into an Excel sheet ...  Read on

  • Digital Content Writing Tips
    These days the written word is more important (and digitally everywhere) then ever. If you are a marketer or business owner  ...  Read more.
  • You Have To Laugh
    Dog gets help from police officer and then .... view it here

October 16, 2014 - Volume 140

  • PowerPoint - Image Compression
    Have you created a PowerPoint slide set and while trying to email it you discovered that the file size is huge? This used to happen to me often ...  Read on

  • LinkedIn - Increase Your Endorsements
    Do you have many endorsements on your LinkedIn profile? Do you need more? (your answer should be YES). Well if so ...  Read more.
  • You Have To Laugh
    Price is Right Bid Goes Way Wrong - view it here

October 9, 2014 - Volume 139

  • Word -  doc vs docx File Type Differences
    As the versions of Word evolve Microsoft has changed the file type for Word documents from version 2003 to 2007 and above. So here’s what you need to know about these different file types ...  Read on

  • Your Desktop in 1981 vs Now
    If you think about your desktop (literally the top of your desk) in 1981 and then look at the top of your desk today and you will see a huge difference! Harvard Innovations Labs has created a video showing how things ...  Read more.
  • You Have To Laugh
    Cat vs Dog - view it here

October 2, 2014 - Volume 138

  • Word -  Counting Characters and Words
    I am sure you recall school and being assigned to write an essay of 2,000 words and then counting each word, ah the good old days. Now our kids, and us, have it simple because Word will do the counting for you, not only of words, but characters, lines, and other key information ...  Read on

  • LinkedIn - Export Your Contact List
    This past week I sent a personalized mass emailing to all my LinkedIn contacts. When I first thought of this I figured I was going to have to go connection by connection to gather the data (first, last, email address, title, etc). But I found a quick way to download my contact list from LinkedIn. ...  Read more.
  • You Have To Laugh
    Frustrated golfer has melt down - view it here

September 25, 2014 - Volume 137

  • Windows 8 - Reverting Bck to Your Desktop
    I don’t know about you but I don’t like Windows 8’s start screen – the one with multiple boxes. I have tried many times to work within these screens but gave up. But did you know there is a quick trick to get back to seeing the Desktop view (like in old Windows versions?)...  Read on

  • Adding a Twitter Feed to Your Web Site
    One of my clients has become a huge Twitter fan to promote his business and requested that we add a Twitter feed to his web site. If you use Twitter read on to learn how easily you can add a feed to your web site ...  Read more.
  • You Have To Laugh
    Marmot messes up Greenpeace's view of Glacier National Park - view it here

September 18, 2014 - Volume 136

  • Excel - Formulas, Text and Numbers
    Do you know what differs when entering formulas, text or numbers in Excel? If so, why do you sometimes have problems with sorting or formulas or dropping a zero from a zip code...  Read on

  • Avoid Creating Spam
    When you send out an email campaign or newsletter (like this one) you are bound to get bounces. But have you spent any time figuring out why you are getting those bounces? If not you are wasting ...  Read more.
  • You Have To Laugh
    Dog loves a trampoline - view it here

September 11, 2014 - Volume 135

  • PowerPoint  - Save As File Types
    Did you know that there are multiple file types that you can use to save a PowerPoint presentation? Have you ever wondered what they are and what they are?...  Read on

  • Can You Help Me?
    For a long time I have been helping you with tips to make your job easier, so can you return the favor? ...  Read more.
  • You Have To Laugh
    Animals will eat anything - view it here

September 4, 2014 - Volume 134

  • Word - AutoCorrect Options
    Are you a clumsy typist? Do you tend to inadvertently type two uppercase letters in an initial word or forget to capitalize the first word in a sentence or hit the caps lock button frequently in error?...  Read on

  • One Simple, Important Web Site Rule
    It is not uncommon to have multiple links in your web site to outside sites (such as an article, reference, etc). But did you know if you don’t set up these links properly it can be a hindrance to your web analytics and overall results of your site? ...  Read more.
  • You Have To Laugh
    Dog to fox - don’t mess with my stuff - view it here

August 28, 2014 - Volume 133

  • PowerPoint - Hiding Slides
    I don’t know about you, but many times when I am creating a presentation in Powerpoint I create one or two slides that I don’t want to show but need to keep them for references in the slide set. You could move them to the back of the slide set, but...  Read on

  • Cleaing Your Email Box
    Do you need a fast and simple way to clean out your email inbox? Then read on for an easy way to sort and clean out what you don’t want and keep  ...  Read more.
  • You Have To Laugh
    Duck whisperer? - view it here

August 14, 2014 - Volume 132

  • Excel - Printing Tips
    I am sure you have run into this problem before … you send your worksheet to the printer and it doesn’t print correctly – so frustrating! Don’t fear, there is a simple way to tell Excel how to print your spreadsheet in the way you need it ...  Read on

  • Facebook - Are Your Posts Working?
    Are you wondering how your posts are doing on Facebook? Do you need to know what posting frequency works best? Then you need to explore Facebook’s Insights to find the answers ...  Read more.
  • You Have To Laugh
    Bear saves a crow from drowning - view it here

August 7, 2014 - Volume 131

  • Word - Line, Paragraph, Section & Page Breaks
    Depending on how your document is set up in Word you will most likely need to make breaks to lines, paragraphs, sections and pages. While you might say, “hey I know how to make a line break” it’s always good to review the basics and various options ...  Read on

  • Facebook Chat Stickers
    If you chat with friends on Facebook with the Chat feature (like AOL’s instant messenger) you may have noticed your friends responding with icons (graphics) vs text. I am not talking about the usual smiley faces ...  Read more.
  • You Have To Laugh
    A cat calls 911 from the animal shelter - view it here

July 31, 2014 - Volume 130

  • PowerPoint - Font Options
    In PowerPoint there are a variety of different ways to format your text to create a more impactful message or fit content to your slide. I often forget some of these options exist, so I figured we’d review them together ...  Read on

  • Creating Newsletter Content
    An email newsletter (like this one) can be a low cost and great way to keep your name out in front of your customers while establishing yourself as an expert in your field. But how do you start? And how do you create content that is of interest to your viewer and avoids many recipients from unsubscribing?...  Read more.
  • You Have To Laugh
    A dog apology for taking baby’s toy - view it here

July 24, 2014 - Volume 129

  • Excel - Freezing Panes
    When working on a large spreadsheet you have most likely run into this problem, you scroll down or over to the right and you lose sight of your column headers and row titles. But don’t fret Excel has a simple solution ...  Read on

  • What is a Premimum Domain Name?
    A few weeks ago I was looking for a domain name for a project and discovered that the .com we wanted was available. When I went to register it, the cost was almost a $1,000! I was shocked and began to do some research to understand what constitutes a domain name being premium...  Read more.
  • You Have To Laugh
    Funny Video - Turtle and dog play soccer?  - view it here

July 17, 2014 - Volume 128

  • Word - Using it to Find Symbols
    When looking for symbols to use for bullets, to indicate a scientific notation or create a decoration there are several standard fonts (such as WingDings) you can use. But do you know which characters create which symbols? ...  Read on

  • SEO and Graphics with Text
    Are you concerned about your SEO for your web site? Do you understand how the search engines review your site? Do you use graphics that contain text? If so read on to learn tricks to help your ranking...  Read more.
  • You Have To Laugh
    Funny Video - Not so boring flight attendent - view it here

July 10, 2014 - Volume 127

  • Difference between .TXT and .CSV Files
    If you have ever had to load a list of data to a database or email addresses for a mailing you might have encountered .txt or .csv files. So what are the differences between these file types ...  Read on

  • Organizing Products for Your Online Store
    Are you considering creating an online store or already have one you need to think about organizing your product data. Keeping a list of the products and attributes can save you a lot of time  ...  Read more.
  • You Have To Laugh
    Funny Video - Cat Helps Owner with Nightly Routine  - view it here

June 26, 2014 - Volume 126

  • PowerPoint - Adding Blank Slides
    Adding blank slides to a presentation is a basic task in PowerPoint and there are several ways to do this – learn them all and then choose your favorite ...  Read on

  • Facebook Marketing Tips from Experts
    Struggling with how to use Facebook to market your product or services? Then read these 6 tips from marketing experts ...  Read more.
  • You Have To Laugh
    Funny Video - Bear in a hammock  - view it here

June 19, 2014 - Volume 125

  • Excel - How it Calculates Formulas
    Even if you use Excel daily, it’s always good to review the “basics”. Today I am going to explain how Excel works with calculations; relative and absolute references in formulas ...  Read on

  • LinkedIn - Publishing Platform
    Establishing yourself as an expert in your field is key to expanding your network and business. LinkedIn has been a great way to attract followers and now they have added the publishing platform (for free) ...  Read more.
  • You Have To Laugh
    Funny Video - Balloon Office Prank  - view it here

June 12, 2014 - Volume 124

  • When one door opens .. help me open the next door
    As the old addage goes “when one door closes, another opens” but I add to that “the hallway inbetween is dark and lonely”! I am in that hallway and ...  Read on

  • You Have To Laugh
    Funny Video - Cop Lets Family of Ducks Cross the Street - view it here

June 5, 2014 - Volume 123

  • Word - Table Calculations
    You don’t have to use Excel to create a table for calculations in a Word document. Word gives you the ability to calculate simple formulas ...  Read on

  • SEO is Dead
    The buzz word a couple of years ago for marketing your web site was SEO (search engine optimization). Everyone wanted to be at the top of the search engines ...  Read more.
  • You Have To Laugh
    Funny Video - Bunny Eating Raspberries - view it here

May 22, 2014 - Volume 122

  • Excel - Columns and Rows as Print Borders
    Recently, I had a client ask me how she can print a report from Excel without having to print the full spreadsheet. Excel contains many tricks to accommodate printing -  one of the best is ...  Read on

  • Copying Web Page Content
    Some times you need to copy content from a web page – whether it is text, links, graphics or other content. Have you done this and discovered ...  Read more.
  • You Have To Laugh
    Funny Video - White Elephant Origami -  view it here

May 15, 2014 - Volume 121

  • PowerPoint - Tables
    If you need to create a table for a presentation in PowerPoint you don’t need to do it in Excel. PowerPoint provides you with the ability to insert tables ...  Read on

  • Using Instagram
    Have you heard of Instagram but are unsure how to use it? You are not alone...  Read more.
  • You Have To Laugh
    Funny Video - Cat and Chicks -  view it here

May 8, 2014 - Volume 120

  • Word - Quick Parts
    Depending on your business, there are times when creating documents requires the same text or graphic, for instance a signature line, a legal statement, logo, or address. You could recreate it each time ...  Read on

  • SEO Simple Tips
    Do you want to get better search engine results?  Then use these simple tips in your web site to increase your presence...  Read more.
  • You Have To Laugh
    Funny Video - Osprey takes over Maryland traffic cam - view it here

May 1, 2014 - Volume 119

  • Excel - Mouse and Keyboard Tricks
    Using mouse or keyboard shortcuts in Excel can save a lot of time if you know they exist. Here are a few of my favorites ...  Read on

  • How Did They Create That Printed Piece?
    Have you ever gotten a really neat printed invitation or marketing piece and wondered how it was made or how did they get it to open...  Read more.
  • You Have To Laugh
    Funny Video - Really well trained dog- view it here

April 24, 2014 - Volume 118

  • PowerPoint - Paste Special
    When working in PowerPoint there are many times when you need to insert text, charts, graphics, etc into your slides. You could use the Paste function (CTRL-V) but you might not always get the results you want. To avoid this...  Read on

  • FaceBook Strategies for Attorneys (and other businesses)
    Using FaceBook to reach your prospective clients is a cornerstone for any businesses. If you are an attorney and are not using FaceBook in your marketing strategy then you will want to read an article from Web Marketing Today. And if you aren’t an attorney, read the article...  Read more.
  • You Have To Laugh
    Funny Video - Turning 4 Years Old Can Be Difficult - view it here

April 17, 2014 - Volume 117

  • Word - Mail Merge
    If you have been reluctant to try a mail merge, don’t be, it’s fairly straightforward and Word has a wizard that will walk you through...  Read on

  • LinkedIn Skills and Endorsements
    Skills and endorsements in LinkedIn are important to your profile and networking – it lets viewers know that others recognize your...  Read more.
  • You Have To Laugh
    Funny Video - Cast of Lion King Breaks Out in Song on a Plane - view it here

April 10, 2014 - Volume 116

  • Excel - Viewing Formulas
    When working on spreadsheets with multiple and or complicated formulas it helps to be able to see the formula and cells...  Read on

  • Talking to Your Customers
    When you create content for your web site, social media or other marketing campaigns you want to be sure you are speaking in your customer’s vernacular not yours...  Read more.
  • You Have To Laugh
    Funny Video - Fox Loves His Belly Rubbed - view it here

April 3, 2014 - Volume 115

  • PowerPoint - Text Alignment
    Have you run into this problem - you are working on a presentation and find that one of your text boxes is not aligning your text correctly? PowerPoint gives...  Read on

  • SEO - No Longer Just About Search Engines
    No longer does Search Engine Optimization (SEO) mean purely optimizing your site for search engines. Now you need to look at social media...  Read more.
  • You Have To Laugh
    Funny Video - Great Ad Campaign - view it here

March 27, 2014 - Volume 114

  • Word - Formatting Graphics
    Not everyone has photo imaging software so Word has stepped in to help you format/adjust your pictures and graphics. From brightness to styles Word gives you a lot...  Read on

  • Evolution of Digital Marketing
    Have you ever thought about the evolution of digital marketing? When it started, how it got to where we are today, and what companies have stood the test of time.....  Read more.
  • You Have To Laugh
    Funny Video - How to wake a sleeping baby - view it here

March 20, 2014 - Volume 113

  • Excel Pivot Tables - Getting Started
    Last week I discussed the basics of pivot tables, this week we are going to build our first pivot table so you can understand how they work...  Read on

  • Why Simple Web Design is Best
    When it comes to web design – simpler is better and it can be proven! In August, 2012, Google conducted a study and researchers found that users judge websites as beautiful or not within....  Read more.
  • You Have To Laugh
    Funny Video - Cat meets bunny - view it here

March 13, 2014 - Volume 112

  • Excel Pivot Tables - The Basics
    Are you on data overload and need a way to translate your data in to information that makes sense? With pivot tables in moments you can see who sold the most products in the coastal region or which quarters were the most profitable...  Read on

  • Out of the Box Thinking to Create a Buzz
    This past Christmas an airline created a very “out of the box” campaign that went viral in no time and got them a ton of publicity, name recognition and goodwill....  Read more.
  • You Have To Laugh
    Funny Video - Grandma Dancing to Ice, Ice, Baby - view it here

March 6, 2014 - Volume 111

February 27, 2014 - Volume 110

  • Word - Spelling and Grammar Options
    Does it drive you crazy when Word highlights a unique word indicating it’s misspelled when it’s not? Or would you prefer Word not make grammar suggestions to you? If so, find out how to change...  Read on

  • Promoting Your Event in Social Media
    Do you have an upcoming event that you want to promote on social media but not sure how best to do it? Then read on for hints on how to create an effective plan to get the most exposure....  Read more.
  • You Have To Laugh
    Funny Video - David Atrtenborough Commentary on Women’s Oylmpic Curling - view it here

February 20, 2014 - Volume 109

  • Excel Data: Rows to Columns
    Do you have data listed in rows but need to have it appear as columns? Or visa versa?... 
    Read on

  • Newspeg for New Junkies
    With all the news you are barraged with daily, have you thought “there has to be a way to organization it”? Now you can with Newspeg....  Read more.
  • You Have To Laugh
    Funny Video - Dogs help owners shovel snow - view it here

February 13, 2014 - Volume 108

  • PowerPoint - Adding Footnotes
    There are multiple ways to add footnotes in your PowerPoint slides depending on what you need...  Read on

  • LinkedIn - Updating Your Profile
    Is your LinkedIn profile up-to-date? Did you know that they have added a few more things to the profiles – such as adding a link or a file?...  Read more.
  • You Have To Laugh
    Funny Video - Toddler Rocks a Skateboard - view it here

February 6, 2014 - Volume 107

  • Word - Addressing Envelopes
    Want a quick way to create an envelope or need to print many for a mass mailing? Printing an individual or a group of envelopes is easy to do using Word...  Read on

  • Driving Traffic to Your Site with Facebook
    Do you use Facebook to drive people to your web site? If you aren’t then you need to keep reading to find out how using 5 simple steps...  Read more.
  • You Have To Laugh
    Funny Video - Best Nanny Dog Ever? - view it here

January 30, 2014 - Volume 106

  • Excel - Fitting Text into Cells
    While Excel is great for calculating numbers it’s also great for using text to create lists, forms, reports and other documents. But sometimes getting your text to fit correctly can be problematic. Read on

  • Check Your Web Analytics
    If you have a web site and aren’t checking your web analytics at least once a month you are doing your business a huge disservice and are missing a lot of valuable marketing information.... Read more.
  • You Have To Laugh
    Funny Video - A bear follows you to the car? - view it here

January 23, 2014 - Volume 105

  • Using the Print Screen Button
    There is a magic button on your keyboard that can help you do many things. It’s called the Print Screen Button (Mac users don’t fear, you have these options too just but not the button). Read on

  • Promoting a Local Event Online
    Do you have an upcoming event that you need to promote or get volunteers or participants to? Then why not use the web to promote your events.... Read more.
  • You Have To Laugh
    Funny Video - Dog says no to time in the kennel - view it here

January 16, 2014 - Volume 104

  • PowerPoint - File Types
    An explanation of the variety of PowerPoint. Each format serves a different purpose. Read on

  • So, You Want to Start an On-line Store?
    You have probably seen the ads telling you how easy it is to create an on-line store (also called shopping cart) for your business. But did you know that it’s not as simple as.... Read more.
  • You Have To Laugh
    Funny Video - Dog nabbing chicken nuggest - view it here

January 9, 2014 - Volume 103

  • Word - Using Tabs
    Tabs are an important part of Word and it can be cumbersome to create a document if you don’t have them set right. Read on to learn how simple and easy it is to work with tabs.

  • How People View Web Sites
    When creating a web site there are many things to think about. One of the most important is to consider how people view sites – from where their eyes go first to how long the first impression takes to using text vs pictures.... Read more.
  • You Have To Laugh
    Funny Video - Dog and snowblower - view it here

December 19,  2013 - Volume 102

Holiday Funnies!

  • How To Wrap a Cat For Christmas - This is a very patient cat!
  • Girl Signs Carols for Deaf Parents - Watch this girls eyes and attitude - priceless!
  • West Jet Christmas Surprise - You will have wished you were on this flight!
  • See them all here!.

December 12,  2013 - Volume 102

  • Excel - Recent Document Options
    When opening up an Excel file you will see a list of recent files. Did you know that you can change the number of recent documents that are listed or “pin” a file to remain on the list?   … Read more.

  • Using Graphics Safely in Emails
    You get these emails many times daily - ones that contain graphics or a background to make the message stronger and now you want to create one. Did you know that there are various ways to add graphics to an email  ... Read on.
  • You Have To Laugh
    Kangaroo Boxes Toy Hippo...  Click here

December 5,  2013 - Volume 101

  • PowerPoint - Find/Replace
    Inevitably, when working on a presentation, many things change throughout the development process. How do you react quickly and efficiently to these changes? Use Find/Replace to identify  … Read more.

  • Linkedin Premium - Is It Worth It?
    Have you wondered if upgrading to the premium version of LinkedIn is worth it? I wondered myself, so I took them up on a free month trial offer. Here is my experience ... Read on.
  • You Have To Laugh
    Funny Cat Videos...  Click here



Unsubscribe from Amy’s Biz Tips e-newsletter.

  Home   Web Design   Social Media   Print Media   Consulting   About AAPK

Contact us - 203-305-3124 or at

AAPK - 45 Shadyside Lane, Milford, CT 06460

AAPK © 2015