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:
919 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:
597
Added:
919 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:
1047
Added:
919 days ago
14 Using Microsoft Office On-line in Excel 2007
14 Using Microsoft Office On-line in Excel 2007
If you have not found the answer to your question in the Help function within Excel 2007 then you can consider using Microsoft On-Line to find your
answers.
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:
1010
Added:
919 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:
1249
Added:
1020 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:
2415
Added:
1026 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:
2208
Added:
1033 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:
773
Added:
1025 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:
965
Added:
1025 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:
2902
Added:
1035 days ago
Creating Milestones in Project 2007
In this video you will see how to create milestones in Project 2007 to mark deliverables or the closure of a project etc that do not require a duration. It also shows the milestone report.
Duration:
2m:44s
Views:
1683
Added:
1026 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:
1457
Added:
1020 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:
2969
Added:
1034 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:
1994
Added:
1136 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:
2242
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:
2311
Added:
1122 days ago
Excel - How to create, delete, move or resize a chart
Learn how to: Create a Chart from a simple set of data. Pick the Chart Type. Pick the Chart Source Data. Show some of the Chart options. Pick the Chart Location. Move or resize a chart. Delete a
Chart.
Duration:
3m:14s
Views:
2320
Added:
1122 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:
2957
Added:
1122 days ago
Excel - How to insert bullets in a worksheet
Learn how to: Insert bullets in a worksheet.
Unlike Microsoft Office Word, Excel does not provide a button to create a bulleted list in text. To add bullets to worksheet text, you need to insert a symbol.
Duration:
3m:57s
Views:
4517
Added:
1122 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:
1474
Added:
1122 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:
1551
Added:
1108 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:
1580
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:
1446
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:
2044
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:
1646
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:
1713
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:
1533
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:
2176
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:
2259
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:
2950
Added:
1108 days ago
Excel - How to work with Print Areas
In this video you will learn how to:
Set a print area on a worksheet.
Add cells to an existing print area.
Clear a print area.
Duration:
3m:55s
Views:
1624
Added:
1108 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:
1065 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:
1801
Added:
1047 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:
5834
Added:
1108 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:
966 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:
1321
Added:
1047 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:
3982
Added:
1093 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:
1453
Added:
1038 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:
1122 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:
2230
Added:
1034 days ago
MS Vista Logging Off
MS Vista Logging Off<. For more video tutorials on MS Vista please look for the MS Vista category on the Categories page.
Duration:
4m:59s
Views:
771
Added:
919 days ago
Navigation and Selection techniques
This tutorial shows you how to navigate around a Word document and use the mouse and keyboard to select text, also shows how to select random words throughout the document.
Duration:
5m:34s
Views:
1142
Added:
1034 days ago
Opening, closing and Saving Word 2007 documents
This tutorial shows you how to open close and save documents in Word 2007 on a Vista operating system, it shows the recent documents and how to pin documents to it.
Duration:
4m:55s
Views:
2615
Added:
1034 days ago
Photoshop removing acne
How to get rid
off acne using photoshop. Retouching looks on a face video tutorial
Duration:
5m:26s
Views:
1264
Added:
1136 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
Starting and New Features of Project 2007
This tutorial shows you how to start Project 2007 and the new features in this version compared to 2003. Also tells you the difference between Standard and Professional versions.
Duration:
9m:45s
Views:
1280
Added:
1033 days ago
The affect of task types when assigning resources
In this video you will see how to change task types when assigning multiple resources to accommodate your schedule and the options associated with them.
Duration:
7m:2s
Views:
1119
Added:
1019 days ago
Using Drag & Drop in Word 2007
This tutorial shows you how to use drag and drop to copy and move text within a Word 2007 document, it also show you the show hide button to display paragraph marks.
Duration:
2m:30s
Views:
6442
Added:
1034 days ago