There is a new
FREE Lesson of the Week
on Microsoft Access. This one teaches you about Action Queries
and how you can use them to manipulate data in your tables.
I just finished recording
Microsoft Access 222.
This course deals with Action Queries which allow you to manipulate the
data in your table on a large scale (update, delete, append, and
I did go a
little overboard on this class. Instead of the standard hour-long
course, this baby is over two hours long. There were just so many
examples I wanted to include in this one... so I hope you enjoy it!
I've got it listed on the site for a
discounted price of just $19.99 which is $5.00 off the retail
price of $24.99. The price goes up on April 1st, so make sure you order
it now to take advantage of the discount.
Microsoft Excel 223
Handbook is now online for download.
We've added a Handbook for our
Visual Basic 101 class. If
you've previously purchased VB101 and wish to add the handbook to
your collection for only $1.99, you can do so now on the
Handbooks Order Page. The handbooks are
great to follow along with while you watch a course, to use for a quick
review to brush up on the material after the class, or to look back on
as a reference guide.
haven't yet ordered VB101 and wish to learn how to program
in Visual Basic, you can order the course for only $5.99 now and
add the handbook on as an option. We have electronic (online) versions
as well as printed manuals available too.
I just got back from a few days out of the
office. From the emails I see here, there's a small problem with the
Access 221 download. I'll get that fixed shortly. I also see that the
"check your order status" part of the web site went down. That's back up
and running - but I won't be able to update order status info until
tomorrow (if you've placed your order in the last couple days, it won't
show up). Also, if you have a customer service inquiry in the system, it
should get answered in the next day or so. Thanks for being so patient!
Microsoft Access 221
is now available on the web site for purchase. We are offering it for a
discounted price of just $14.99 which is $9.00 off it's
regular price of $23.99 if you order before March 1st. This course is
over 110 minutes long, and is well worth the price of admission!
This course covers aggregate (summary) queries, and we learn how to make
totals (sums, averages, etc.) in the footers of forms and reports. Click
on the course name above for more information.
Oops. I went a little long while
Microsoft Access 221. I try to plan each course so it's about an
hour long. This one is over 100 minutes long! I didn't realize that I
had run way over while I was recording it... so if you've been learning
Access with me, you're in for a treat. There's a lot of material covered
in this one, including information on Aggregate (Summary) Queries,
putting totals in form and report footers, creating employee time
sheets (lots of people bugging me for that one!)
The videos are recorded. They'll be going
members shortly. Everyone else will be able to order the full class
Microsoft Excel 222
Microsoft Access 220
to the Free Credits Page. This means if you
have free course credits on your account, you can use the links on that
page to redeem your credits.
Microsoft Excel 222
Handbook is now online for download.
I just finished recording the new
Microsoft Access 220 class. This class deals
with advanced query techniques. It's available for download by
members, and is available for purchase
now at a discounted price of just $12.99
(until Feb 4th, when it goes up to it's regular price of
Wow! With the holidays as busy as
they were around here, I didn't realize it has been more than a month
since I updated this page. First, let me wish everyone a Happy New
Year. I hope everyone had a great holiday season. We were very busy
around here - so if anyone sent me an email and hasn't gotten a reply
yet - hang in there, it's coming. I've got over 200 emails to
What's coming up this
month? I'm in the middle of finishing up a whole bunch of new
Microsoft Access courses. If you've been
following along with our Access series so far, you're going to love
these new courses. After that, look for new VB and ASP
courses. Lots more to follow. Questions?
The handbook for
Microsoft Excel 221 is
now online for download.
We want your feedback. Please take a
moment and let us know what YOU want to see us make for our next
new class. Fill out our short online poll.
Hey everyone... Happy Thanksgiving!
The holiday gift-giving season is
upon us once again. Just like last year, we're giving away
Gift CDs. Better yet, we're letting YOU give our free
gift CDs to your friends and family.
This year, send them something that will
help them use that computer that's been sitting in the corner
collecting dust - or that they just play games on. What better gift
could you send someone who might be getting a new computer for the
Best of all... our Gift CDs are great
for giving to folks around the office. You've been learning Word
and Excel with our videos. Great! Now, you're the go-to-guy or
gal in the office who everyone comes to with questions. Here's a great
gift idea for them... now they can learn Word and Excel on their own and
will leave you alone.
For more information on how you can send
a FREE CD
to your friends and family, just visit our
Gift CD Page.
We've updated the
FREE Lesson of the Week page. This
week's new lesson is on the powerful Excel feature PivotTables.
PivotTables allow you to analyze a mountain of data by creating summary
tables with just a few clicks. Check it out.
As promised, Excel 223 and 224
are online for any users who have purchased them (and
members) to download them. We're making the CDs right now, and orders
containing them will be shipping out tomorrow morning.
Finally, Excel 223 and 224 are
FINISHED. The videos are "in the can" and will be uploaded to the
web site later today for your downloading pleasure. All orders
containing these two courses will be shipped out tomorrow (Friday).
These were very intense courses to
record. Both are jam-packed with information (which is why they
took me so long to produce). They both deal with PivotTables, a
very powerful feature of Excel. If you want to learn how to get the most
out of your Excel data, you want to learn about PivotTables. There's a
LOT to learn (believe me!) but it's well worth it.
We have a new feature here at
FREE Lesson of the Week page. While
we have had some sample demo lessons online for years now, this page
will feature a NEW lesson each and every week. This gives us a
great opportunity to share our courses with everyone.
Some weeks they might be existing lessons
from our course library (like this week). Some weeks I might place
samples of new courses that are in development and haven't been released
yet. Other weeks I might mix things up a bit by putting custom-made
lessons, seminar clips, live videos, or even special tips-and-tricks
videos online. I plan on having lots of fun with this!
If you'd like to get notified when I post
new lessons, make sure to subscribe to the
FREE Lesson of the Week. Of course, I'll also post a
Hey folks. I just wanted to let everyone
know that one of the reasons Digital Photography 101 has been
delayed is that I have had a nasty cold for the past week. I can't
record anything right now - my voice is just gone, and I'm sure you
don't want to hear me sniffling in the video.
So... for the rest of this week, I'm going
to work on the Handbooks for the Photoshop courses we
currently have available. I've gotten a lot of emails from customers
asking when the next Photoshop course will be coming out. Here's what I
I want to spend some time focusing on
Photoshop Elements 3.0, the new release from Adobe. I know a lot of
people use Elements, and the latest version has lots of cool new
features. So after DP101, I'm going to record a few Elements classes
Then, after we've got a few Elements
courses ready, I'm probably going to switch back to regular Photoshop
and cover some of the more advanced features. It should be fun!
Now, all of you Access, Excel,
Word (etc.) fans, don't fret... I'll be making more courses for
you too. One of my personal New Years Resolutions is to get more courses
out at a faster pace from last year. I'm going to try to release one new
class a week. I'm going to try to accomplish this by making several new
courses for one topic at a time (like I did for Access last year). It
goes much faster because I don't have to "switch gears" going from one
topic to another. So Photoshop Elements is the next topic to
I hope your New Year has been more
productive than mine so far (sniffle, sniffle... blows nose). I'll keep
Well, it's our first day "back to work"
since our holiday break started. We have lots to do here this coming
week, including finishing up the release of our Digital Photography
Also, there are a
few hundred orders placed around Christmas time that will be shipping
out this week. If you haven't received your order yet, just hang in
there - it's on the way.
Finally, we'd like to give a warm
congratulations to Jen, our customer service manager. She just
welcomed a new baby girl to her family.
Happy New Year!
Click here to be notified when
this page is updated
Yes, folks, I'm very behind schedule
on Excel 223 and 224. The reason is actually a good one...
there is so much great material to cover on PivotTables that I'm
literally having a hard time packing it all in. I might have to extend
this series into one or two more sessions. That's a good thing! If
you're into PivotTables (or don't even know what they are yet) and want
to get the most out of your Excel data, you're going to LOVE
Microsoft Excel 222 is finished,
online, and available for download.
I've posted the full outline for
You can see all of the topics that are included in that course in
addition to screen shots and other information. I've also posted more
details on the entire Excel 220- series - including other topics
that will be covered. Interested in purchasing the whole series? Well,
there's a big discount available with the
Excel Data Analysis Combo. Click
here for details.
The Excel 220 Handbook is available
online in the Downloads section.
I asked my Access students to send me their
feedback - and ideas for what they want to see in upcoming classes. I've
gotten a lot of great feedback. I wanted to share some of it
with everyone here.
If you'd care to read it, click
The Excel 220 Handbook is finished.
It will be posted online for download tomorrow afternoon (Friday) for
those of you who purchased it already. Also, the Excel 222 video
lessons are just about finished.
One of the things I've
gotten a lot of email about is our Chat Room. People
always say that they have a hard time finding anyone available online to
answer their questions. Well, you're right. We're a small company, and
with all of the rest of the things our people have to do, it's hard to
find time to sit in the chat room.
Personally, I'm going to make an effort
to spend more time in there myself. I like chatting with my customers -
and I love to hear your feedback, or offer help when I can. Just this
evening, I got a really good idea for an Access database project while
chatting with a nice lady who needed help with her
Anyhow, I've updated the web site so that
you will only see the icons and messages offering LIVE HELP if
myself or one of my customer service agents are ACTUALLY online.
This way, you won't have to go through the trouble of clicking on the
CHAT link only to find nobody's home.
However... we do have a "callback"
feature in the chat room. If you log into the chat room and nobody's
there, you can put your name on a waiting list. As soon as someone comes
online, you'll automatically get an email that there is an agent waiting
to help you.
Again, I'm going to TRY to get
online more often myself. I spend about an hour a day reading and
responding to my normal email. I'm going to try to put myself in the
chat room while I'm doing that (based on my work load, of course), and
I'm going to tell everyone else here to try to do that too.
If you've sent any email in to our
customer service department recently (via the Web Contact Form, of
course) you should be happy to see that you got a reply FAST. We're
averaging about 24 hours to get back to customers right now - which is
MUCH better than we used to be.
Oh, and some of you have (strangely
enough) asked to see a current picture of me, since the image
elsewhere on the Web site is really old (about 4 years old now). I've
lost about 150 pounds (and the moustache) and don't look anything like I
used to. See my
weight loss web site if you'd like to know how. If you have some of
my Word or FrontPage classes where I put the picture of myself in the
document, that's a real old picture. I'll try to post a current picture
Microsoft Excel Data Analysis package is now available on the
online order page.
Only classes 220 and 221 are finished
right now and are available for download. You can pre-order 222 thru
224, but they won't be ready for another couple of days.
There is also a discounted Combo
Package available for all of the Data Analysis courses - so
you can take advantage of a significant discount if you want to order
all five classes. Again, you will be able to get started right away on
220 and 221, but the rest will be available in a few days when they're
The Excel 220 and 221 files
are available online for
members to download and try. They're so new, I haven't even had a chance
to watch them yet myself. I plan to work on the Handbooks for them later
today, so let me know if you catch anything odd in them (yes, I often
members as guinea pigs - but then again they get first crack at the new
For the rest of you -
I'll try to get Excel 220 and 221 available in the online ordering
section later tonight so you can purchase and download them.
Wow... I didn't realize it had been a month
since I last updated this page, but that doesn't mean we've been lazy...
in fact, we've been very busy. Our shipping and customer service
departments are all caught up. We've been shipping out CDs and handbooks
like crazy over the past few weeks. I know we had some handbook orders a
while back that (for some odd reason) never made it out. If you're still
missing a handbook (or anything else), please
contact customer service
and let us know!
been busy recording new Excel courses...
Microsoft Excel 220 and 221
are finished. The videos are "in the
can." All I have to do now is compile them together and package them up
and they're good to go. Expect to see them both available on the
Order Page very soon. Next I'm going to be working
on the handbooks for both of these courses which usually takes a day or
two - then you should see the full outline on the web site, and the
handbooks will be available online as well.
members will have first access to them - so they can email me and tell
me how good or bad they are. Ha ha ha.
What's covered in these classes? Well, if
you're a student of my Excel tutorials, you might have noticed I skipped
a few numbers. I went from 202 right to 220. Why? The 220- series is
going to be all about Data Analysis. Remember that little survey
I sent out back at the beginning of September (look down the list here
and you'll see it). Well, people overwhelmingly want to learn how
to use things like data lists, grouping, subtotals, and the number one
request: Pivot Tables. So, the 220 series will focus on just
Excel 220 starts off with the
basics: creating lists, formatting lists, using data entry forms,
advanced list sorting techniques, and customizing toolbars (because
there are a ton of data analysis features that we need to drop on a
custom toolbar so we don't have to spend hours clicking deep in the
menus every time we want to do something).
Excel 221 looks at filtering with
AutoFilters, custom AutoFilters, advanced filters, custom views, the
SUBTOTAL function, and generating automatic subtotals. We'll also go off
on a side project where we'll use advanced filtering techniques to
generate late notice mailing labels (using Word) for a select group of
customers with past due balances. This was a fun class to record.
Both of those courses are FINISHED. Next,
I'm going to write up the handbooks for them, and then work on Excel
222, which will start getting into Pivot Tables. You really
should learn the material from 220 and 221 first, however, before
embarking on the big quest... Pivot Tables when used properly have a
lot of cool and powerful features.
I don't have an exact number for the
total list of 220- series classes, but we'll probably have at least four
or five of them. I also want to cover Excel database functions,
importing and exporting data (so when someone hands you a disk or emails
you a file, you can get that data into Excel), scrubbing data (so you
can clean up that mess they send you before analyzing it), and then of
course scenarios and the solver. Plus there's more... I'll get into that
in more detail later.
I'm going to try to finish up ALL of
these courses this week (the week of October 9th). We'll see how it
goes. Handbooks can sometimes take more time than the actual classes,
but I like to write them myself instead of having one of my staffers
work on them - it's a good chance for me to quality control the videos
PLUS as you know (if you've read any of my handbooks) I always like to
throw in little extras that I don't think of until after
I'm done with the videos.
What's next? After the Excel Data
Analysis series? That all depends on you.
Send me your feedback.
Do you want to learn more Excel? Or should I move on to a different
topic. I know a lot of people have been emailing me for more Access
and Photoshop courses. You tell me what you want to see! Squeaky
wheel gets the grease.
Thanks for reading all of
this. I'll try to update this page more often. Until next time, enjoy!
We are now offering
FREE SHIPPING on all orders over $100. Your order
will be sent via USPS Certified Mail, and should arrive in 3 to 5
want to know what YOU want to see covered in the next Excel
class. Tell us specifically what topics you want to see us
cover in Excel. Give us examples. Send your comments to us here:
We've added a free preview lesson of our
Microsoft Excel 202 course to the Free Demo Page.
We've completely updated the
Microsoft Excel section of the
web site. All of the detailed course outlines are now online - including
a new Searchable Index of all topics covered. Check it out.
The Microsoft Excel 202 Handbook has
been posted to the downloads section. Any orders that contain Excel 202
are shipping out this weekend.
Microsoft Excel 202 is now available
in the downloads section. The handbooks for Microsoft Excel 101 through
201 are finished and are available online.
Digital Photography 101 is available
for ordering online. You can visit our order page
to place your order now. The full outline
of the course is also available online so you can see what this course
covers. We've also added a segment from one of the lessons to the
free demo page.
It's finally done! Digital Photography
101 and it's handbook are both finished. They are currently
online and available for
MYOLP members to
download from the self-paced courses section. I should have it ready for
purchase for everyone else in the order-entry system later tonight or
Whew! That was a long one... it's
not that the DP101 material was very difficult... but
introductory classes just take so much longer to prepare (lots of
pictures and slides)... plus I have to go at a slower pace (beginner
material). Not to mention it's a 90 minute class. A lot of work
went into this one! If you want to learn more about digital photography
- or don't know anything and want to start using your digital camera
properly - this is the course for you. I'll have a full outline on the
web site in a few hours so you can see exactly what this course covers.
Now it's on to some new stuff! Excel
and Photoshop are next.
May is already upon us, and we've got
several new classes coming out this month. We're going to begin with the
release of Digital Photography 101 which - after several delays - should be out
Following that, we have some new
Photoshop and Excel classes coming
out - including New Handbooks for both our existing Photoshop and
Excel courses (you'll have the opportunity to get them when the new
classes come out). We'll end the month with a new
Microsoft Access release or two. Any questions, please
We currently have a new position open for a corporate sales consultant.
This is a position for
"outside" work - which means you can work from home and set your own
hours. If you are interested, please contact our human resources
CONTACT HR and let us know what your experience is.