Microsoft Excel Tutorial Videos and VBA Training

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

The Microsoft Excel 2010 Tutorial Video is a great way for people to go beyond the basics and gain a solid understanding of the range of tasks the program can be used to do. Designed primarily for beginners, this course will help you first gain familiarity with the Excel interface and essential tasks, and then work up to techniques of increasing complexity as your skill set grows. This expert-led course covers an extensive range of subjects, including creating worksheets and workbooks, editing table elements, customizing spreadsheet design, working with formulas and functions, managing data, working with charts and graphs and more. A full list of topics covered can be found on the product site.

Microsoft Excel Automation Tutorial Videos
(Tutor: Lauri Matson Number of Videos :71 , Training Duration: 5 hours)

This Microsoft Excel Automation Tutorial video course is designed to increase your efficiency, accuracy, and productivity by showing you how to use the program’s most advanced features and tools.  Geared toward intermediate and advanced users, the tutorial takes users through the highest level of spreadsheet capabilities.
Experienced Excel user and professional accounting software consultant Lauri Matson narrates this instructional video series designed around practical examples and included work files.  Each lesson includes a live feed in the application in use, so you’re never left wondering whether you’re on the right track.  This method of teaching by direct example allows you to learn more efficiently and increases retention of the skills acquired.
Available online or as one training package on CD , these videos allow you to learn at your own speed.  Lessons are divided in a way that makes it easy to skip around, and each video has a full set of playback controls.  And since the course disks are Mac and PC compatible, you can learn from the comfort of your own desk or from any computer.

Microsoft Excel 2007 Tutorial Videos
(Tutor: Cheryl Duncan Number of Videos : 104, Training Duration: 8 hours)
Version : 2007
This Microsoft Excel tutorial is an indispensable training aid and reference for using Excel 2007, suitable for beginners and intermediate users this training CD offers an comprehensive insight into using Excel in a commercial environment. Using practical hands-on examples the tutorial teaches by using a series of preset problems and providing the solutions using working examples and detailed explanations, working files are included in this tutorial so users can participate and work along with the author in real time.

Microsoft Excel Tutorial Videos
(Tutor: Kate Chase Number of Videos : 117, Training Duration: 6 hours)
Version : 2003
These Microsoft Excel Video Tutorials enables you to turn data into useable information with powerful tools to analyze, communicate, and share results. Excel 2003 can help you work better in teams, and help protect and control access to your work. In addition, you can work with industry-standard Extensible Markup Language (XML) data to make it easier to connect to business processes. From simple spreadsheets to complex databases, it is all covered in this Microsoft Excel 2003 tutorial video. From basic formulas, functions, and chart creation to data analysis, custom number formats, data validation this is the comprehensive tutorial covering Microsoft Excel 2003. Beginners and experts alike will benefit from the tutorials. Learn your way around cells, rows, columns, worksheets, workbooks, and ranges Discover how to create charts and diagrams, organize lists, and simplify complex tasks using Excel. Create formulas that manipulate text, look up values, and perform financial applications Analyze data using external database files and pivot tables, use Goal Seek and Solver, and master the Analysis ToolPak Use XML to facilitate data reporting, analysis, importing, and exporting Explore conditional formatting, link and consolidate worksheets.

Microsoft Visual Basic for Excel Tutorial Videos
(Tutor: Pravah Pugh Number of Videos : 104, Trainig Duration: 8 hours)
Version : N / A
In this series of Microsoft Excel tutorial videos we take a look into using the VBA programming language to expand on your basic knowledge of Excel. Author Pravah Pugh starts the lessons of with a detailed look into the powerful world of Macros and using VBA to extend the functionality of this application, the training then goes into the creation of custom functions, labels and referencing. This is an ideal training source for any user that already as a good basic knowledge of working with Excel but would like to use VBA in conjuction with it.