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
3DS Max 4 - Pop Menu Group
3DS Max 4 - Pop Menu Group. For more video tutorials on 3DS Max please look for the 3DS Max category on the Categories page.
Duration:
4m:59s
Views:
538
Added:
920 days ago
3DS Max 4 - Starting max4 for the First Time
3DS Max 4 - Starting max4 for the First Time. For more video tutorials on 3DS Max please look for the 3DS Max category on the Categories page.
Duration:
4m:59s
Views:
475
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
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
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 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:
1581
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 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
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 add Mapping to Microsoft Internet Explorer 8
This video tutorial explains how to add in a mapping add-on to Microsoft Internet Explorer 8. This add-on will let you pull
up maps very quickly just by using the text on web pages.
Duration:
2m:36s
Views:
1656
Added:
1022 days ago
How to add Shapes to Powerpoint 2007 Slides
This video tutorial explains how you can draw directly on top of a slide in Microsoft Powerpoint 2007 using shapes. There are many default shapes in powerpoint to choose from, and you can spruce up
your slides using them.
Duration:
2m:33s
Views:
2038
Added:
1078 days ago
How To Add Sounds To Transitions in Powerpoint 2007
This video tutorial explains how to add sound to a transition in Microsoft Office Powerpoint 2007. Spruce
up the changes between slides not only with a transition, but also with sound!
Duration:
3m:20s
Views:
1292
Added:
1066 days ago
How to Add Transitions To Slides in Microsoft Powerpoint 2007
This video tutorial explains how to add transitions to your slides in Microsoft Powerpoint 2007. This spruces
up the changes between slides as well as add a professional touch to your presentation.
Duration:
4m:5s
Views:
2502
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 check if your computer has a homegroup setup
This video tutorial demonstrates how to check if you computer has a homegroup set-up. This is needs to be determined in order for other computers to join the homegroup.
Duration:
1m:51s
Views:
1466
Added:
1037 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:
3308
Added:
1064 days ago
How to Clean Up a Hard Disk in Windows XP
This video tutorial describes how to clean
up the files and folders that are on your hard disk on your computer. This video was recorded using Microsoft Windows XP Professional Edition.
Duration:
4m:13s
Views:
2059
Added:
1108 days ago
How to configure Automatic Updates In XP
This video tutorial describes how to configure automatic updates in Microsoft Windows XP. This video was recorded using Microsoft Windows XP Professional Edition.
Duration:
3m:49s
Views:
1407
Added:
1108 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:
3617
Added:
1064 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 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:
1657
Added:
1037 days ago
How to create an Administrator Command Prompt
This video shows how to open
up a command line prompt in "administrator" mode in Microsoft Windows Vista. The tip shown here will apply to any program in Vista.
Duration:
2m:50s
Views:
1756
Added:
1100 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 defragment the hard drive in Windows 7.
How to check and defragment the hard disc with windows 7. This helps optimise the speed and performance of the hard drive, helping speed
up your computer.
Duration:
0m:57s
Views:
1791
Added:
1039 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 or Disable Windows Updates
This video describes how to enable or disable the Windows Updates features that are included in Microsoft Windows Vista.
Duration:
4m:2s
Views:
1645
Added:
1125 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 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 Navigate Files and Folders in Windows XP
This video tutorial describes how to navigate, clean up, create and modify folders in Windows XP. This video was recorded using Microsoft Windows XP Professional Edition.
Duration:
4m:42s
Views:
1849
Added:
1108 days ago
How to register for ebay.
This video tutorial covers how to register with ebay, and get started with their site.
Duration:
2m:32s
Views:
1432
Added:
1093 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:
15115
Added:
1012 days ago
How to Set Environment Variables in Windows XP
This video describes how to set
up environment variables in Windows XP and how to set their values. This video was recorded using Microsoft Windows XP Professional Edition.
Duration:
3m:9s
Views:
1881
Added:
1108 days ago
How to set Power Options in Windows XP
This video describes how to set
up the power options in Microsoft Windows XP to save battery life on laptops and configure when your computer goes into power save mode. This video was recorded using
Microsoft Windows XP Professional Edition.
Duration:
3m:15s
Views:
1847
Added:
1108 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:
1399
Added:
1010 days ago
How to set Windows Appearance and Themes in Windows XP
This video tutorial describes how to set
up themes and windows appearance settings in Microsoft Windows XP.
This video was recorded using Microsoft Windows XP Professional Edition.
Duration:
3m:18s
Views:
2180
Added:
1108 days ago
How to setup your iPhone to maximise battery life.
This video tutorial shows you how to setup your iPhone to maximise battery life. We do this by customising the screen brightness, and adjusting the frequency the iPhone connects to the internet to
check for emails.
Duration:
2m:25s
Views:
1066
Added:
1023 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 sign up to youtube
How to register with youtube, so you can upload video's.
Duration:
2m:34s
Views:
1477
Added:
1135 days ago
How to update windows 7, and check the auto update settings.
This video tutorial covers how to update windows seven to the latest version, and check the auto update feature. This allows you to both choose the time and frequency windows looks for new updates.
Duration:
1m:19s
Views:
8120
Added:
1039 days ago
How to upload HD video's to youtube
In this video tutorial we show you how to upload HD video's to youtube. This includes information on encoding settings to minimise upload time. It also covers youtube recommended upload settings.
Duration:
2m:6s
Views:
2230
Added:
1135 days ago
How to Use Custom Bullet Points in Powerpoint 2007
This video tutorial explains how to use any image as your bullet point image in Microsoft Powerpoint 2007. This way you can spruce
up your lists, without using the bland bullets allowed by default.
Duration:
2m:25s
Views:
3770
Added:
1015 days ago
How to Use Outlook Express in Windows XP
This video describes how to set
up Outlook Express in Windows XP to view your email from an external email server. This video was recorded using Microsoft Windows XP Professional Edition.
Duration:
4m:40s
Views:
2107
Added:
1108 days ago
How to use the Windows Firewall in Vista
This video describes how to use the Windows Firewall in Microsoft Vista and goes over turning the firewall on or off as well as adding exceptions to the firewall block list.
Duration:
4m:6s
Views:
2383
Added:
1123 days ago
How to use the Windows XP Transfer Wizard
This video tutorial shows how to use the Transfer Wizard in Microsoft Windows XP to copy files and settings from one Windows XP computer to another. You can save your files and settings to a CD or
file folder and then copy them
up to a new machine very easily.
Duration:
3m:41s
Views:
2958
Added:
1064 days ago
How to use Windows Backup in Vista
This video describes how to use the Windows Backup system in Microsoft Windows Vista that is written to maintain scheduled backups of your files.
Duration:
3m:1s
Views:
1686
Added:
1123 days ago
How to use Windows Readyboost in Vista
This video describes how to use the Windows Readyboost system included in Microsoft vista. It uses a removable media to speed
up access to memory on your PC.
Duration:
3m:7s
Views:
1753
Added:
1125 days ago
How to use Windows Updates in Microsoft Vista
This video shows how to use the Windows Update feature that is included in Microsoft Windows Vista to keep your computer up-to-date automatically and manually.
Duration:
3m:27s
Views:
2306
Added:
1099 days ago
Insert and Edit Text
This tutorial shows insert and overtype mode and how to edit text using the font group and the mini toolbar.
Duration:
4m:38s
Views:
2231
Added:
1034 days ago
Manage multimedia: How to embed video into your blogpost
In this video tutorial on blogging we go through the basics of embedding video in your blog using the wordpress dashboard in Wordpress. In our Essential video tutorials on
blogging you will learn the basics of
creating your own blog. You will learn
how to set
up a blog. How to add or
embed video. How to change the style,
add graphics. How to add posts, add
polls and manage blog widgets.
Duration:
2m:41s
Views:
2447
Added:
1086 days ago
Photoshop ad banner
In this video tutorial we create an attractive advertisement banner in photoshop. Photoshop is one of the most powerful image editors, and it can be daunting to try to use skillfully. Our essential
video tutorial series on Photoshop is a popular and comprehensive series. It follows our photoshop guru, Albert Chen, as he explores different aspects of of Photoshop. He explores most of Photoshops
important and daunting features, such as the Levels and Curves commands, edge-detection filters, advanced compositing techniques, vector-based graphics, the Liquify filter, and many more. Albert also
teaches tried-and-true methods for sharpening details, touching
up photos, removing acne and other imperfections and creating wonderful textures and photorealistic pictures from scratch. The
principles shown in this series apply to most of the popular versions in the photoshop range, including Photoshop cs2, cs3 and cs4.
Duration:
6m:6s
Views:
4325
Added:
1138 days ago
Setting up the Project Calendar
In this video you will see how to change the standard calendar and how to create your own company calendar, also how to check that it is working correctly by assigning a resource to a task and looking
in resource usage view.
Duration:
5m:23s
Views:
1436
Added:
1016 days ago
Setting up Work Resources
In this video you will see how to set
up your work resources in the resource sheet including all the resources information, cost rate table for uplifts and different rates dependant on job. Also how
to create the resources calendars and other resource calendars so you can assign a calendar to lots of resources. The calendar section is only applicable to 2007 as it is a new calendar, the rest of
the information applies to any version.
Duration:
8m:59s
Views:
1127
Added:
1016 days ago
Using system resore to
This video tutorial shows you how to roll back your computer to a previous system set-up. This is especially useful if a fresh installation of a program has created a conflict.
Duration:
1m:9s
Views:
1687
Added:
1038 days ago
Viewing the Critical Path
In this video you will see how to display the critical path in your project and how to group and filter same. It also shows the Critical Task Report and options for controlling how the critical path
works in your project.
Duration:
5m:52s
Views:
1509
Added:
1020 days ago