April 2011
Know It Sooner Computer Training

 

 

Spring is finally here!

Hi <<First Name>>,

This is such a exciting time of year! This is also our busiest season! Maybe everyone is trying to get in their training before summer vacations start.  We have some courses coming up that you may be interested in. Or maybe you'd rather have us come in and do some onsite training? Either way, give us a shout and we'll fix you up with the information you need to create those wonderul spreadsheets and documents you know you want to!

Upcoming Classes and Lunch and Learns

Take your choice of attending courses at Chrysalis (133 ave and St. Albert Trail) or Safety Ahead (#206-9131-39 Avenue). Register on our website today!

If you are wondering about "Member Pricing", this is the special rate that employees get when they host the computer class, such as the nice folks at Chrysalis are doing! If you are interested in setting this up for your office, give me a call!

Excel
Level 1

Safety Ahead

May 19 and 26
6:00-9:00 PM

$100 + GST (Regular Price)
$80 + GST (Member Price)

Our most popular course. You will learn from the beginning how to use this program, from creating formulas to controlling what prints You will love it!   I guarantee it!

Word
Level 1

Safety Ahead
April 27 and May 4
6:00 - 9:00 PM

$100 + GST

This is the course everybody should take! Learn how to line up text without using multiple tabs or spaces! Headers and footers, as well as bullets and numbers are covered. Many tips to be had.

Excel
Level 2

Chrysalis

April 19 and 21
5:00 - 8:00 PM

$100 + GST (Regular Price)
$80 + GST  (Member Price)

Do you work with more than one sheet within a workbook? Learn incredible ways of copying sheets and linking them together. Also covered is VLOOKUP and IF statements. If you don't know what these are, you'd better come and find out! Lots of other goodies are going to be revealed as well.

Word
Level 2

Chrysalis
May 5 and 12
5:00 - 8:00 PM
$100 + GST (Regular Price)
$80 + GST  (Member Price)

If you would like to learn shortcuts in Microsoft Word, this course is for you. Intermediate topics covered include Using Styles and Creating a Table of Contents, Autotext/Quick Parts and Autocorrect, and Multilevel Numbering. We also take a look at tables and toolbars and learn some tips that make them easier to work with. 

$100 + GST (Regular Price)
$80 + GST (Member Price)

Excel
Level 3

Safety Ahead

April 20
6:00 - 9:00 PM

$50 + GST (Regular Price)

If you work with big spreadsheets, you need to take this course! Learn how to use Pivot tables, filtering,  subtotals and more!  You won't believe what you can create with these tools! You will not be disappointed!

Excel Tips and Tricks (FREE!)

Safety Ahead
May 10
12:00 - 1:00 PM
Think you know Excel? There are dozens of tricks that you could be using to get your work done faster! This quick session is great for people who haven't taken formal training in Excel or it's been awhile and you could use a refresher. Prepare to be amazed!


Word Tips and Tricks (FREE!)

Safety Ahead
April 28 
12:00 - 1:00 PM
Learn all the things you forgot Word could do! Line things up properly (without hitting tab or spacebar a million times!), headers and footers, and other time saving tips!


Outlook Tips and Tricks (FREE!)

Safety Ahead
May 25
12:00 - 1:00 PM
So many people use Outlook. Most just use it for email! There are so many more things Outlook can do! Come and see how to use Contacts, Calendar and other great tips!


Administrative Professional's Day

This is the time of year to recognize the amazing efforts of Administrative people! Without them, we would be nowhere! There is a conference on April 20 at the Ramada on Kingsway that you may have heard about. It is put on by the Edmonton Chapter of the International Association of Administrative Professionals. Check out their website for information on heir organization and this conference and tradeshow at  http://www.iaapedmonton.com. I will have a booth at the trade show so please stop in and say hello! We are holding a draw for a $100 Gift Card to one of our new clients - European Institute of Esthetics & MediSpa along with some other goodies. I would love it if one of you won it - they have amazing services there!

Not from Edmonton? Find your local chapter here: www.iaap-hq.org.

Community Corner

We have recently had a chance to get to know some of the great folks at Chrysalis and have also been learning about what a fantastic organization they are. The programs and services they offer are so amazing, so we asked them to send us some information to share with all of you!

 Chrysalis: An Alberta Society for Citizens with Disabilities has been serving individuals with a variety of disabilities throughout Alberta for the past 43 years. Originally created by parents and community members who realized that adults with disabilities deserved equal opportunities to contribute to their communities, Chrysalis began as an agency especially planned for training adults with developmental disabilities to produce manufactured goods using automated machinery. Today, Chrysalis offers personalized services to help thousands of people with disabilities receive training, develop life and vocational skills, find employment, discover volunteer opportunities, and realize an improved quality of life.


The programs and services offered at Chrysalis are ever evolving as the needs of the individuals whom we serve change. The recent additions of both Art and Music Therapy have opened up a wide variety of new options for our clients to express themselves in a whole new way.
We invite you to visit Chrysalis and get a firsthand look at what we are all about. Visit www.chrysalis.ab.ca or phone 780.482.0348 for more information about our free, bi-weekly information sessions which will provide you with a detailed overview of our organization all within one-hour. 


Today's Tip

Changing the Case of your Text in Excel
I had a client who received a list and all the names where typed in upper case. It was really hard to look at! She thought she had to retype all the names but was glad when I told her there were functions that will do it for you! There are three "functions" that deal with changing the case of your text in Excel - UPPER, LOWER and PROPER. These functions will make your text all upper case, lower case or proper case (like how I've typed this title - Today's Tip).
  1. Go to the cell next to the one you want to change.
  2. Click on Insert Function (a button that has fx on it.)
  3. Find the function you want. If you click on the Text Category, you will see all your choices, including the ones listed above.
  4. Choose the function and click OK.
  5. Then it will ask which cell you want to "convert" to this new format. Pick the cell and you're done!






Joke Time!

A friend of mine recently retired and sent me her resume...

My resume

1.  My first job was working in an Orange Juice factory, but I got canned.  Couldn't concentrate!
 
2. Then I worked in the woods as a Lumberjack, but just couldn't hack it, so they gave me the axe.

3. After that, I tried being a Tailor, but wasn't suited for it -- mainly because it was a sew-sew job.

4. Next, I tried working in a Muffler Factory, but that was too exhausting.
 
5. Then, tried being a Chef--figured it would add a little spice to my life, but just didn't have the thyme.
   
6.  Next, I attempted being a Deli Worker, but any way I sliced it... couldn't cut the mustard.

7. My best job was a Musician, but eventually found I wasn't noteworthy.
 
8. I studied a long time to become a Doctor, but didn't have any patience.
  
9. Next, was a job in a Shoe Factory. Tried hard but just didn't fit in.

10. I became a Professional Fisherman, but discovered I couldn't live on my net income.
 
11. Managed to get a good job working for a Pool Maintenance Company, but the work was just too draining.
 
12. So then I got a job in a Workout Center, but they said I wasn't fit for the job.
 
13. After many years of trying to find  steady work, I finally got a job as a Historian - until I realized there was no future in it.

14. My last job was working in Starbucks, but had to quit because it was the same old grind.

 15. SO, I TRIED retirement AND  FOUND I'M PERFECT FOR THE JOB!


Till next time, happy computing!

Joanne Swensrude
jswensrude@shaw.ca
780-940-6772
www.knowitsooner.com
Copyright © 2011 Know It Sooner Computer Training, All rights reserved.
Email Marketing Powered by Mailchimp