One-on-One
Learning Centre
Weekly Newsletter

In This Issue:
Sat 12 July 2008     

In This Issue:

  1. A Note From Chris
  2. How to Draw a Graph
    in MS Excel
     
  3. How Systems are Game
    Changers

     
  4. How to Use Music in your
    Shop to Increase Sales
     
  5. Brisbane First Aid Training
     

Video Testimonials

     To find out what clients are saying about our training check out our  video testimonials

                     
Click Here

The Law Of Success -

  You simply run out of
  things to fail at!


                 Chris Le Roy

Townsville Business Training, Training in Business, Sales Training, Townsville Sales TrainingBusiness
- Course Outlines
-
Schedule
Computer

-
Course Outlines
-
Schedule
First Aid

 - Course Outlines
 - Schedule


 - Townsville First Aid Schedule
 - Brisbane First Aid Schedule

 

Follow Us On -

Every day we write new tips
& hints on our Facebook &
Twitter accounts. Join us
today for the latest help.




Follow NQTraining on Twitter


A Note From Chris: Changes to Our Course Schedule and our new MYOB and Quickbooks Courses

Computer Article: How to Draw A Graph In MS Excel

Business Article: How To Use Music in your Shop to Increase Sales

A New Service: Brisbane First Aid Training
 

Please add bulk@leroys.org to your whitelist or address book in your e-mail program so you have no trouble receiving future issues!

A Note From Chris

Hi,
  
    In business, to be truly successful you need to listen to your customers and over the last few months we have been doing just that. We are now making some important changes to some of our courses. 

   Over the last few years, we have always run Quickbooks and MYOB Courses as two-day courses and on the weekends.  As more and more people are working in small business we are now finding employers want to train people just in day-to-day accounting operations rather than everything.

   Because of this I have now made some major changes to course programs.  From the 11 September 2010 we will no longer be offering our Quickbooks or MYOB Courses on the weekend (our schedules will be adjusted over the next few weeks to reflect this). All courses will be run during the week except for First Aid which will continue to run on Saturdays.   We have now broken the MYOB and Quickbooks courses up in this way:

    MYOB Day-to-Day Operations 1-Day   - $295.00
    MYOB Starting a New Company 1-Day - $295.00
    MYOB Payroll 1-Day Course               - $295.00

   Quickbooks Day-to-Day 1-Day            - $295.00
   Quickbooks Starting a New Company    - $295.00
   Quickbooks Payroll 1-Day Course         - $295.00

   These courses will be available in both Brisbane at our Tanah Merah Office and in Townsville.  We are also limiting the number of people in these courses to just 5.  You can access the course outlines on our website or we can email a copy to you just call us on 1800 66 00 00.

   We have the following upcoming dates for these courses:

     Brisbane (Tanah Merah Office)

        Quickbooks Day-to-Day 1-Day   Tue 14 September 2010
        MYOB Day-to-Day 1-Day          Thu 16 September 2010

     Townsville (Limited to 5 places - First In First Served)

        MYOB Day-to-Day 1-Day          Wed 13 October 2010
        MYOB Payroll 1-Day                 Wed 27 October 2010
        Quickbooks Day-to-Day            Thu  28 October 2010
        Quickbooks Starting a Business   Fri   29 October 2010
        Quickbooks Payroll                   Wed 20 October 2010

   To book into any of these courses you can book online or you can call our office on 1800 66 00 00.

    Well once again, have a great week and remember one thing Success is a Habit.

Chris Le Roy
Managing Director
One-on-One Learning Centre
 

How Systems Are Game Changers!
 Excel Tips - How to Draw a Graph in MS Excel

By David Millard

Microsoft Excel is one of the leading spreadsheet programs, and is used by a variety of organizations all over the world.  It's strength lies in it's ability to process numbers on a large scale, making it extremely suitable for many industry sectors including banking, business, finance, statistics, sales and anywhere where large quantities of data need to be analysed.

The old expression "a picture speaks a thousand words" is very true when it comes to visualizing numerical data.  Human beings can find it difficult to assimilate numbers presented as a table, whereas most of us find it a great deal easier to understand numerical data when it is presented as a chart or graph.  Microsoft Excel takes full advantage of this with its wide range of charts -- and the great news is, they are a snap to create!

Excel ships with a wide variety of graph types installed, each suited to a particular purpose.  To see values changing over a period of time a column or line chart is probably best; to see the distribution within a population, e.g. market share, or sales by department, a pie chart is probably more suited.  There is a range of chart types dedicated to statistical analysis, including stock, bubble, scatter and radar, but these are more specialized and are not covered here.

How to create an Excel Graph

  • Open up the spreadsheet that contains the data you want use to build a graph from
  • Make sure you are on the worksheet that contains the data
  • Highlight the data that will be used to create the chart by dragging over it with your mouse  
  • Tip: it is better not to include totals for the data as it will skew the results
  • Include the labels for both the columns and rows, and the data in between. 
  • In pre-2007 versions, go to the Insert menu and choose Chart
  • In post-2007 versions, go to the Insert tab and click on the appropriate chart type from the Chart group
  • Or in any version, use the keyboard shortcut - just press the F11 key! (my favourite!)

