512.892.8990 info@121-business.com
Killer Keyboard Shortcuts in Excel

Killer Keyboard Shortcuts in Excel

From “Killer Keyboard Shortcuts in Excel” by Doug Thomas and Microsoft Business Hub

Microsoft Excel includes many features to help your small business be more effective and productive—by keeping key details and data within a few keyboard strokes. This episode gives you quick tips and tricks to help maximize your time—and your business. Learn how to swiftly navigate spreadsheets using shortcuts that allow you to manage, organize, and analyze important data. Take advantage of these guidelines today—helping you to more efficiently run your business. Here’s an outline of shortcuts to get started:

  • Ctrl + Y is a repeat of previous action—just repeats the last step you made.
  • Ctrl + arrow keys are used for navigation—allowing you to move around the spreadsheet, effortlessly.
  • Ctrl + G is “go to”—you can go to any random cell based upon desired specifications.

More from “Killer Keyboard Shortcuts in Excel” by Doug Thomas and Microsoft Business Hub

 

Suzy Payne Rabb
Sage 50 Solution Provider
Your Live, Online Guide to Sage 50 Success
512.892.8990
 
Send email to suzy@121-business.com
Website: www.121-business.com
Join my professional network at Linkedin and follow me on Twitter.
Performance Management Scorecards Straight from Sage 50 (Peachtree)

Performance Management Scorecards Straight from Sage 50 (Peachtree)

By Suzy Payne Rabb
 
Performance Management Scorecards

Sage 50 Scorecard, Sage 50 Dashboard, Business Intelligence

 

Stay on track with the key performance indicators that can mean more success for your business. We create custom scorecards to inform, motivate, challenge and incentivize managers to build more profit into your bottom line.

-Use the Metrics that Drive Your Particular Business
-Can Work with Your Existing Sage 50 Chart of Accounts
-Works with Versions 2012 and Beyond
-No More Excel Editing, Copying, Pasting to Get What You Need

Contact us for more information.

This scorecard produced directly from Sage 50 via Sage Intelligence reporting tool. Entire scorecard below.

Suzy Payne Rabb
Sage 50 Solution Provider
Your Live, Online Guide to Sage 50 Success
512.892.8990
 
Send email to suzy@121-business.com
Website: www.121-business.com
Join my professional network at Linkedin and follow me on Twitter.

 

 

 

The 2 Second Chance

The 2 Second Chance

From “Make a Great First Impression: 7 Smart Tricks” by Geoffrey James and Inc.

Research shows that customers decide whether or not they want to work with you within two seconds of meeting you face to face.

That puts the burden on you to make certain that those two seconds really count. The only way to do that is to prepare ahead of time.

These tricks may help.

 1. Keep Yourself Fit

Your energy level is dependent upon your overall level of health. If you tire easily, rest assured you’re likely to look tired–especially under the stress of an initial meeting. And if you look tired, other people will make the snap decision that you’re too tired to get the job done.

This does not mean that you need to be a bodybuilder or Hollywood thin. But you must be healthy enough to look alert, capable, and interested.

 2. Research the Culture

Different industries have different norms about what’s appropriate in terms of personal appearance and meeting behavior. For example, wearing an Armani suit to a meeting with a programmer is simply inviting silent ridicule. Similarly, different regions of the country (or the world, for that matter) have different norms. Women who wear even slightly sexy outfits can send the wrong message to managers from the Middle East, for instance. Find out what’s expected before you meet.

3. Send Clear Signals

Your semiotics are the signals that your appearance immediately communicates to other people. People make snap judgments based on clothes, accessories, and more: watches, jewelry, briefcases, makeup, skin tone, facial expression, and so forth.

As far as is practical, make sure you are consciously creating a set of visual signals that is most likely to communicate that you’re the kind of person that’s appropriate to do business with.

More from “Make a Great First Impression: 7 Smart Tricks” by Geoffrey James and Inc.

Suzy Payne Rabb
Sage 50 Peachtree Certified Consultant
Sage 50 Solution Provider
Your Live, Online Guide to Sage Peachtree Success
512.892.8990
 
Send email to suzy@121-business.com
Website: www.121-business.com
Join my professional network at Linkedin and follow me on Twitter
Do More with an Automated Accounting System

Do More with an Automated Accounting System

From “Harness the Power to Do More with Less with an Automated Accounting System”  from Sage.

How automated systems can help.

There are hundreds of transactions that occur in every business day. Without help, you can quickly lose control. You have to manage your finances, but you can’t ignore your customers, your suppliers, or your team. Rather than running yourself ragged, you can rely on an automated system to help you create order from chaos. Here are some ways the right automated system can help:

  • Eliminate duplication
  • Validate transactions
  • Enforce rules
  • Monitor results
  • Identify and correct discrepancies
  • Project future outcomes
  • Be accountable

 

Eliminate duplicate efforts

Manual systems require you to re-enter the same data mulitple times. In an automated system, you can enter data once and then re-use it. You can also set up repeating transactions to handle a number of different scenarios. Because data is reused and centralized, you reduce the likelihood of errors.

Recurring Transactions

Your accountant tells you to record the same adjustment every month. With an automated accounting system, you can create recurring journal entries so that once a month, the journal entry will be recorded in you general ledger, making your finnacial statements accurate on a monthly basis.

More from “Harness the Power to Do More with Less with an Automated Accounting System” by Sage.

 

Suzy Payne Rabb
Sage 50 Peachtree Certified Consultant
Sage 50 Solution Provider
Your Live, Online Guide to Sage Peachtree Success
512.892.8990
 
Send email to suzy@121-business.com
Website: www.121-business.com
Join my professional network at Linkedin and follow me on Twitter.
12 Customer Dos & Don’ts

12 Customer Dos & Don’ts

From “12 Customer Do’s and Dont’s” by Geoffrey James and Inc.com

It’s easier to sell to existing customers than to acquire new ones, so it’s good sense to keep the customers you’ve already got.

Here are some simple rules to ensure that customers continue to come back for more.

DO put connection before content. Clients don’t want you to sell to them; they want you to genuinely care about them. Take the time to build a personal connection before you start talking business.

DON’T badmouth the competition. Only people who are insecure try to build themselves up at the expense of others. Show your competitors the same respect you’d want if the positions were reversed.

DO focus on individuals, not companies. You may be selling to an organization, but you’re doing it through an individual. Remember: ABC Inc. is not going to buy your offering; but Joe might.

DON’T give a sales pitch. Pitches are a great way to shut people down and pigeonhole you as a hustler. Even when speaking to a group, make the interchange a conversation, not a lecture.

DO engage with customers as equals. The client conversation should contain a feeling of mutuality rather than talking down to or being subservient to your clients.

DON’T attempt an “end run.” Bypassing a client or customer contact who is ambivalent or hostile will create an enemy for life. That person will constantly work against you … from the inside. You don’t want that.

DO keep the conversation mutual. Your goal is to earn your client’s trust by connecting with them, thereby creating a sense of safety. You can’t do that if you’re yakking away.

More from “12 Customer Do’s and Dont’s” by Geoffrey James and Inc.com

Suzy Payne Rabb
Sage Peachtree Certified Consultant
Sage Solution Provider
Your Live, Online Guide to Sage Peachtree Success
512.892.8990
 
Send email to suzy@121-business.com
Website: www.121-business.com
Join my professional network at Linkedin and follow me on Twitter.
 
7 Unique Ways to Get Massive Exposure From Your Articles

7 Unique Ways to Get Massive Exposure From Your Articles

From “7 Unique Ways to Get Massive Exposure From Your Articles” by Jessica Swanson and Manta.com

I’m sure that, as a small business owner, you understand the value of writing articles that educate and inspire your potential clients and customers. So, you write an article and submit it to a few of the top article directories. Your article gets a few views and perhaps even a click or two back to your website. And, this is where reality sets in. You’ve just spent an hour or two writing an article with only one or two visitors to show for your efforts. It’s pretty safe to assume that you are not enjoying the process of writing articles.

But, don’t give up too quickly. If you’re going to take the time to write an article, you just need to make sure that it works overtime for you.

You want your articles generating massive exposure with the potential of bringing in hundreds of new visitors to your website.

Here are 7 unique ways for creating extra exposure from your articles:

1. Offer to write guest blog posts.
There are thousands of blogs actively looking for guest blog posts. You can either start by researching blogs in your industry through a blog directory such as Technorati or, you can join a service such as Blogger Linkup that connects blogs and guest bloggers.

2. Submit guest articles to ezines.
Start by searching for ezines that cater directly to your target market. Subscribe to them and find out which of them accept guest articles. Contact the ezine publishers with a sample article that they can use in upcoming issues.

3. Research niche article directories.
You’re probably familiar with the big article directories. However, most small business owners can find niche article directories that are specific to their target market. To find appropriate article directories within your industry perform a Google search using “your target market” + “article directory.”

4. Offer to write for associations.
There are hundreds of associations that are eager for content to offer to their members. Search for these associations through Google by typing in “your target market” + “association.”

5. Submit to document sharing sites.
Turn your article into a .pdf document and upload it to document sharing sites such as Scribd

6. Upload to ebook directories.
Take a few of your related articles and turn them into a 10-12 page eBook. Upload your eBook to e-book directories like Free-ebooks

7. Rebrand your eBook.
Rebranding your eBook is a way to help it go viral. This means that you let your readers change the affiliate-links to their own, giving them incentive to distribute your eBooks to their own network. You can use a software program such as ViralPDF

So, the next time that you write an article, make sure that it brings you massive exposure and hundreds of leads to your small business.

More from “7 Unique Ways to Get Massive Exposure From Your Articles” by Jessica Swanson and Manta.com

Suzy Payne Rabb
Sage Peachtree Certified Consultant
Sage Solution Provider
Your Live, Online Guide to Sage Peachtree Success
512.892.8990
 
Send email to suzy@121-business.com
Website: www.121-business.com
Join my professional network at Linkedin and follow me on Twitter.