Everything Else
How To: Turn off AutoCorrect symbols in Excel
In this Excel magic trick video the instructor shows how to stop automatic copyright symbol ©. While using Microsoft Excel when you type the letter c in between a pair of curved braces Excel automatically turns it into the copy symbol © even if we did not intend to use it. Now to get rid of this feature go to the file menu and then to the options menu. In the options window that pops up go to the proofing sub menu and there is a button for auto correct options. Go into it and it shows the lis...
How To: Format dates & calculations in Excel
This is an Excel magic trick video in which the instructor shows how is time represented in Excel and how it is formatted before displaying it to us. He talks about the decimal representation of the time. He says that if O hour is mapped to the number zero and 24th hour of a day is mapped to number one then we can represent any time of the day in the format of a decimal number between zero and one. He shows the type of formatting that excel uses to convert the decimal number into a human read...
How To: Create a histogram using data analysis in Excel
A histogram is a summary graph showing a count of data points that fall in various ranges. Histograms are used in statistics and other forms of mathematics. In this video, learn how to create your own histogram using data analysis on the computer. This tutorial will show you how to create a frequency distribution, a cumulative frequency distribution, a histogram chart and an ogive chart with the data analysis add-in.
How To: Reverse two way lookup for date & time in Excel
In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...
How To: Use INDIRECT, TEXT, and SUBSTITUTE in Excel
ExcelIsFun will show you how to use indirect text and substitute in Excel. Select any date and product and create an intersession. Use Vlookup to look up your columns. Use the match function to find the value range. To do the same thing with dates, highlight the dates and names. You then let the name look for indirect. Your space operator tells you two ranges to find the intercept. Take the text and substitute for the dashes. Use the text function on the value and format it.
How To: Calculate proportions and percentages in Excel
This Excel Statistics series of video shows how to calculate proportions and percentages in Microsoft Excel. This video shows how to do percentage calculations using formulas in Microsoft Excel. To make a formula for a percentage, you need to first make a formula to calculate the total sum of objects you are going to use. To do that, use the sum formula. Now, divide the current object's value with the previously generated sum formula, which gives you the frequency. When you multiply this by 1...
How To: Use PivotTable to group data in Excel
Excel Fun will show you how to get the most out of your Excel experience by learning about pivot tables. With Excel and the latest Excel 2010 you can learn how to create a pivot table. Learn where in the system to go to find the table. Learn how to add our numbers and create a calculation and watch it being solved. Your instructor will go through a detailed equation so that you can see how to do your own calculation.
How To: Use YEARFRAC, INT, and DATEDIF in Excel
In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one has worked if we know his starting date and ending date i.e. he shows how to extract the difference in years directly by using formula to calculate it. He shows how to use Yearfrac function which gives the number of years in decimal form. He also shows how to extract integer from the decimal using ...
How To: Download a free beta version of Microsoft Office
This how to video describes how to download and install a free beta version of Microsoft Office. This video directs you to a Microsoft site that allows you to download the beta version of Office. The author warns you that this is the beta version of Office and that the software is still in the testing phase and is prone to many bugs and unknown problems and issues. This video is perfect for the penny pincher or those who want to be on the bleeding edge of technology.
How To: Use Microsoft Word to create a brochure
Rod Milstead brings us a video on how to create a brochure in Microsoft Word. He shows us how to navigate Microsoft Word in order to create the brochure. He gives us step by step instructions on how to get a general template to work with. Then he explains how to work with the template once you have pulled it up. He shows us that it is a two page document and that page one in the outside and page two is the inside. He says that while it might be a little hard to use at first, once you get used...
How To: Use OR, ISNUMBER and ISTEXT in Excel
ExcelIsFun shows you how to detect if a cell has a number or text. The first thing he explains is to find out what are the different types of things that can go into a cell. Next he talks about the use of "OR" and "IsNumber" to make it possible to determine if a cell has a number or text entered into it. The user then explains why certain rows where either "True" or "False". After watching this video, you should be able to determine if a cell is using text or a number.
How To: Add custom number formats to a cell in Excel
In this video the author shows how to perform custom number format for turnover ratio in a Microsoft excel document. He shows how to perform custom number formatting in which he shows how to display a decimal value in words. He opens the Format Cells option and there he shows how to set the Custom option. He shows how to configure different options so that we can format the decimal value and display it as text with some meaning attached to it. In this video the author shows how to use custom ...
How To: Create a Powerpoint presentation
Need to make a Powerpoint presentation and you're not sure where to begin? In this three-part video tutorial, learn how to make a Powerpoint presentation from start to finish. A Powerpoint presentation is a great way to enhance a school project and impress your teacher!
How To: Repeat a list of names 7 times in Excel
The ExcelIsFun shows how to repeat a list of names seven times. He starts out by telling you a fast way to do this. He starts out by selecting the names already typed in then he presses Control C (Ctrl + c) on the keyboard. The next thing he does is move the cursor to a different column and in the first row. He presses Control V (Ctrl + v) to paste the names into the other column. By watching this video, you will find out how to quickly repeat a list of names 7 times or more.
How To: Use Excel keyboard shortcuts
This video is all about the keyboard shortcuts that are used in Microsoft Excel of the latest version. If you really need speed and efficiency then watch this video for its shortcut keyboard buttons. After typing all the data, if you need to see the page setup with the help of the mouse than it will take a pretty long time. By opting for keyboard shortcuts you can save much of your time and can invest it in another work. If you press 'alt' button then it will show keyboard shortcuts on the sc...
How To: Use Excel to do math
This video describes how to use excel basics formulas to do math. Shows how to create new formulas so that you can complete math functions and how many formulas in excel work. Each step is displayed step by step with an explanation on what is going on so it may be understood. Keyboard short cuts among other tips and trick to help you navigate through microsoft's excel. After this video you would be able to use excel to do a variety of functions to complete math equations.
How To: Print double-sided and reverse printing order in Word
Learn how to print double-sided and reverse printing order in Microsoft Word. * Go to the Start menu and open Microsoft Word.
How To: Add citations & bibliographies in MS Word 2007
This video tutorial will show you how to add citations and bibliographies in MS Word 2007. 1. Select desired text.
How To: Create a database in Microsoft Access
In this six-part video tutorial, learn how to create an access database. The following six parts go over the following:
How To: Manage loans with an amortization table in Excel
In this three-part video tutorial, learn how to manage loans with an amortization table in Excel. The three parts of this video go over the following:
How To: Alphabetize in Excel
Need to sort a ton of data in Excel? Why waste time cutting and copying cells? In this tutorial, learn how make Microsoft Excel automatically sort columns or rows alphabetically.
How To: Alphabetize lists of words in Microsoft Word
Chronology in Microsoft Word is convenient when it comes to organizing your documents. Thankfully, you don't have to manually edit the document to put things in alphabetical order! This video shows you how to do it in a few clicks.
How To: Use Document Map to navigate writing in Microsoft Word
This tutorial is a great eye-opener into the world of Microsoft Word. If you thought you could just open Microsoft Word and type, you are not taking full advantage of what the system has to offer. Iain Broome shows you how to use the Document Map feature on Micosoft Word to your best advantage for any writing project. For more video tips on Microsoft Word, search for Microsoft Word on WonderHowTo.
How To: Choose a theme for your Word 2007 document
This video demonstrates how to choose a theme for your Word 2007 document. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to choose a theme for your Word 2007 document, For Dummies.
How To: Work with PowerPoint themes
This video demonstrates how to work with PowerPoint themes. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to work with PowerPoint themes, For Dummies.
How To: Format a paragraph in Word 2007
This video demonstrates how to format a paragraph in Word 2007. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to format a paragraph in Word 2007, For Dummies.
How To: Record a macro in Excel 2007
This video demonstrates how to record a macro in Excel 2007. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to record a macro in Excel 2007, For Dummies.
How To: Use PowerPoint presentation slide masters
This video demonstrates how to use PowerPoint presentation slide masters. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to use PowerPoint presentation slide masters, For Dummies.
How To: Make multiple changes at once with Word 2007 themes
This video demonstrates how to make multiple changes at once with Word 2007 themes. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to make multiple changes at once with Word 2007 themes , For Dummies.
How To: Edit headers and footers in Word 2007
This video demonstrates how to edit headers and footers in Word 2007. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to edit headers & footers in MS Word 2007, For Dummies.
How To: Run macros in Excel 2007
This video demonstrates how to run macros in Excel 2007. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to run macros in Excel 2007, For Dummies.
How To: Add a data table to an Excel 2007 chart
This video demonstrates how to add a data table to an Excel 2007 chart. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to add a data table to an Excel 2007 chart, For Dummies.
How To: Create a pivot table in Excel 2007
This video demonstrates how to create a pivot table in Excel 2007. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to create a pivot table in Excel 2007, For Dummies.
How To: Create a pivot chart in Excel 2007
This video demonstrates how to create pivot chart in Excel 2007. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to create pivot chart in Excel 2007, For Dummies.
How To: Create a graph or chart in Excel 2007
This video demonstrates how to create a graph or chart in Excel 2007. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to create a graph or chart in Excel 2007, For Dummies.
How To: Add hyperlinks to a PowerPoint presentation
This video demonstrates how to add hyperlinks to a PowerPoint presentation. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to add hyperlinks to a PowerPoint presentation, For Dummies.
How To: Record narration for a PowerPoint presentation
Need to record narration for a PowerPoint presentation. Watch this video to learn how. Adding narration to PowerPoint presentations is easier than it sounds. You can record your voice to narrate your slide show and then link to or embed the sound file to your presentation. This video shows you the steps. Record narration for a PowerPoint presentation.
How To: Add video to a PowerPoint presentation
Check out this lesson from Dummies.com on how to add videos to your PowerPoint presentations. This is easy and greatly enhances your slideshow. Make your presentation extra engaging and professional by integrating video.
How To: Create tables in Word 2007
This video demonstrates how to create tables in Word 2007. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to create tables in Word 2007, For Dummies.
How To: Convert text to table in Word 2007
This video demonstrates how to convert text to table in Word 2007. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to convert text to table in Word 2007, For Dummies.