02 Overview of Spreadsheets and Excel 2007
02 Overview of Spreadsheets and Excel 2007
This video gives an overview of the
use of Micosoft Excel and Spreadsheet.
This video is part of the VTC course on Microsoft Excel 2007. The course
consists of 115 high quality videos by seasoned experts, good for more than 8 hours of professional training.
For the full VTC course on Microsoft Excel 2007 click
HERE.
Duration:
4m:59s
Views:
1419
Added:
920 days ago
07 Introducing the New Excel 2007 Ribbon
07 Introducing the New Excel 2007 Ribbon
The ribbon is new in Microsoft Excel 2007 and can cause some confusion when your new to it. But it offers a great improvement in usability once you are
accustomed to it.
This video is part of the VTC course on Microsoft Excel 2007. The course consists of 115 high quality videos by seasoned experts, good for more than 8 hours of professional
training.
For the full VTC course on Microsoft Excel 2007 click
HERE.
Duration:
4m:59s
Views:
910
Added:
920 days ago
12 Accessing Microsoft Excel 2007 Help
12 Accessing Microsoft Excel 2007 Help
The Help function offers a great resource for most of the questions you will have when using Excel 2007. This video explain how you can best
use the Help
function.
This video is part of the VTC course on Microsoft Excel 2007. The course consists of 115 high quality videos by seasoned experts, good for more than 8 hours of professional
training.
For the full VTC course on Microsoft Excel 2007 click
HERE.
Duration:
4m:59s
Views:
1049
Added:
920 days ago
15 Excel 2007: Accessing the Support Knowledge Base
15 Excel 2007: Accessing the Support Knowledge Base
Learn how to
use the support knowledge base for excel 2007.
This video is part of a the VTC course on Microsoft Excel 2007. The course consists of 115 high quality videos by seasoned experts, good for more than 8 hours of professional training.
For the full VTC course on Microsoft Excel 2007 click
HERE.
Duration:
4m:59s
Views:
1396
Added:
920 days ago
20 Dreamweaver CSS Layout - Why Use CSS?
20 Dreamweaver CSS Layout - Why
Use CSS?
This video is part of the VTC course on Dreamweaver CS4. The course consists of 104 high quality videos by seasoned experts, good for more than 9 hours of
professional training.
For the full VTC course on Dreamweaver CS4 click
HERE.
Duration:
4m:59s
Views:
659
Added:
920 days ago
35 Dreamweaver CSS Layout - When to Use ID vs. Class
35 Dreamweaver CSS Layout - When to
Use ID vs. Class
This video is part of the VTC course on Dreamweaver CSS Layouts. The course consists of 92 high quality videos by seasoned experts, good for
more than 8 hours of professional training.
For the full VTC course on Dreamweaver CSS Layouts click
HERE.
Duration:
4m:59s
Views:
926
Added:
920 days ago
Advanced selling on ebay
This video tutorial explains how to
use the advanced listing features provided by ebay, including setting postage, start time, uploading, and reviewing your listing.
Duration:
7m:39s
Views:
1727
Added:
1093 days ago
Autoplay feature in Windows 7
How to
use the "autoplay" feature in Windows 7. Including opening a folder, auto transfer of files, and configuring that setting for every instance.
Duration:
1m:9s
Views:
1600
Added:
1040 days ago
Basic Excel Functions
How to
use the functions contained within the autosum button,within the editing group on the home ribbon within Excel 2007
Duration:
4m:7s
Views:
2203
Added:
1051 days ago
Creating Summary Tasks
In this video you will find out why you would
use summary tasks and create and remove summary tasks and project summary tasks, also how to view the top level report.
Duration:
5m:54s
Views:
1461
Added:
1020 days ago
Excel - How to change the column width
Set a column to a specific width.
Change the column width to automatically fit the contents (auto fit).
Match the column width to another column.
Change the default width for all columns on a worksheet or workbook.
Change the width of columns by using the mouse.
Duration:
4m:-0s
Views:
1995
Added:
1136 days ago
Excel - How to change the row height
Set a row to a specific height.
Change the row height to fit the contents.
Change the height of rows by using the mouse.
Duration:
2m:49s
Views:
1609
Added:
1136 days ago
Excel - How to copy a chart
A brief introduction into the options you have when copying and pasting a chart from Excel to another worksheet, to a Word document or to Powerpoint presentation. Copy a chart to another workbook
location. Copy a chart by using the mouse. Copy a chart to a PowerPoint presentation. Copy a chart to a Word document. Copy a picture of a chart to another workbook location or document.
Duration:
4m:16s
Views:
2313
Added:
1123 days ago
Excel - How to print a worksheet in landscape or portait
Learn how to: Change the page orientation in the worksheet; Change the page orientation when you are ready to print; Create a template that uses landscape orientation by default
Duration:
3m:49s
Views:
1475
Added:
1123 days ago
Excel - How to save a file in Excel
In this video you will learn how to:
Save a file.
Save a file for
use in an earlier version of Office.
Save a copy of a file (Save As).
Save AutoRecover information automatically.
Duration:
4m:31s
Views:
1552
Added:
1108 days ago
Excel - How to undo, redo, or repeat an action
In this video you will learn how to:
Undo the last action or actions that you made.
Redo actions that you undid.
Repeat the last action (first add the Repeat command to the Quick Access Toolbar or
use Ctrl+Y).
Customize the Quick Access Toolbar.
Duration:
3m:43s
Views:
1449
Added:
1108 days ago
Excel - How to use Conditional Formatting - 1 of 4
Short introduction on how to
use Conditional Formatting.
Preconfigured Conditional Formats.
Highlight Cell Rules: Greater Than, Less Than, Between, Equal To, Dupicate Values.
Duration:
4m:11s
Views:
2046
Added:
1108 days ago
Excel - How to use Conditional Formatting - 2 of 4
In this video you will learn about:
Preconfigured Conditional Formats.
Format only top or bottom ranked values.
Format only values that are above or below average.
Clear conditional formats.
Duration:
4m:51s
Views:
1649
Added:
1108 days ago
Excel - How to use Conditional Formatting - 3 of 4
In this video you will learn how to:
Format all cells by using data bars.
Format all cells by using a three-color scale.
Format all cells by using a two-color scale.
Format all cells by using an icon set.
Duration:
3m:45s
Views:
1714
Added:
1108 days ago
Excel - How to use Conditional Formatting - 4 of 4
In this video you will learn how to:
Find cells that have conditional formatting applied to them.
Change conditional formatting rules that are applied on cells in your worksheet.
Duration:
5m:18s
Views:
1534
Added:
1108 days ago
Excel - How to use Page Breaks in Worksheets
In this video you will learn how to:
Insert a page break.
Move a page break.
Delete a page break.
Reset all page breaks.
Return to Normal view.
Display or hide page breaks in Normal view.
Duration:
3m:46s
Views:
1974
Added:
1108 days ago
Excel - How to use the Page Layout View - 1 of 2
In this video you will learn how to:
Use rulers in Page Layout view.
Change page orientation in Page Layout view.
Add or change page headers and footers in Page Layout view.
Set page margins in Page Layout view.
Duration:
2m:47s
Views:
2178
Added:
1108 days ago
Excel - How to use the Page Layout View - 2 of 2
In this video you will learn how to:
Hide or display headers, footers, and margins in Page Layout view.
Hide or display gridlines, row headings, and column headings in Page Layout view.
Select scaling options in Page Layout view.
Return to Normal view.
Duration:
3m:55s
Views:
2261
Added:
1108 days ago
Excel - How to use Trendlines in a chart
In this video you will learn how to:
Add a trendline.
Change the format of a trendline.
Specify the number of periods to include in a forecast.
Duration:
4m:47s
Views:
2954
Added:
1108 days ago
Flash video tutorial how to add movement to an image
Video tutorial on how to add a cool effect of motion to your text banner in a few minutes using swishmax. In this video tutorial we show you how to
use add some of the most basic effects to your
animation.
Duration:
2m:9s
Views:
3374
Added:
1100 days ago
Flash video tutorial how to create a flashbanner
Video tutorial on how to create a cool text banner in a few minutes using swishmax, we show you how to
use the basics of banner animation. Flash
animation is widely used in the digital
world. Online learning to build simple
animations, banners, interactive menus
for a website, games and full-featured
applications, is a fun fast way of
getting familiar with flash. In this
series we explore the different ways of
creating flash animations using Adobe
Flash CS4, Swishmax and Flashmenu
maker.
Duration:
4m:27s
Views:
5454
Added:
1100 days ago
General printing options
How to adjust printer settings in Microsoft Word 2007, and
use print preview. This includes duplex printing (both sides), choosing the printer, previewing, printing, options, selecting the paper,
source, page ranges, zoom, and draft view.
Duration:
5m:9s
Views:
2228
Added:
1141 days ago
How to Automatically Advance Slides in Powerpoint 2007
This video tutorial explains the settings for each slide that will allow slides to automatically advance themselves at set intervals. This causes the presentation to move itself through slides
automatically.
Duration:
3m:9s
Views:
1931
Added:
1066 days ago
How to build your first Squidoo lens
In this video tutorial we show you the basics of using the squidoo interface. You will learn how to setup a first squidoo lens and how to manage the basic tools. Squidoo is one of the most popular
tools to build a personal webpage quickly. Squidoo uses a system called lenses ( a lens is a personal webpage inside the squidoo interface). It offers a great way of sharing your knowledge with the
world and you can make money for yourself, or your favourite cause. In our essential video tutorials you will learn how to become a squidoo master
Duration:
5m:52s
Views:
1802
Added:
1048 days ago
How to Change Window Appearances in Vista
This video shows how to modify the theme that is used in Windows Vista to show windows. This will allow you to choose your own fonts, colors, etc. for the windows displayed on your screen.
Duration:
3m:27s
Views:
1331
Added:
1123 days ago
How to Change Your IP Address in Vista
This video tutorial describes the method used to change a network adapter's IP Address in Microsoft Windows Vista using the network management tools provided.
Duration:
4m:0s
Views:
28447
Added:
1123 days ago
How to Connect To A Network in Windows Vista
This video describes the process used to connect to a net work in Microsoft Windows Vista, using the built-in network management tools.
Duration:
3m:54s
Views:
4880
Added:
1123 days ago
How to Connect To A Wireless Network in Vista
This video describes the process used to connect to a wireless network in Windows Vista, using the built-in network management tools and also describes some security measures for wireless internet.
Duration:
3m:39s
Views:
2022
Added:
1123 days ago
How to Create A New User in Windows Vista
This tutorial explains the process of creating a new user in Microsoft Windows Vista, whether a regular user or an administrative user.
Duration:
3m:58s
Views:
1619
Added:
1153 days ago
How to Create A Photo Album in Powerpoint 2007
This video tutorial describes how to
use the built-in functionality of Microsoft Powerpoint 2007 to create a great looking photo album automatically.
Duration:
4m:13s
Views:
1984
Added:
1078 days ago
How to create a system disc in Windows 7.
How to create a "bootable" system disc. This can be used repair a damaged Windows seven installation or make other changes to the operating system.
Duration:
0m:54s
Views:
1786
Added:
1040 days ago
How to cure 92% of spyware problems for free.
This video tutorial covers how to cure 92% of spyware
problems completely for free. We use a powerful cocktail of spyware/malware
killing programs, using a specific method to cure your computer of spyware
infections.
You are infected with spyware if:
-
You
see too much pop-up advertisements.
-
Your
browser has toolbars that you haven't installed.
-
Your
homepage has changed (and you can't change it back).
-
Other
settings have changed without your permission.
-
Your
computer is slow.
Key points
-
All
software used is free.
-
Our
tests show this works in 92% of spyware/Malware problems.
-
Multiple
spyware/malware busting programs need to be used to cure your computer of a spyware problem with this certainty.
-
All
spyware programs must be fully updated.
-
Scans
must be done in safe mode to be fully effective.
-
Best
to disable system restore, and use disc clean-up to speed up subsequent scans.
-
Deleting
spyware programs can cause program instability (especially with shareware
programs that come with spyware).
Step 1:
Download
free software
Start by downloading Ad-Aware, AVG free, Spy-bot search and destroy,
Malwarebyte’s Anti-Malware, and Windows Defender (Vista and XP SP2 users may
have this already).
Step 2: Check add/remove, as well as switching off system restore, and run disc
clean-up.
In the Control Panel, Add/Remove Programs, comb through your installed software
list. See anything you don't recognize or need? Uninstall it. If there is
anything starting up automatically with Windows, remove it also. To do so, from
the Start menu choose "Run," and type msconfig. Review all the
programs set to start and uncheck any you don't want.
How two switch off system restore in XP:
·
Click
Start.
·
Right-click
the My Computer icon, and then click Properties.
·
Click
the System Restore tab.
·
Check
"Turn off System Restore" or "Turn off System Restore on all
drives."
·
Click
Apply.
·
When
turning off System Restore, the existing restore points will be deleted. Click
Yes to do this.
·
Click
OK
For Windows Vista:
·
Open
System by clicking the Start button, clicking Control Panel, clicking System
and Maintenance, and then clicking System.
·
In
the left pane, click System Protection. If you are prompted for an
administrator password or confirmation, type the password or provide
confirmation.
·
To
turn on System Protection for a hard disk, select the check box next to the
disk, and then click OK.
Step 3: Run a disk clean-up
This actually comes with Windows. You can find it by clicking the Start Button
and then going to Programs / Accessories / System Tools / Disk Clean-up. We
recommend selecting all of its options except the ones for Office Setup Files
and Compress Old Files if you have them. While you may select those if you
wish, they aren't as important. This will clean up all of the temporary files
so your testing will go faster, and may also delete any spyware that may hiding
there (if the spyware isn't already running).
Step 4: Install and update the anti-spyware/malware programs downloaded
earlier.
After installing them keep clicking update till you get confirmation it cannot
be updated any further.
Now everything is installed and updated, restart your computer and hit the F8
key while it is booting up. This can usually be done after the initial “splash
screen”. Then select “safe mode” and press enter. If done too soon you will get
the message “keyboard error”. In this case try again and wait longer till you
start pressing F8Choose to start the computer in "Safe Mode." You
might need to wait 10 seconds or more till you can press “F8”.
With the computer now running in safe mode, run scans with the above programs
one by one. You will notice some programs will find spyware that others have
missed. Delete or quarantine the identified files. Keep running through all the
programs till you are done. When finished restart the computer and test it out.
The above procedure works in 92% of cases. Failing that you need to re format
the hard drive and reinstall everything (which works 100% of the time !).
Duration:
7m:11s
Views:
5840
Added:
1108 days ago
How to customise the "sold item" email and use your own logo on it.
This video tutorial covers how to customise the "sold item" email and
use your own logo on it. We explain how to modify the text, and still
use AutoText feature to have personalised information (such
as the buyer's User ID) inserted automatically.
Duration:
2m:41s
Views:
1281
Added:
1093 days ago
How to delete a user ID account in Windows 7.
This video tutorial shows how to delete a user ID account, that is no longer needed. These are needed for "logging" onto the computer.
Duration:
1m:15s
Views:
1732
Added:
1037 days ago
How To Divide Text into Columns in Powerpoint 2007
This video tutorial explains how to
use the column tool to divide text into columns in Microsoft Powerpoint 2007.
Use this feature so you don't have to create multiple text boxes to layout text.
Duration:
2m:50s
Views:
2288
Added:
1015 days ago
How to Enable or Disable Services in Windows Vista
This video describes how to enable or disable services in Microsoft Windows Vista. Services are programs that run in the background that
use some system resources.
Duration:
3m:32s
Views:
1703
Added:
1099 days ago
How to Enable or Disable UAC in Windows Vista
This video describes how to enable or disable the UAC system in Vista, which is the window the pops up every now and then wanting to confirm an action you are trying to take.
Duration:
3m:45s
Views:
1649
Added:
1123 days ago
How to Enable Quick Launch in Microsoft Vista
This video describes how to turn on the "Quick Launch" bar in Windows Vista. Also, the video shows a keyboard shortcut to
use the quicklaunch even quicker than before.
Duration:
2m:52s
Views:
1549
Added:
1099 days ago
How to Enable Remote Desktop in Windows XP
This video tutorial describes how to enable remote desktop on your Windows XP PC and how to choose what users can log into the computer remotely. This video was recorded using Microsoft Windows XP
Professional Edition.
Duration:
3m:19s
Views:
3806
Added:
1108 days ago
How to enable the Magnifier in Windows Vista
This video shows how to turn on the magnifier program in Windwos Vista, that can be useful for people who have difficulting seeing what is on-screen.
Duration:
3m:28s
Views:
1563
Added:
1100 days ago
How to enable the On-Screen Keyboard in Windows Vista
This video shows how to
use the on-screen keyboard that is included in Windows Vista. The on-screen keyboard can be useful for touchscreen keyboards or in cases where the keyboard attached to a PC has
failed.
Duration:
2m:19s
Views:
2043
Added:
1099 days ago
How to insert a flash object
In this video tutorial you learn how to insert a flash object such as a menu or advert, and position and resize it in Netfusion. Netfusion is a popular webdesign package very similar in the way it is
used to Adobe Dreamweaver and Microsoft Frontpage.
Duration:
1m:41s
Views:
1967
Added:
1113 days ago
How to Link To Slides in Powerpoint 2007
This video explains how to
use hyperlinks inside your Powerpoint 2007 presentation to navigate between slides and to link directly from one slide to another slide.
Duration:
3m:53s
Views:
3266
Added:
1078 days ago
How to make Vista Look Like XP
This video describes the process to follow to change the Theme in Microsoft Windows Vista to one that may be more familiar for windows XP users.
Duration:
3m:41s
Views:
1672
Added:
1123 days ago
How to Make Windows Vista Run Faster
This video describes how to make Microsoft Windows Vista run faster by changing the video display settings, the programs that run on startup, and the way the computer uses your hard drive.
Duration:
4m:6s
Views:
1618
Added:
1153 days ago
How to make Windows XP Automatically Login
This video tutorial describes how to make Windows XP automatically log in a selected user, instead of having to type in credentials. This video was recorded using Microsoft Windows XP Professional
Edition.
Duration:
3m:1s
Views:
1709
Added:
1108 days ago
How to manage modules in your Squidoo lens
In this video tutorial you learn how to add and manage the modules of your Squidoo lens. Squidoo uses a system called lenses ( a lens is a personal webpage inside the squidoo interface). It offers a
great way of sharing your knowledge with the world and you can make money for yourself, or your favourite cause. In our essential video tutorials you will learn how to become a squidoo master
Duration:
3m:11s
Views:
1322
Added:
1048 days ago
How to manage the health module in your Squidoo lens
In this video tutorial you learn how to
use the health module in squidoo. This feature will help you optimise your Squidoo lens and make it more search engine friendly. Remember Squidoo is a great
google magnet!
Duration:
3m:2s
Views:
1352
Added:
1048 days ago
How to Manage Users in Windows XP
This video tutorial describes how to manage user accounts in Microsoft Windows XP. This video was recorded using Microsoft Windows XP Professional Edition.
Duration:
4m:19s
Views:
1751
Added:
1108 days ago
How to navigate and use the
This video tutorial explains how to
use the advanced listing features provided by ebay, including setting postage, start time, uploading, and reviewing your listing.
Duration:
4m:-0s
Views:
1308
Added:
1093 days ago
How to Print Notes from a Microsoft Powerpoint 2007 Presentation
This video tutorial describes how to
use the print feature in Microsoft Powerpoint 2007 to print out handouts where the audience can take notes, as well as to print out the notes you have put on your
slides yourself
Duration:
3m:27s
Views:
2380
Added:
1071 days ago
How to Protect Microsoft Windows XP From Viruses for Free
This video tutorial explains how to download a free antivirus program that will protect your Microsoft Windows XP computer from viruses. This program is free for non-commercial, home use, and is very
effective.
Duration:
3m:36s
Views:
2512
Added:
1063 days ago
How to Remove Spyware from Microsoft Windows XP
This video tutorial explains how to
use free software you can download from the internet to remove spyware from your computer. Spyware is software that installs itself as you browse the internet, and
can track your browsing habits and send information to servers on the internet. Remove it for free by following this tutorial.
Duration:
3m:25s
Views:
4205
Added:
1063 days ago
How to Schedule Tasks in Microsoft Windows XP
This video tutorial explains how to
use the scheduled task manage in Microsoft Windows XP to schedule a program to run on set schedules.
Duration:
3m:33s
Views:
2186
Added:
1064 days ago
How to set and adjust tab stops and indents.
How to set and adjust tab stops and indents in Microsoft Word 2007. We also cover the different types of tab stops and their uses.
Duration:
2m:41s
Views:
2239
Added:
1147 days ago
How to set Parental controls for a user ID account in Windows 7.
This video tutorial shows how to set parental controls for a user ID in Windows 7. This allows time restriction to be placed on computer use, as well as limiting games to suitable age ratings. In
addition program access can be restricted within Windows seven.
Duration:
2m:43s
Views:
1345
Added:
1037 days ago
How to set the password for a new user.
This video tutorial covers how to set a password for a user id. This prevents others form using their computer settings.
Duration:
0m:54s
Views:
2737
Added:
1039 days ago
How to Share Folders in Windows Vista
This video describes how to easily set up a shared folder on your network for other users to access your files.
Duration:
2m:52s
Views:
1623
Added:
1125 days ago
How to switch user id and "log off"
How to both log off and switch user id's thus enabling other users to share your computer without restarting it.
Duration:
1m:21s
Views:
1456
Added:
1039 days ago
How to use Accessibility Options in Windows XP
This video tutorial explains how to
use the Accessibility options such as StickyKeys that are built into Microsoft Windows XP. These options make it easier for users who have trouble using regular
keyboards to
use the computer.
Duration:
3m:21s
Views:
1589
Added:
1064 days ago
How to use borders
How to
use borders in Microsoft Word 2007 including adding borders and drawing object to a page, changing the border, and removing the border.
Duration:
1m:47s
Views:
1457
Added:
1141 days ago