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.
Tracking Sales Orders with Sage 50 Quantum

Tracking Sales Orders with Sage 50 Quantum


by Suzy Payne Rabb
121 Business Software Consulting

 

Where’s the Order?

What if everyone on your team could have real time access to the latest status and up-to-the minute notes on your company’s open sales orders?  Imagine how much more smoothly your operation could work. No one would have to wonder, ask or spend time tracking down what’s happened or what needs to happen next. With just a couple key strokes, a user could see a birdseye view of the total sales order process or drill down to immediately answer questions about the most detailed aspects of a specific order.

With minimal setup, your Sage 50 Quantum system can be setup to provide a dashboard with the following views.

And you can arrange these views on your own dashboard in a number of meaningful ways.

So, how is it done? Sage 50 Quantum Order Process Workflow is the key. Order Process Workflow is built into the Sage 50 Quantum system. You just need to set it up and start using it.

 
 
 
 
 
Update:  New Sage 50 Business Intelligence Report, Sales Orders by Status w/Trackit Note, is now available.  Click here for report details.
 
 
 
 

 

 

 

 

Sage 50 Order Process Workflow

The Order Process Workflow system in Sage 50 (Peachtree) Quantum Accounting keeps everyone informed in real time of all the details related to your sales orders, so that anyone with approved access can instantly know where the order is, when it’s due, who’s handling it, or what the problem with it is. You can customize the triggers, steps and statuses that are crucial to your particular company.

  • Keep track of all the moving parts of your order process so nothing gets missed and everything moves along as planned.
  • Notify the next person in the process with a status and specific notes as needed.
  • Have one centralized place to keep track of all the work involved in the process, or see just your own tasks.
  • Automatically send notifications to designated employees once a task is completed.
  • My Inbox on My Dashboard monitors the status of a user’s processes and transactions, and allows them to take action.

Interested in learning more?  Contact a Sage 50 Certified Consultant or email me at suzy@121-business.com to setup a free consultation.  I’ll share the steps to get this functionality setup and working for your company.

Suzy Payne Rabb
Sage 50 Peachtree Certified Consultant
Sage 50 Solution Provider
Your Live, Online Guide to Sage 50 Success
512.892.8990

 

See Professional Profile

 
Send email to suzy@121-business.com
Website: www.121-business.com
Join my professional network at Linkedin and follow me on Twitter.
 
Sage 50 Quantum, Sage 50 Consultant, Sage 50 Help, Sage 50 Training, Order Entry, Order Processing, Sales Orders, Open Orders, Peachtree Quantum, Peachtree Consultant, Peachtree Help, Peachtree Training
Gross Profit by Invoice

Gross Profit by Invoice

By Suzy Payne Rabb

 
Do You Know Your Gross Profit by Invoice?

 

Click here for the printable PDF of the entire report.

 **Note:  This new stock Sage 50 Business Intelligence report works for both stock and assembly items.
 

If you use Sage 50 (Peachtree) for inventory and manufacturing, the data is definitely there.  Here is a solution to present this information in a more concise and meaningful way than can be done from Sage 50 alone.

Introducing our new Sage 50 Business Intelligence Report, Gross Profit by Invoice, Item Report.  Finally, concise, to-the-point, easy-to-read reporting of your gross profit per invoice.  This functionality can now be easily added to your own Sage 50 system as early as today.  It’s just one example of the type of reporting now available with Sage 50 Business Intelligence.

Stay tuned for announcements of additional reports to be added to our Sage 50 Business Intelligence Stock Library.  Also, would love to know what others are doing today with Business Intelligence.

Interested in this report?  Email me today for the details of how to add this report to your own Sage 50 system.

Suzy Payne Rabb
Sage 50 Peachtree Certified Consultant
Sage 50 Solution Provider
Your Live, Online Guide to Sage 50 Success
512.892.8990
 

See Professional Profile

 
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.
New Era for Sage 50 (Peachtree) Reporting

New Era for Sage 50 (Peachtree) Reporting


By:  Suzy Payne Rabb
121 Business Software Consulting

 
Dashboards and Scorecards 

So you think you know Sage 50 (Peachtree) and the type of reporting that is possible? Think again. A new era has dawned for Sage 50 reporting and the possibilities are only limited by your imagination.

What if you could pull out the most key performance indicators and present them in such a way to inform, challenge, motivate and incentivize your own team? Now you can.

Example:  Restaurants-A few sections from a Restaurant Scorecard (created by 121 Business Software Consulting with Sage 50 Business Intelligence)
 
New Reporting Possibilities Direct from Your Own Sage 50

You can keep the typical reports and financial statements generated by most typical accounting programs–they are important and definitely have a place in the management of your business. But take a moment to think “outside the box”, to the key performance indicators that drive success for your own business.  Yes, you can likely find them buried in your typical accounting reports, if you take the time to analyze and digest the details.  But what if you could pull out the most key performance indicators and present them in such a way to inform, challenge, motivate and incentivize your own team?  Now you can.

In the coming days and weeks, we will be presenting more real world examples of what is possible today with your own Sage 50 (Peachtree).  Stay tuned, we think you will like what you see.

So yes, it is true. This type of reporting is now possible to generate directly from your own Sage 50 Peachtree with no additional Excel work.  Email me today to discuss what might be possible for your business.

Suzy Payne Rabb
Sage 50 (Peachtree) Certified Consultant
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.