Education is the most powerful weapon
which you can use to change the world.
-Nelson Mandela
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
NEW Release: Access Advanced Level 2    dismiss
     
 
What's New

Old Stuff


 
3/21/06 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.
3/15/06 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 make-table queries).

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.

3/1/06 The Microsoft Excel 223 Handbook is now online for download.
2/28/06 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.

If you 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.

2/22/06 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!
2/14/06 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.
2/13/06 Oops. I went a little long while recording 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 online for MYOLP members shortly. Everyone else will be able to order the full class later today.

2/7/06 I've added Microsoft Excel 222 and 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.
1/30/06 The Microsoft Excel 222 Handbook is now online for download.
1/20/06 I just finished recording the new Microsoft Access 220 class. This class deals with advanced query techniques. It's available for download by MYOLP 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 $22.99).
1/3/06 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 answer still.

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? Contact me.

12/6/05 The handbook for Microsoft Excel 221 is now online for download.
11/25/05 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.
11/24/05 Hey everyone... Happy Thanksgiving!
11/21/05 The holiday gift-giving season is upon us once again. Just like last year, we're giving away FREE Holiday 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 holidays?

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 FREE Holiday Gift CD Page.

11/20/05 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.
10/10/05 As promised, Excel 223 and 224 are online for any users who have purchased them (and MYOLP members) to download them. We're making the CDs right now, and orders containing them will be shipping out tomorrow morning.
11/10/05 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.

10/28/05 We have a new feature here at 599CD... a 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 notice here.

1/6/05 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 have planned...

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 with handbooks.

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 focus on.

I hope your New Year has been more productive than mine so far (sniffle, sniffle... blows nose). I'll keep you posted!

1/3/05 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 101 course.

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.

1/1/05 Happy New Year!

Click here to be notified when this page is updated

 
 
 
 
10/27/05 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 these classes.
10/18/05 Microsoft Excel 222 is finished, online, and available for download.
10/15/05 I've posted the full outline for Excel 220. 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.
10/14/05 The Excel 220 Handbook is available online in the Downloads section.
10/14/05 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 here.
10/13/05 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.
10/12/05

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 MYOLP password.

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 soon. >Richard

10/11/05 The entire 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 finished.

10/10/05 The Excel 220 and 221 files are available online for MYOLP 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 use the MYOLP members as guinea pigs - but then again they get first crack at the new courses).

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.

10/9/05 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!

Personally, I've 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.

Of course, MYOLP 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 that.

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!

>Richard

9/9/05 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 business days.
9/5/05

We 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: Excel Ideas!

8/14/05 We've added a free preview lesson of our Microsoft Excel 202 course to the Free Demo Page.
8/13/05 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.
8/12/05 The Microsoft Excel 202 Handbook has been posted to the downloads section. Any orders that contain Excel 202 are shipping out this weekend.
8/6/05 Microsoft Excel 202 is now available in the downloads section. The handbooks for Microsoft Excel 101 through 201 are finished and are available online.
5/18/05 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.
5/17/05 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 tomorrow morning.

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.

5/2/05 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 very soon!

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 contact us.

5/1/05 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 department: CONTACT HR and let us know what your experience is.
 
 
     
 
Previous Months  2004 -  Jun    Jul    Aug    Sep    Oct    Nov    Dec
 
   
 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP