Excel Video Tutorials

Here are Teach-ict.com’s training videos teaching you how to use the features of Excel, Microsoft’s Office Spreadsheet application. These will help you learn how to perform the following functions using Excel: Formatting (colors, borders, cells, tabs, text), Inserting, Deleting, Moving, Charts (type, colors, new chart, labels), Validation, Formulas (autofil, sum, percent, average, min, max, vlookup), Printing, Sorting, and Searching . Using these training videos and can learn these Excel features by watching what happens on the screen, and then trying it yourself. These are some of the many Free Video Tutorials on various software applications that Teach-ict.com offers.

Excel Tutorial Topics:

• Formatting
• Insert/Delete/Copy
• Charts
• Validation
• Formulas
• Printing
• Sorting and Searching

Excel Video Tutorials

	Formatting
	Background colours
	Borders
	Column Widths
	Currency
	Merging cells
	Tabs - renaming
	Wrapping text
	Inserting/Hiding/Deleting/Moving
	Footer - inserting
	Row - deleting a row
	Row - inserting a new one
	Worksheet - making a copy
	Worksheet - deleting one
	Worksheet - inserting a new one
	Charts
	Axis - changing values
	Chart type – changing it
	Colours - changing them
	New chart – making one
	Pie chart – adding labels
	Validation
	Drop down pick list
	Formulas
	Autofill - copying formulas
	Addition formula
	SUM formula
	Multiplication formula
	Percentage formula
	Average formula
	Min formula
	Max formula
	VLOOKUP formula
	Absolute Cell Reference
	Formulas - showing them
	Formulas - hiding them
	Printing
	Gridlines
	Orientation - Portrait/Landscape
	Print Preview
	Print area – how to set it
	Printing to one page
	Row and column headers – displaying
	Sorting & Searching
	Sorting data in a table
	Goal Seek

Popularity: 4% [?]