Teach-ict.com is a great software teaching and learning site that provides free training content for Microsoft Office and other applications. This site was developed by teachers, its coursework materials are high quality and are targeted to both students and teachers. Here are their Excel Training Course Workbooks that cover many of Excel's basic and advanced features.

Excel Training Course Workbooks

Spreadsheet Workbook 1 (.doc)    

This training workbook shows you how to create a new spreadsheet using Excel. The following skills are covered:

• Basic Formula - Addition, Subtraction, Multiplication, Division
• Basic Functions - SUM, AVG, MIN, MAX, COUNT
• How to display formulae
• Importance of resizing columns and rows to display data

Spreadsheet Workbook 2 (.doc)

This Training workbook shows you how to create a new spreadsheet using Excel. The following skills are covered:

• Printing to one sheet only
• Displaying grid lines on printouts
• Displaying column letters and row numbers on printouts
• Inserting name onto printouts
• How to use custom headers/footers
• Changing margins/page orientation
• How to print a certain area of the sheet
• How to hide/unhide columns
• Changing formats e.g. decimal places, currency
• Adding borders
• Sorting data
• Ski (.xls)
• Ski  Holidy Budget Task  (.doc)

Students should download the ski.xls file to their area. They should then complete workbook 2 before being given a copy of 'ski holiday budget task' to complete.


Spreadsheet Workbook 3 (.doc)

This training workbook shows you how to create a new spreadsheet using Excel. The following skills are covered:

• absolute cell references
• if then formula

Spreadsheet Workbook 4 (.doc)

This training workbook shows you how to create a new spreadsheet using Excel. The following skills are covered:

• nested IF formula
• If (OR) formula
• If (AND) formula

Spreadsheet Workbook 5 (.doc)

This training workbook shows you how to create a new spreadsheet using Excel. The following skills are covered:

• naming cells
• vlookup
• hlookup
• Modelling Task 5 (.xls)
• Modelling Task 5 Answers (.xls)

More Training for learning some of Excel's advanced features:

• General Practice - supermarkets (.doc)
• Absolute Cell References 1 (.doc)
• Absolute Cell References 2 (.doc)
• Absolute Cell References 3  (.xls)
• Conditional Formatting 1 (.doc)
• Conditional Formatting 2 (.doc)
• IF..Then - Budget (.xls)
• IF..Then - Discounts (.xls)  IF..Then Discounts Answers (.xls)
• IF..Then - Tests (.xls)  IF..Then Tests Answers (.xls)
• IF..Then - If..then, IF(OR), IF(AND) (.doc)  Practice (.xls)  Practice Answers (.xls)
• VLookups (.doc)
• VLookups - Class XX (.xls)
• VLookups - Jobs (.xls)
• VLookups - Magazines (.xls)  VLookups - Magazines Answers (.xls)
• VLookups -Fuel (.xls)  VLookups - Fuel Answers (.xls)
• VLookups - Cats (.xls)  VLookups -Cats Answers (.xls)

Here is a rich group of 132 Excel tutorials and tips covering the Excel Environment, Excel's Menus, Other Applications and Excel, Reference Resources for Excel. These free training Excel pages are offered by MrExcel, Chip Pearson, and John Walkenbach, which, as a whole, provide over 500 Excel Articles and Tutorials.

These Excel Tutorials and Tips are shown here in the following categories:

• The Excel Environment - Information on Excel's inherent environ and the integration of other processes
• Menus - Working with Excel's Menus - Covers anything found in Excel menus, Plus tips on customizing your own menus
• Other Applications and Excel - Integrate other applications with, or enhance Excel workbooks
• Reference Resources for Excel - Other online references, tutorials and tips on working with Excel

The Excel Environment

• Add buttons to a toolbar
• Analysis Tool Pack
• API-What is it?
• Application Procedures
• Basic Excel Tips to make life easier
• Close all workbooks quickly
• Colored Worksheet tabs - Excel 2002
• Dates - Before 1900
• Deleting Code-VBE
• Differences in Excel versions
• Event Procedures
• Excel Help text size
• Helpful Keyboard shortcuts common to Excel
• Increase Columns and/or Rows
• Issues with Data Validation and Freeze Pane
• Keep Excel in focus
• Keyboard Shortcuts
• MapInfo Pro Tables with Excel Data Map (Pre-Office XP)
• Message in Status bar
• Move the cell pointer right after hitting enter
• Navigating Excel Worksheets
• Print the Excel Help File
• Quickly Navigate to Any worksheet
• Serial Dates
• Show full menus all the time
• Solve common set up issues in Excel
• Sort Using a Formula - Build a Report to Recognize the Top 5 Sales Reps
• Switching between active worksheets
• Turn off Gridlines
• VBA Modules
• VBE-Using the Visual Basic Editor
• Very Hidden worksheet
• Web Query to Refresh Internet Data into Excel
• Web Query to harvest info from 4000+ web pages
• KwMap.net - browse the Keyword Map of MrExcel.com

