About the Training Videos

 

The titles listed below are Beginners Advanced Excel tutorials. These lessons are aimed towards the novice and the author assumes the user as no prior experience with the application. The simplistic step-by-step format of the free Advanced Excel training videos will ensure you quickly gain a level of competence and will be able to use Advanced Excel in a commercial environment. Should a title be marked as Advanced it's recommended that the user have a solid working knowledge of the application before taking the training or have watched the beginners videos first.

For more information on each title and to watch the free Advanced Excel tutorials just click the corresponding link of the title that interests you.

Excel Automation Tutorial Video
(Tutor: Lauri Matson, Number of Videos: 71, Training Duration: 5 hours)
Level: Beginner - Intermediate
Version: MS Excel 2007+

These Excel Automation tutorial videos will help you learn to increase productivity, reduce errors, and simplify your workflow. Expert tutor Lauri Matson explains the helpful skills that will help you finally make the most of this powerful spreadsheet program. The comprehensive lessons will teach you to automate tasks to avoid duplication, making you more efficient and effective. The training is not for beginners, as it explores advanced functionality meant to improve how those who already use the software are able to work. The instructional guide delves into topics such as macros, creating a routine, adding controls, formulas and functions, pivot tables, automating charts and graphs, and more. The combination of narration and screencast video demonstrates exactly how to carry out the procedures this training guides you through, eliminating guesswork.

Microsoft Excel for Statistics Tutorial Video
(Tutor: Mark Clarkson, Number of Videos: 104, Training Duration: 8.5 hours)
Level: Beginner - Intermediate
Version: MS Excel 2007+

These Microsoft Excel for Statistics tutorial videos will help users already familiar with the fundamentals of Excel learn to use the program to its fullest extent to create statistics in a professional environment. Expert trainer Mark Clarkson explains topics such as data validation, statistical distributions, probability, descriptive statistics, relationships, inferential statistics, and more. The courses use step-by-step demonstration, which combines audio and video, to make it simple for you to learn the essential skills and techniques you need to use Excel to its highest capability. Explore the full functionality of this program with this training, available as a CD / DVD or streaming online through the monthly subscription service. Free demo lessons are featured on the product site.