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:
1177
Added:
812 days ago
04 New in Excel 2007 pt. 1
04 New in Excel 2007 pt. 1
An explanation of the new
and changed features of Microsoft 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:
909
Added:
812 days ago
05 New in Excel 2007 pt. 2
05 New in Excel 2007 pt. 2
Part 2 of the overview of the new
and changed features of Microsoft 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:
760
Added:
812 days ago
05 Quickbooks - Understanding Preferences
05 Quickbooks - Understanding Preferences
This video is part of the courses on Quickbooks 2008 that are available on www.vtc.com.
For the complete VTC course on Quickbooks 2008 click
here:
Quickbooks 2008
Duration:
4m:59s
Views:
977
Added:
812 days ago
06 Understanding the Excel 2007 Workspace
06 Understanding the Excel 2007 Workspace
An introduction to the workspace in 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:
840
Added:
812 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:
779
Added:
812 days ago
22 Dreamweaver CSS Layout - Understanding Styles
22 Dreamweaver CSS Layout - Understanding Styles
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:
552
Added:
812 days ago
3DS Max 4 - Adding and Removing Data
3DS Max 4 - Adding
and Removing Data. For more video tutorials on 3DS Max please look for the 3DS Max category on the Categories page.
Duration:
4m:59s
Views:
730
Added:
812 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:
1579
Added:
986 days ago
Attaching documents to Tasks in Project
In this video you will see how to attach a document to a task via the notes tab in task information
and displaying it as an icon,
and using the alternative method of a hyperlink.
Duration:
3m:20s
Views:
1072
Added:
913 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:
1403
Added:
932 days ago
Blog content: adding new links to your wordpress blog
This tutorial shows you how to add different links to your blog. Adding links helps making your site more interactive
and is important in promoting
and monetising other projects.
Duration:
2m:10s
Views:
991
Added:
824 days ago
Blogging - Logging In and Out
Blogging - Logging In
and Out. For more video tutorials on blogging please look for the Blogging category on the Categories page.
Duration:
4m:59s
Views:
299
Added:
812 days ago
Changing the power settings in Windows 7.
This video tutorial shows you how to adjust your power settings to make the monitor go into standby mode, or sleep, or even Hibernate.
Duration:
1m:14s
Views:
1427
Added:
931 days ago
Creating and Editing Tasks in Project 2007
In this tutorial you can see how to set the start date of your project, create tasks, reorganise, delete
and insert rows for new tasks. Also how to enter the default duration.
Duration:
5m:8s
Views:
2281
Added:
919 days ago
Creating Budgets in Project 2007
In this tutorial you will learn how to create budget resources that you can assign to your project to compare you actual hours
and costs against your budget.
Duration:
5m:31s
Views:
1893
Added:
926 days ago
Creating Durations and Elapsed time
In this tutorial you will learn how to enter different types of durations for your tasks
and how that works in conjunction with your project calendar. It also cover how to enter durations as elapsed
time
and how that works with lags (delays) between tasks.
Duration:
5m:13s
Views:
699
Added:
918 days ago
Creating Lags and Leads
In this tutorial you will see how to create lags
and leads (delays & overlaps) between tasks in a project.
Duration:
1m:28s
Views:
897
Added:
918 days ago
Creating Links between tasks in Microsoft Project 2007
This video shows how to establish links between tasks within Microsoft Project 2007, it includes creation of finish start, start start
and finish finish links, how to remove links
and create links
between non continuous tasks.
Duration:
4m:27s
Views:
2718
Added:
928 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:
1308
Added:
913 days ago
Cut, Copy, Paste, paste options and clipboard
This tutorial shows you how to cut copy
and paste in Word 2007 including multiple cut or copy using the Clipboard. It also shows you the paste options smart tag.
Duration:
6m:43s
Views:
2652
Added:
927 days ago
Ebay advanced search
This video tutorial explains how to perform an advanced search on ebay,
and filter out unnecessary listings. We also show how to revise a basic search to filter out the results to display your
intended information.
Duration:
5m:35s
Views:
1698
Added:
986 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:
1895
Added:
1015 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:
2468
Added:
1015 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:
1342
Added:
1015 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:
1303
Added:
1001 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:
1918
Added:
1001 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:
2069
Added:
1001 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:
4944
Added:
992 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:
2026
Added:
1033 days ago
How to Add Background Music to Powerpoint 2007
This video tutorial explains how to add in background music to a Microsoft powerpoint 2007 presentation. Sometimes you want to have a sound play throughout the entirety of your presentation,
and this
describes how to do so.
Duration:
3m:15s
Views:
2671
Added:
970 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:
2917
Added:
1005 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:
1840
Added:
970 days ago
How to build a Java menu with Ultramenu.
How to build a linkable Java menu with Antssoft's Ultramenu. Including how to create submenu's
and create the Java code.
Duration:
4m:47s
Views:
1531
Added:
1019 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:
1698
Added:
940 days ago
How to Change Slide Orientation in Powerpoint 2007
Sometimes you are working on a presentation in Microsoft Powerpoint 2007
and feel that the information would be best suited in a "portrait" layout as opposed to a landscape layout. This video
describes how to change the orientation of your slides in Powerpoint 2007.
Duration:
3m:19s
Views:
1882
Added:
970 days ago
How to chose MS Word save file types.
Explain how to convert files from one format to another,
and save in different file formats for best cross computer compatibility.
Duration:
2m:10s
Views:
1655
Added:
1005 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:
2825
Added:
957 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:
1906
Added:
1000 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:
3316
Added:
957 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:
1902
Added:
1015 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:
1484
Added:
930 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:
3884
Added:
981 days ago
how to create a realistic gold effect
This video tutorial shows how to make a realistic gold effect in adobe photoshop, using layers
and brush tools
Duration:
3m:21s
Views:
3504
Added:
981 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:
1799
Added:
1033 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:
1641
Added:
992 days ago
How to create and modify an ebay watched item list.
This video tutorial covers how to create
and an ebay watched item list. Also we explain how to customise the watched item list in the "my ebay" section of the site.
Duration:
1m:49s
Views:
1197
Added:
986 days ago
How to create bulleted or numbered lists
How to create bulleted or numbered lists in Microsoft Word 2007, including including: formatting changes, multilevel lists,
and bullet changes.
Duration:
1m:40s
Views:
1234
Added:
1033 days ago
How to create Headers and footers
How to create Headers
and footers in Microsoft Word 2007
and adjust settings for odd
and even pages.
Duration:
1m:34s
Views:
2509
Added:
1005 days ago
How to create tables
How to insert
and draw tables Microsoft Word 2007 as well as convert text to a table.
Duration:
2m:30s
Views:
1243
Added:
1033 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:
5113
Added:
1001 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:
1203
Added:
986 days ago