Menus - Working with Excel's Menus

• Add a Certain Number to All Numbers in a Range Using Paste Special Add
• Add a percentage to all cells in a range
• Change cell values using Paste Special
• Change the default number of worksheets
• Change the format of subtotal rows
• Close All Workbooks
• Color - with Conditional Formatting
• Conditional Formatting
• Conditional Formatting
• Conditional Formatting for Due Dates
• Conditional Formatting to compare lists
• Conditional Formatting to shade rows
• Conditional Formatting: Considering the '4th' option
• Consolidation to summarize data
• Converting non-numbers to actual values
• Copy page set up settings to other sheets
• Copying Subtotaled Data
• Count Auto Filtered rows
• Creating Custom Menus in Excel
• Customizing Menu Items
• Data Validation
• Data Validation to check for repeated values
• Delete values, but keep the formulas
• Display Fractions with Format Menu
• Dropdowns using Data Validation
• Duplicate repeated entries
• Edit-GoTo to copy visible cells
• Eliminating the 'Enable Macros' messagebox in Excel
• Excel Function Help
• Filter with Ease using DigDB Add-in
• Format to Create Batting Averages
• Format to display in thousands
• Freeze pane for select rows and columns
• Freeze the Headers so they are always visible as the cell pointer scrolls deeper into the worksheet
• Getting Rid of Broken Links
• Getting Rid of Broken Links
• Graphing - Changing Default Settings
• How to easily 'unmerge' cells
• How to filter out duplicate data
• Identify formulas using Conditional Formatting
• Import a text file to a worksheet
• Incorrect decimal place fixes
• Keeping Excel from changing data to dates
• Linking comboboxes with Data Validation
• Locking cells to protect critical data
• Make the Header Row stay visible as you scroll through data
• Merging rows
• Moving Subtotaled Data
• Multiple lines of Text
• No Text Import Wizard
• Non-printing rows
• Pasted Text is Inexplicably automatically parsed
• Paste-Special Uses
• Perform math operations without formulas
• Prevent Duplicate Values with Data Validation
• Protection - cells, sheets, workbooks and files
• Recently used filelist - increase the number of files available in the list
• Removing hyperlinks from a worsheet
• Setting a print area
• Special Characters
• Split the contents of one column into two columns
• Splitting the contents of a cell/column into two distinct cells/columns
• Stop Duplicate Entry
• Subtotals to summarize data
• Subtotal without grouping
• Tabbing through specific cells
• Time - Negative values
• Use a number format to make zeroes not appear
• Use Edit / Replace to Remove Decimal Points
• Workspace File? What is it and how can I use it?

 
Other Applications and Excel

• Changing the default cell comment formatting
• Convert PDF to Excel
• Convert PDF to Excel as shown on TechTV
• Discover New Excel sites with Del.icio.us
• Excel Wiki
• Get a list of file names
• Google Spreadsheets
• Import data from the web
• Import your AOL File Cabinet to Outlook
• Importing CSV files from Other Applications
• Mail Merge Excel Data to Word Labels
• Map your Excel data with MapPoint
•  MapPoint and Excel - Many Great Articles at MP2K Magazine
• MrExcel's Recommendations: Access help
• MrExcel's Recommendations: Word help
• Post to MrExcel.com Message Board
• OneNote Overview
• Push Excel data to OneNote SP1
• Resize Excel's sheet tabs
• Search MrExcel.com Message board for Keywords
• Updating Distribution Lists
• Watch a dozen websites in minutes using a FeedReader 

Reference Resources for Excel

• Colors in Excel - Anything you every wanted to know
• Excel 2000 - Tutorials c/o James Madison Univ.
• Excel Function Dictionary - website by Peter Noneley (150 + functions in Excel)
• Excel Reference by Category - website by Pierre Leclerc M.Sc.
• Excel Resources - website by Mark Henri (Technical Support Specialist for Microsoft
• Excel Tips and Tricks - website by Aaron Blood

Here is an excellent set of 84 Excel articles, tutorials, and tips covering Excel 2007 New Features, Links and Hyperlinks, Drawing Objects in Excel, and General Excel Topics. These tips and tutorials are provided by these well developed Excel tutorial sites: MrExcel, Chip Pearson, and John Walkenbach, hosting a total of over 500 Excel Tutorials.

These  Excel Tutorials and Tips are listed below in these categories:

• Excel 2007 Features - What's New in Excel 2007
• Links and Hyperlinks in Excel - Information on working with Links and Hyperlinks in Excel
• Drawing Objects in Excel - How to use Drawing Objects in Excel
• General Excel Topics - From Games to Shortcuts in Excel. Covers Basic to Advanced topics

Excel 2007 New Features

• Document Themes in Office 2007
• SmartArt Graphics in Excel 2007

 
Links and Hyperlinks in Excel

• Creating a linked picture of a range
• Locate phantom links in a workbook
• Removing external links
• Unlink a chart series from its data range

Drawing Objects in Excel

• Displaying a value in an AutoShape
• Rotating text with an AutoShape

General Excel Topics

• 5 Tips to Eliminate Redundant Data
• Absolute Reference Uses
• Add graphics to your page header
• Add subtotals automatically
• Automatic Subtotals
• Autocorrect shortcuts
• Autoformat Reports
• Car Loan Payments in Excel with =PMT() function.
• Calculating with Feet and Inches
• Collaborate on an Excel worksheet by opening it in Google Spreadsheets
• Conditional Formatting to Higlight Items Due Today
• Copy Range formulas
• Creating Dice in Excel
• Cursor in unprotected cells only
• Degrees, Minutes and Seconds
• Discover New Excel sites with Del.icio.us
• Entering data in Excel - preselect the range
• Excel 12 Preview
• Excel Wiki
• Fill Handle trick - Ctrl+Drag to extend 1 to 1, 2, 3
• Floating Points
• Formatting External Data for Excel
• Freeze Panes So You Can Always See Row 1
• Function? What's that?
• Games in Excel
• Gradebook in Excel
• Greenbar Formatting - 3 Methods
• Have a picture pop-up when you hover over a cell
• Highlight Current Row and Column: From the MrExcel Message Board 'Hall of Fame'
• Highlight Maintenance Due Dates that Are Due Today.
• History of Spreadsheets
• Identify Cells with Formulas
• Inserting an image into a worksheet footer
• Inventor of VisiCalc - Dan Bricklin
• Keep page numbers consistent by printing the entire workbook at once.
• Keep Score with Excel
• Keyboard Shortcuts
• Limitations of Excel
• Locate Duplicates with Conditional Formatting
• Macro? What's that?
• MrExcel "Challenge of the Month' Winners
• No Automatic hyperlinks
• Not Enough Memory message
• Pop-Up Pictures Attached to a Cell
• Print page numbers at the bottom of each page
• Print titles at the top of each page
• Print titles starting on page 2
• Proofread with Text-To-Speech
• Quick Answers for Basic Questions
• Rational Databases in Excel
• Shift Rows up & down Quickly
• Shortcuts - Excel Keyboard Shortcuts
• Shortcut key to repeat last command
• Solve Sudoku with Excel
• Sort data with one click
• Sort in a Custom Sequence
• Sort Randomly
• Spreadsheet Programs
• Spreadsheets on the internet
• Subscribe to the MrExcel Video Podcast using iTunes
• Sudoku Solver using Excel
• Symbols - Special Characters in Excel
• Text-To-Speech Feature to Read Cells to You
• Track Progress Towards a Goal
• Track softball stats with Excel
• Track Your Collection in Excel
• UDF -Calculated Range in a Standard Function: From the MrExcel Message Board 'Hall of Fame'
• Updating old information
• Use a Data Form for Data Entry
• Use AutoFilter to See Matching Records
• Validation to help people fill out your spreadsheets correctly
• Versions of Excel
• VLOOKUP Example
• What if I don't like fishing?
• What is RSS, XML, and FeedReader?
• Working with fractional values in Excel
• Excel Training Sources

Profsr.com offers this Microsoft Access tutorial giving you step-by-step instructions on how to create and develop a commercial-grade database application. It beings with teaching database modeling, which deals with the actual design of the database before it's created. After designing database, you will learn how to develop the required database objects and learn how to use them. A simple application (Video Rental Store) is demonstrated showing how Microsoft Access is used in business. This database application assists with gaining an understanding of how users can deploy Access using its database management tools and facilities.

Microsoft Access Database Tutorial


Lesson 1 - Microsoft Access Introduction

Lesson 2 - Designing the application - tables, fields, data types, properties

Lesson 3 - Creating the database - primary key, creating tables

Lesson 4 - Defining Table relationships - referential integrity, primary and foreign keys

Lesson 5 - Entering data into Tables - data view, sorting and ordering

Lesson 6 - Creating data-entry forms - data validation, default values

Lesson 7 - Building simple Queries - sorting, selection criteria, working with dates

Lesson 8 - More complex Queries - multiple tables, linking, functions

Lesson 9 - Creating a Master/Detail form

Lesson 10 - The Microsoft Access Application Menu - the Switchboard

Lesson 11 - Creating Macros - autoexec, conditions

Lesson 12 - Writing Reports

Lesson 13 - Sales Analysis Reports with Microsoft Access

Lesson 14 - Action Queries - Updating data

 Download Area- sample Microsoft Access databases

This is a nicely illustrated, 2-page tutorial covering Microsoft Project that introduces you to Project and demonstrates its basic functionality. This application has many features and capabilities and some of the most important are shown in this tutorial.

Microsoft Project Tutorial

• Defining the Project
• Manage the Project Resources

Gantt Charts are an important concept that is used in Microsoft Project and its important to understand how to use these types of charts. Here is a 4-page Gantt Chart Tutorial (pdf format) that discusses project planning basics (tasks, milestones, work breakdown statements) and how to use Excel to make Gantt Charts.