10 Excel 2007 - Considerations Before You Install
10 Excel 2007 - Considerations Before You Install
Watch this video before you install Microsoft Excel 2007 on you PC.
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:
540
Added:
915 days ago
11 Installing Excel 2007
11 Installing Excel 2007
This video offers you a guide through the installation of Excel 2007.
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:
592
Added:
915 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:
1981
Added:
1131 days ago
Excel - How to change the layout or style of a chart
Make changes to an existing chart.
Apply a predefined chart layout.
Apply a predefined chart style.
Change the layout of chart elements manually.
Change the format of chart elements manually.
Duration:
5m:3s
Views:
2213
Added:
1131 days ago
Excel - How to enter the same data into several cells at the same time
Enter data in: A single cell, A range of cells,
All cells on a worksheet, Nonadjacent cells or cell ranges, An entire row or column, Adjacent rows or columns, Nonadjacent rows or columns
In the active cell, type the data, and then press CTRL+ENTER.
Duration:
4m:23s
Views:
2937
Added:
1118 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:
1545
Added:
1103 days ago
Excel - How to scale a worksheet for printing
In this video you will learn how to scale a worksheet for printing:
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:38s
Views:
1579
Added:
1103 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:
1704
Added:
1103 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:
1964
Added:
1103 days ago
How to add or delete fill effect such as textures, 3d, gradients, pictures etc.
In this video tutorial you learn how to add or delete fill effect such as texture, gradients, and pictures in Microsoft Word 2007Microsoft Word 2007 brings us lots of new features. From a new
interface to timesaving content galleries. In Microsoft Word 2007 Essential Video Tutorial series we explain the new features and attributes, from understanding and navigating its new interface, to
using new formatting controls and extensive page layout techniques. This tutorial series is ideal for those new to Word or people that want to learn about the new version.
Duration:
3m:3s
Views:
3210
Added:
1108 days ago
How to Add Or Remove Programs in Vista
This video describes how to access an interface similar to the "Add/Remove Programs" interface that existed in previous versions of Microsoft Windows, from Windows Vista.
Duration:
3m:13s
Views:
1783
Added:
1118 days ago
How to add Search Providers in Microsoft Internet Explorer 8
This video tutorial explains how to add a new search provider to the search bar in Microsoft's Internet Explorer 8 web browser. This allows you to search different sites quickly, without having the
first visit the site.
Duration:
2m:7s
Views:
1549
Added:
1018 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:
1924
Added:
1061 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:
1793
Added:
1043 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:
1327
Added:
1118 days ago
How to Clean Out Old Files in Microsoft Windows XP
This video tutorial explains how to clear out old files such as old setup files, temporary internet files, and other file types in your Microsoft Windows XP installation.
Duration:
4m:50s
Views:
3285
Added:
1059 days ago
How to compare items on ebay.
The video tutorial covers how to compare auction listings on ebay. This enables
all the features of the two items to be compared side by side.
Duration:
1m:12s
Views:
1486
Added:
1088 days ago
How to Configure the Microsoft Windows XP Firewall
This video tutorial explains how to configure the Microsoft Windows XP firewall. The firewall built into Microsoft Windows XP is capable of blocking unwanted connections to your computer, while still
allowing you to set exceptions for programs and ports you want to allow out.
Duration:
3m:31s
Views:
3609
Added:
1059 days ago
How to create a homegroup in windows seven.
How to craete a homegroup in Windows 7. This allows files sharing and other advanced features such as installing printer drivers on other computers connected to the homegroup.
Duration:
1m:51s
Views:
1650
Added:
1032 days ago
How to create a metal plate effect
In this video tutorial we go through the steps needed to create a realistic metal plate from scratch using adobe photoshop. The concepts in this video tutorial are aplicable to
all the diferent
versions of adobe photoshop, including cs2, cs3 and cs4.
Duration:
6m:9s
Views:
4359
Added:
1084 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:
1980
Added:
1073 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:
1779
Added:
1035 days ago
How to create a watermark or background
How to make text and picture watermarks, and change page colour, and add fill effects with Microsoft Word 2007
Duration:
2m:12s
Views:
1929
Added:
1136 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:
5814
Added:
1103 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:
1280
Added:
1088 days ago
How to email a picture on an iPhone (all versions).
This video tutorial covers how to email a picture (from the camera roll) on an iPhone to another contact. The picture will automatically be resized and brought into the emailing application.
Duration:
1m:29s
Views:
2040
Added:
1023 days ago
How to enable airplane mode on an iPhone (all versions).
This video tutorial covers how to enable airplane mode and discusses its benefits. Airplane mode disables wi-fi, cellular data transfer, gps, and Bluetooth. It is a common requirement on plane
flights.
Duration:
1m:23s
Views:
1461
Added:
962 days ago
How to Insert Excel Spreadsheet in Powerpoint 2007
This video tutorial explains how to insert an excel spreadsheet into Microsoft Powerpoint 2007. This allows you to modify a spreadsheet directly into the Powerpoint 2007.
Duration:
2m:19s
Views:
4625
Added:
1005 days ago
How to install Powerpoint 2007 Viewer
This video tutorial explains how to install the Microsoft Powerpoint 2007 viewer program in Microsoft Windows Vista.
Duration:
2m:3s
Views:
2526
Added:
1005 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:
1708
Added:
1103 days ago
How to Manage Hardware in Microsoft Windows XP
This video tutorial explains how to manage the hardware in your computer. It shows how to uninstall hardware that may be installed incorrectly or malfunctioning, as well as how to disable and enable
installed hardware.
Duration:
3m:29s
Views:
1800
Added:
1059 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:
1317
Added:
1043 days ago
How to Map a Network Drive in Microsoft Windows XP
This video tutorial shows the process you should follow to map a drive to a network device. Mapping a drive to a network device allows you to access files on a network share just as though they were
stored on your PC.
Duration:
2m:58s
Views:
1637
Added:
1059 days ago
How to optimise your selling on ebay - to make the most money
This video tutorial explains how to get the most money from an ebay auction. The information in this video will tell you how, with a few tweaks to the picture, title, and descriptive text, you can
maximise your profits on ebay.
Key points:
• The more people see your listing the more money you will get – bidding war.
• There are 3 key areas to focus on – The picture, the title text, and the descriptive text.
• Picture and title are
all most people will see.
• Picture should show the item in the best way i.e. Shiny, and clean, in good light.
• Picture should have a plain background.
• Title should be detailed, with some key details, and unique selling points.
• Description should have item technical information at the bottom (copied and pasted from the official site).
• Should have unique selling points emphasised i.e. What makes this item so special.
• People buy items based on an emotional decision, not technical decision. Tell them how great the item looks / performs/ feels / works.
• Make some honest points about marks / scratches, this builds bidder confidence and makes bidders more likely to commit to buying.
Duration:
5m:1s
Views:
3969
Added:
1088 days ago
How to Rehearse Timings in Microsoft Powerpoint 2007
This video tutorial explains how to rehearse timings in Microsoft Powerpoint 2007. Timings allow you to play through your slide show and see how much time will be spent on each slide.
Duration:
2m:8s
Views:
1836
Added:
1005 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:
4195
Added:
1058 days ago
How to restore a backup of your iPhone (all versions).
This video tutorial shows you how to restore a backup your iPhone in order to put old music, pictures and contact data back on the phone after having a problem. It also restore the OS back to its
default.
Duration:
1m:7s
Views:
15064
Added:
1007 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:
1340
Added:
1032 days ago
How to Set Program Compatibility
This video describes the process of choosing compatibility options for a program that is installed on your hard drive. Some programs require certain operating systems to run, and this will allow you
to get around that restriction in Vista.
Duration:
3m:19s
Views:
1398
Added:
1118 days ago
How to set the wallpaper with an iPhone (all versions)
This video tutorial covers how to set the wallpaper on an iPhone. This enables you to personalise the first page your iPhone displays (with the “slide to unlock” tab).
Duration:
1m:32s
Views:
1387
Added:
1023 days ago
How to Set Up Trusted Locations
This video tutorial explains how to configure trusted locations in Powerpoint 2007. Trusted locations allow macros to run in certain folders.
Duration:
2m:53s
Views:
1388
Added:
1005 days ago
How to Transfer My Documents to Another Location
This video tutorial explains how to transfer My Documents from the default folder to another folder such as a network location. This can allow you save files to My Documents as though they were on
your local machine, but instead it is saving to a network file server.
Duration:
2m:15s
Views:
1674
Added:
1059 days ago