Excel will create a new graph based on the data you selected.  If you used the keyboard shortcut it will place the graph on its own page named "Chart1". 

It is easy to move or edit the chart by first selecting it, the choosing Chart Type or Chart Options and working through the wizard. 
 

About the author
David Millard is a Microsoft Certified Trainer based in the UK. He holds a degree in Education and is a college tutor in the south of England. He is also a web developer and publisher, and the proprietor of Visio Tutorial http://www.visio-tutorial.com

 

 

How To Use Music in your Shop
To Increase Sales

By Chris Le Roy

Many retailers in the western world, only rely on one key human sense when dealing with their customers and that is the sense of sight. How often do you go into a store and find a store to be visually attractive, yet your other four senses are either not stimulated or left disappointed.

One of the things retailers must remember is that every customer has five senses, sight, touch, taste, smell and hearing. Simply focusing on making a store visually attractive can in fact limit your selling capability and your turn over. One of the senses that can be stimulated to increase sales is the sense of sound.

Research throughout Europe and the United States has learned that certain types of music can influence a persons spending habits. For example, it has been shown in the past that if you play classical music in a wine cellar store you will find that your customers are more likely to purchase a higher priced wine product. Knowing this information can in fact help increase sales.

If you are playing music in your store at this immediate moment in time, watch the beat of the music. Focus groups found that if you play high beat music in a store then your customers are more likely to move around your store quickly and then leave, purchasing less. Where as when a slower beat music is played they are more likely to spend more time in your store and buy more.

This is a great exercise to try out in your store. The best time to try this is during a peak buying period when you have the maximum number of customers in your store. I recommend that you try this technique over a few different days so that if the impact is dramatic you don't severely affect your sales.

On the first day, make this your control day. Simply trade the day as you normally would. Make sure that you count the number of people who enter your stored during the day. At the end of the day, simply see what your total sales were.

On day two, play a fast beat music. Once again, count the number of people who came in your store during the day and then add up the total sales. On day three, play a slow beat music and follow the previous process.

For most stores, you will find that your sales will increase when you use the slow beat music. A few things to remember though, one, always ensure that the music is relevant for your market. For example if you were a surf store and your market was in the 14 to 25 bracket and you played Bach for your slow music, you will at a guess, have a bad sales day. You would be better off playing some slow beat music that is relevant to that age bracket.

The key to using music is to test and measure. Try out different types of music and then test to see whether your sales go up or down during the day. Once you have identified music that helps you increase sales, you can then identify another sense to further increase your daily sales.

If you are looking for more great ideas to help you in your business, sign up for our daily newsletter or become a fan of our Fan Page at - Small Business Advice.

 
Brisbane First Aid Training

Are you tired of not being able to get regular First Aid Training Courses in Brisbane?

We will be operating our courses exactly the same as they are in Townsville.*

All Brisbane Courses will be held at our Loganholme Training Centre.
              Address: 2 Grevillea Street
                          Tanah Merah Q 4000
                          Across Freeway from the
                          Logan Hyperdome.

More locations will be added shortly in Cleveland and on the North Side. We can also operate onsite courses as well if you have 5 or more staff.

The cost of the course will be $150 for the Full First Aid and $55 for the CPR Course.

The One-on-One Team are now running 1-Day Apply First Aid Courses (formerly senior first aid) three times a week in Brisbane at our Loganholme Training Centre on:

         - Wednesday 07:45 am - 5:30 pm
         - Friday        07:45 am - 5:30pm
         - Saturday    07:45 am - 5:30pm

CPR Refresher Courses now available in Brisbane on:

         - Wednesday 07:45am - 11:00 am
         - Friday        07:45am - 11:00 am
         - Saturday    07:45am - 11:00 am

The One-on-One Team now run CPR Refresher courses with LVR every Tuesday.

            Start Time: 07:45 to 01:00 pm

Cost - $95.00

To Book for any of these courses or more information call
1800 66 00 00 or Click Here

* Please note Lunch is not available in Brisbane. Coffee, Tea and morning tea are provided
You're receiving this newsletter because you have purchased a product, attended an event or subscribed to one of the One-on-One Learning Centre newsletters through www.1-on-1.biz or www.1-on-1.biz. You can unsubscribe at any time by following the instructions at the bottom of the page.

We will never release, sell or give your name, email address to any unauthorized third party or organization. You will only receive email messages from us that contain requested information, new monthly articles, updated courses or announcements of new services.

Although we want to hear from you, PLEASE DO NOT REPLY to this email or send questions to this address. Simply direct your questions and correspondence to our website at http://www.1-on-1.biz and contact us from there.

One-on-One Learning Centre
Unit 6,286 Ross River Road or P.O. Box 2297
Aitkenvale Q 4814 Townsville Q 4810
Australia    Australia

Telephone: 1800 66 00 00 or 07 4728 5582
Fax: 07 4728 5905

If you no longer wish to receive communication from us, simply click on the link below and enter your email address:

 http://www.1-on-1.biz/remove/unsubscribe.asp