Training

Self-study IT Training

Self-study Computer Training Courses

We appreciate that not everyone has time to attend a classroom training course or take time out of work for training, so why not receive high-quality, effective training delivered to your door for a fraction of the cost of traditional classroom training?

Self-study computer training provides high-quality courses at low cost to fit in with your personal schedule. In many cases, self-study materials provide simulations so that you do not need to buy the software in order to learn it. The training materials we offer use sound, video and practical exercises to ensure rapid learning.

Self-study Materials

Whether you want to learn Microsoft Office or study for professional certification exams, there is a course to suit you. We are pleased to be able to offer these self-study options:

  • VTC cross-platform training CDs for PC or MAC . Learn from experienced instructors who take you from the basics to a highly competent skill level in a single course. Courses include: desktop applications, web design, graphics, multimedia, programming and much more. Free samples available. You do not need any additional software to take these courses.

Microsoft Course Demo

This VTC course will give you the knowledge and skills you need to get the most out of Microsoft Excel 2013. You will learn about the Excel interface by working in it. You will create and format worksheets, make calculations, create charts, and use tools to analyze data in meaningful ways. Author Helen Bradley teaches Excel from a business perspective, focusing on tools that maximize productivity and accuracy. She demonstrates how to design worksheets intelligently and then shows you how to check for accuracy to ensure that worksheets return correct results. She also covers automating data entry, testing formulas, and using PivotTables for data analysis. She concludes with a discussion of SkyDrive and the Excel WebApp.

To begin learning today, simply click on the title link.

Microsoft Excel 2013

Rearranging a Worksheet
  • Size Columns and Rows
  • Insert & Delete Rows & Columns
  • Copy or Move Data
  • Copy or Move a Worksheet
  • Transpose Data
Basic Formulas & Functions
  • Using SUM and AutoSum
  • Doing Simple Math
  • Order of Operations
  • Calculating Averages
  • Quick Analysis - Totals
  • Adding & Subtracting Dates
  • Copy Formulas
  • Absolute & Relative Addressing
  • Naming Ranges
  • Calculating Using Names
  • Understanding Errors
  • Evaluating a Formula
Formatting a Worksheet
  • Format Numbers
  • Format Dates
  • Format with Color
  • Use Worksheet Themes
  • Add Borders
  • Conditional Formatting pt. 1
  • Conditional Formatting pt. 2
  • Borrow Table Formats
  • Create and Use Styles
  • Paint and Clear Formats
Creating Charts
  • Create a Chart
  • Add Chart Titles and Legends
  • Format a Chart pt. 1
  • Format a Chart pt. 2
  • Create a Pie Chart
  • Understanding Chart Types
  • Plot Data on Multiple Axes
  • Create Sparklines
Adding Art
  • ClipArt and Photos
  • Worksheet Backgrounds & Watermarks
  • SmartArt
  • Shapes
More Complex Functions
  • Using IF to Make Calculations
  • Using SUMIF & COUNTIF
  • Calculating with SUMPRODUCT
  • Random Numbers with RANDBETWEEN
  • Find and Use Functions
  • Building a Mortgage Calculator
Working with Tables
  • Create and Format a Table
  • Create a Chart of Table Data
  • Calculations in a Table
  • Use the Subtotal Function
  • Filter Table Data
  • Sort Data in a Table
Working with PivotTables
  • PivotTables Introduction
  • Create a PivotTable
  • Query a PivotTable
  • Use Slicers
  • Create a PivotChart
Working with Large Worksheets
  • Freeze Panes
  • Headers & Footers
  • Views
  • Find & Replace
  • Manipulate Data with Flash Fill
  • Remove Duplicate Data
Advanced Tools & Techniques
  • Goal Seek
  • Create and Use a Watch Window
  • Create and Save a Template
  • Calculate Across Multiple Worksheets
  • Working with Comments
  • Use a Lookup Table pt. 1
  • Use a Lookup Table pt. 2
  • Import Data into Excel
  • Find Precedents and Dependents
  • Use Data Validation
  • Enter Data Using Data Validation
  • Work with Other Office Programs
Printing a Worksheet
  • Set Up a Worksheet for Printing
  • Shrink to Fit
  • Configure Printing Options
  • Print a Chart
  • Print a Selection
  • Print to PDF
Spreadsheet Design
  • Design Basics
  • Create a Data Area
  • Work with Multi-Sheet Workbooks
  • Protect a Worksheet
  • Error Checking and Testing
  • Spell Check and AutoCorrect
Automating with Macros
  • Understanding Macros
  • Record a Macro
  • Run a Macro
  • Explore the Visual Basic Editor
Working with Skydrive
  • SkyDrive Introduction
  • Save and Open SkyDrive Files
  • Work in the Excel Web App
  • How to Use SkyDrive
Conclusion
  • Course Wrap Up
Credits
  • About the Author