Annoucement - New Services

Hello All:

Over the last several months, PC Applications has been going through some changes in attempt to keep up with technology (of course this has been the case since ever since PC Applications has been around, almost 20 years now).  That not only involves keeping up with the software for which I provide training and consulting services such as Windows and MS Office, but keeping up with ways of doing business.  Thus some significant changes including a FREE webinar in April...See below:

Check out our revised website:
 www.pcapplications.com

 

PC Applications now offers remote access as well as onsite services.

We Can Help YOU with YOUR Computer, Windows, or MS Office.

PC Applications has been in business since 1995 offering quality computer training and consulting services using Windows and all of the MS Office applications and we want to continue to do so.

If you need help with Windows or any of the MS Office applications, PC Applications can help via remote access. PC Applications uses a Free, Safe download (JoinMe) to show and explain to you on your computer, how to get it done.  Otherwise, PC Applications will still gladly come to your location.  PC Applications has restructured its consulting pricing to be very economical.

Additionally, for almost 20 years PC Applications has offered “traditional” instructor led training in a class room setting.  Times have changed…

Although the “traditional” training class can be arranged on request, PC Applications will be offering short course (1 to 1 ½ hour) webinars via Go To Meeting.  The webinars will be either FREE or there will be a nominal fee to join.  Meetings will be limited to 25 attendees.  A video recording of the webinar will be available.

To introduce our short course webinar, PC Applications will conduct for FREE a webinar in April.  The subject matter will be chosen from information submitted using the CLASS TOPIC SURVEY.  If you are interested in having your topic covered in this FREE webinar, please submit the form by March 31, 2014.  There will be an announcement in early April regarding the FREE webinar topic.

How valuable is your time?  How soon do you want to get it done?

Contact PC Applications to find out how we can help you use your computer, Windows, and MS Office.

Phone: 970-488-0948
Email:  joel@pcapplications.com
www.pcapplications.com

Excel 2010 Training Course

Lifetime Access to Online Training Video By Joel Levy, PC Applications:

“Excel Level 1 – From Zero to Hero”

Dear Friends and Business Associates:

As you may know, I have been providing computer training and consulting services for 20 years, and a big part of my business has been instructor led, hands on training for the MS Office applications, particularly MS Excel.

Recently, I have produced an online Excel 2010 training video course containing over 4 hours of video instruction in 17 Lectures on learning how to use and work with MS Excel.  The course, “Excel Level 1 – From Zero to Hero” covers all the information (and more) that I cover in my full day (7 hours) hands on instructor led class that I teach in my business.

In an attempt to get feedback and exposure for the course, I am offering the course for FREE to the first 100 who sign up and another 100 registrations at a 50% discount (final cost $49),

Please feel free to forward this information to any friends or business associates who might be interested in really learning Excel and who would want to take advantage of this offer.

Registering for the course allows lifetime access to the course, materials, and updates.

My course is being hosted at Udemy.com, an online learning resource.  There are some free lectures so check it out; to view the free lectures, click the following link: 
https://www.udemy.com/joel-levy-excel-2010-level-1

To register for my course for FREE, click the following link:

https://www.udemy.com/joel-levy-excel-2010-level-1/?couponCode=ExcelFreeFromJoel

and click “Take This Course  Free”…it’s FREE for the first 100 people…

 

You can also sign up for the course at a 50% discount, click the following link:

https://www.udemy.com/joel-levy-excel-2010-level-1/?couponCode=Excel50%25Off

and click “Take This Course $49”…100 available.

Thanks for your consideration and hope all is well!
 

Have fun in the meantime until next time,  Joel

 

Figure on Using Figures (Captions) in Word Documents

Happy New Year!

I will start off the New Year with a Blog Post; it was on my list of New Year's Resolutions!

Recently I did some Access consulting and training for the Grand County, CO Sheriff's Office.  After the training I was asked to put together a User Manual (Word Document) to document what I had covered in a hands on training class.

I was specifically asked to 'include screen shots', ie figures (pictures) of the computer screen (or parts thereof) to visually show what someone would be looking at while working with, in this case, an Access database using Access.

I realized that there could be many "screen shots" (30 or more) and wanted to make my life easy in being able to manage these screen shots while creating the document.  Here was my chance to use "Insert Caption" in Word and use Figures.  As I figured (no pun intended) this could also be good subject matter to blog and resolve my Resolution...

First of all, how did I get my "screen shots"?  I used One Note which is a nice Microsoft Application (comes with certain Office Suites) that allows copying parts or all of a screen view and then being able to manage these "clips".  A "clip" from One Note can be copied and pasted into Word (or any other place with a paste command).  Of course the other option to capture a "screen shot" is simply to click the "Print Screen" button on your keyboard.  This copies the screen (the entire screen) to the clipboard.  The Print Screen image can then be pasted into Word (or any other place with a paste command).  Other than a "screen shot" one could use a picture (Insert, Picture).

So I begin creating my Word Document...type, type, type....then it I think, "hey, what a great place for a screen shot".  So I switch windows to the window that I want in a screen shot and either "Print Screen" or use One Note to capture a clip and copy.  I switch back to Word and Paste and end up with a copy of the screen shot or clip (picture).  Of course there are a lot of formatting options (like resize, wrapping options, crop, etc that could be pursued (which I won't go into in this discussion).

Once the screen shot (picture) is pasted into the document it could be setup as a Figure.  With the
picture selected, on the References Tab, Captions Command Group, click Insert Caption.  In the Captions dialog box you now have several options about the Caption.  First of all select the Label (Table, Figure, Picture, Equation) option, in this case I used "Figure".  Notice a Caption is automatically produced with the number being based on its order in the document, ie the first Figure will say "Figure 1" (or Table 1, etc).  Add any information to the caption such as "Screen shot of Access".  Choose Position (above or below pic) and click OK (yes, a few other options I didn't go into). 

You can now reference the Figure in the document.  To do such, click where you want a reference (such as "See Figure 1").  Type "See"  and then click Cross Reference in the Captions Command Group.  Choose the Reference Type (Figure) (a list of Figures will be in the bottom of the window as choices), choose the appropriate Figure to reference.  You can choose an Insert Reference To: option such as "Only Label and Number".  Click Insert and a reference will be generated like "See Figure 1", the "Figure 1" being a Field Code.  By default the reference is also a hyperlink, just Ctrl+Click the reference and you go to the Figure.

The Figure values will automatically be updated when adding a new Figure to the document.  If a Figure is added before Figure 1, the new Figure will be 1 and all others will be updated.  References in the document like "See Figure 1"can be updated by right clicking the Field Code (as mentioned above) and choose update.

So if you figure on figuring to use Figures (or Tables, Pictures, Equations), the Word feature "Insert Caption" could be quite handy.

Have fun in the meantime until next time,  Joel